Product: Spreadsheet
Type: changed
Title: Storage of data pulled in by external references changed
Posted by: [email protected]
Affected: sc
TaskId: i92797
<http://www.openoffice.org/issues/show_bug.cgi?id=92797>
Effective from: DEV300_m38
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [ ]
Performance test [ ]
Translation [ ]
UI relevant [ ]
*Description*
-------------
The implementation of how data pulled in by references to external
documents in formulas is stored internally was changed. Previously, all
data of a referred external sheet was stored in a hidden sheet. Now only
the data referred is stored in a separate structure, hidden sheets are
not created anymore. This has the advantages that
- By not creating hidden sheets the amount of available 255 sheets is
not decremented.
- It should be possible to refer more than 254 external sheets, given
enough memory for the amount of data of course.
- Less data needs to be stored when saving the document to file.
- No unintended data leakage may occur because data not referred is not
saved to files.
Note that the external sheets will not show up anymore in the Navigator.
For ODF file storage the data is still saved as external sheets,
previous versions will be able to read the document. Re-saving an
already existing document with the new version may result in
a significantly decreased size of the file's storage, depending on the
previous amount of data in the entire sheet and the amount of data
actually used in formulas.
Send feedback to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
