When I close a spreadsheet generated by Spreadsheet::WriteExcel
containing formulas (using Worksheet->write_formula), Excel always asks
if I want to save the changes made even if no changes have been made
while using Excel.
Is this normal behaviour?
(Using v2.03 and ActivePerl 5.8.4 on XP )
A Ymous wrote:
> When I close a spreadsheet generated by Spreadsheet::WriteExcel
> containing formulas (using Worksheet->write_formula), Excel always asks
> if I want to save the changes made even if no changes have been made
> while using Excel.
>
> Is this normal behaviour?
I have noticed that Spreadsheet::WriteExcel saves its spreadsheets in a
version of the Excel file format that is rather old by today's
standards, even though the file format is entirely compatible (the only
difference between the file format between some releases of MS Excel has
been a token that indicates the version of the file format).
So I'm guessing that MS Excel is automatically promoting the file to the
version matching the Microsoft software (Office 2003 or whatever you're
using) and tries to save that token when you close the file.
Bill