Opening and saving files: content and statistics |
To view the file statistics and/or to change some of the options concerning the saved content for the current workbook, use the File > Content & Statistics command.
Save values of formulas
Specifies whether the current values of formulas should be saved. Turning this option off
may result in significantly smaller files. If this option is turned off, you need to perform
an initial update/recalculation after opening a given file to re-create formula values.
This option is available only for the GS-Calc *.gsc file format.
Default: On
Save values of formulas
If the Save values of formulas check box is on, this option can be used to explicitly specify
cells or ranges containing formulas that are to be saved. Cells and ranges should be entered as a comma separated
list, for example:
a10, d:d, sheet1!f20, 5:5, dk1:dk10, "first sheet"!ab100, "second sheet"!ab100:ab200
If a given cell/range referrence doesn't contain the worksheet path, it's assumed that it refers to the currently
active worksheet.
This option is available only for the GS-Calc *.gsc file format.
Default: Off
Save thumbnail
Specifies whether the thumbnail image should be added to the saved workbook. Thumbnail images can be saved in the "*.gsc"
and *.ods files. They represent the portion of the worksheet visible when that worksheet was saved.
For encrypted files the thumbnail is replaced by a 128x128 pixels static image informing users that the content
is encrypted.
Both GS-Calc *.gsc and ODF *.ods files are zip files and saved thumbnail images are available in those
zips as the following zip stream: Thumbnails/thumbnail.png.
Note: The ODF specification requires thumbnails in the *.ods files to have a fixed size of 128x128 pixels.
Default: On
Cell range
If the Save thumbnail check box is on, this option specifies the cell range to be used
for the thumbnail image. It can contain a simple cell range, a cell range along with the full worksheet reference
or only the worksheet reference/path without any specific cell range.
If not specified, the thumbnail will represent the portion of the worksheet visible when that worksheet was saved.
Default: Off