翻訳と辞書 |
DiffEngineX
DiffEngineX compares two Excel spreadsheets and reports their differences.〔CNET Editors' review (), 27 February 2012. Retrieved on 11 December 2012.〕〔Chambers, Chris, Martin Erwig, and Markus Luckey. "SheetDiff: A tool for identifying changes in spreadsheets." IEEE Int. Symp. on Visual Languages and Human-Centric Computing.(), September 2010. Retrieved on 11 December 2012.〕〔Harutyunyan, Anna, et al. "Planted-model evaluation of algorithms for identifying differences between spreadsheets." engr.oregonstate.edu (), 2012. Retrieved on 11 December 2012.〕〔McKay, S. Kyle. Reducing Spreadsheet Errors. No. ERDC-TN-EMRRP-EBA-03. Corps Of Engineers Washington DC Ecosystem Management And Restoration Research Program (), September 2009. Retrieved on 11 December 2012.〕 It compares cells (formulae, constants and calculated values), comments, defined ranges (names) and Visual Basic for Applications (VBA) macros. Before a cell-by-cell comparison, similar rows and columns between two spreadsheets have to be aligned by the insertion of blank rows/columns. Otherwise identical cells between two workbooks will be missed. It runs on Microsoft Windows. ==Excel Spreadsheets== A spreadsheet is essentially a grid made up of rows and columns. New rows and columns can be inserted into a workbook with existing content. Row insertion pushes all the content below it down. Column insertion pushes content after it to the right. Excel workbooks support both relative and absolute cell references, which refer to other cells. References allow formula to use the content of other cells in their calculations. An absolute reference refers to a specific cell with a fixed row and column reference. This reference never varies when copied into other cells. A relative reference refers to a cell a certain displacement from the current cell. The cell referred to can change when the formula is copied or displaced into other cells.
抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)』 ■ウィキペディアで「DiffEngineX」の詳細全文を読む
スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース |
Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.
|
|