Apache OpenOffice (AOO) Bugzilla – Issue 106538
Err:520 in Calc reopening saved .xls 2003 format files
Last modified: 2013-06-14 09:30:10 UTC
My .xls spreadsheet opens fine in Calc and I can edit and save OK. However, it shows an error 520 when reopened. Data validation based on a list in a tab in the same spreadsheet then fails to work. If I save in .ods format the error doesn't occur. Can send sample files for reference if required.
Created attachment 65840 [details] Sample spreadsheets (...nn 2009.xls works; ...test 2009.ods works; ... test 2009.xls errors in cells D8 aand D12)
No error when modifying the file attached: Interm IT TimeSheet BE Week nn 2009.xls, saving and reopening. However, save is very slow and takes more than a minute. Rev. 1489073 Win 7