Skip to main content
Geographic Information Systems

Return to Question

Tweeted twitter.com/#!/StackGIS/status/591121498817048576
edited title
Link
underdark
underdark
  • 84.5k
  • 22
  • 233
  • 415

Calculated How to preserve formulas in XLS cells when working in xlsQGIS?

Edited formatting
Source Link
Joseph
Joseph
  • 76.3k
  • 7
  • 172
  • 286

calculated Calculated cells in xls

Opening Layerslayers directly from XLS spreadsheets is a very useful (if not well documented) feature of QgisQGIS, but I don'tcan't seem to be able to properly import cells where the contents of the cell is the result of a formula. The events are:

  1. Set up an XLS spreadsheet where one column is the calculated result of others (e.g the sum of the other columns), the 'sum' column
  2. Import spreadsheet as a table into Qgis by using 'add layer' and selecting the XLS file and clicking open.
  3. The table loads up with all the correct values, including the calculated values in the 'sum' column
  4. saveSave the table
  5. returnReturn to the XLS spreadsheet and your 'sum' column no longer has any formulas, it's just the integer values.

Is there anything I can do in the importing or saving of edits that will preserve the column as a formula, not just the results?

calculated cells in xls

Opening Layers directly from XLS spreadsheets is a very useful (if not well documented) feature of Qgis, but I don't seem to be able to properly import cells where the contents of the cell is the result of a formula. The events are

  1. Set up an XLS spreadsheet where one column is the calculated result of others (e.g the sum of the other columns), the 'sum' column
  2. Import spreadsheet as a table into Qgis by using 'add layer' and selecting the XLS file and clicking open.
  3. The table loads up with all the correct values, including the calculated values in the 'sum' column
  4. save the table
  5. return to the XLS spreadsheet and your 'sum' column no longer has any formulas, it's just the integer values.

Is there anything I can do in the importing or saving of edits that will preserve the column as a formula, not just the results?

Calculated cells in xls

Opening layers directly from XLS spreadsheets is a very useful (if not well documented) feature of QGIS, but I can't seem to be able to properly import cells where the contents of the cell is the result of a formula. The events are:

  1. Set up an XLS spreadsheet where one column is the calculated result of others (e.g the sum of the other columns), the 'sum' column
  2. Import spreadsheet as a table into Qgis by using 'add layer' and selecting the XLS file and clicking open.
  3. The table loads up with all the correct values, including the calculated values in the 'sum' column
  4. Save the table
  5. Return to the XLS spreadsheet and your 'sum' column no longer has any formulas, it's just the integer values.

Is there anything I can do in the importing or saving of edits that will preserve the column as a formula, not just the results?

Source Link
user39790
user39790

calculated cells in xls

Opening Layers directly from XLS spreadsheets is a very useful (if not well documented) feature of Qgis, but I don't seem to be able to properly import cells where the contents of the cell is the result of a formula. The events are

  1. Set up an XLS spreadsheet where one column is the calculated result of others (e.g the sum of the other columns), the 'sum' column
  2. Import spreadsheet as a table into Qgis by using 'add layer' and selecting the XLS file and clicking open.
  3. The table loads up with all the correct values, including the calculated values in the 'sum' column
  4. save the table
  5. return to the XLS spreadsheet and your 'sum' column no longer has any formulas, it's just the integer values.

Is there anything I can do in the importing or saving of edits that will preserve the column as a formula, not just the results?