Posted 8 September 2017, 1:35 pm EST
When performing final testing on our implementation of the Farpoint Spreadsheet in our project, we noticed a size difference between the xml files from Spread Designer and the FpSpread component's output. We were surprised to see that the output from FpSpread was larger even when no changes were made to the sheet. Running comparsions between the xml files with WinDiff showed that the FpSpread xml file would have four items added to the NamedStyles section. In the output from Spread Designer, there was not any data in that section.
Named Styles Added:
- Blank sheet of 27 cols, 80 rows is 37 kb in Spread Designer but grows to 46 kb after being saved from FpSpread through an xml document.
- A tax form of 27 cols, 80 rows is 577 kb but then grows to 588 kb.
The size in kb is very small, but as a percentage on the file size it can be significant on smaller files. Out client was concerned about the file size difference.
Is this size difference by design? It looks like the default named styles are being saved from FpSpread but not from Spread Designer. Should we expect the size to generally be different between the two?