Apache OpenOffice (AOO) Bugzilla – Issue 109495
Backward compatibility issue - file saved with 3.1 version not opened correctly into 3.2
Last modified: 2013-01-29 21:52:47 UTC
I found a (major) issue with my file. I create a spreadsheet to manage my bank account and categorize my expenses. I used the function EOMONTH as well as IF and SUMPRODUCT. Working perfectly in version 3.1, I update openoffice to 3.2. I found all cells with the error #values. Can you help me? I'd like to upload the file so you can check what is wrong. Thanks in advance
Created attachment 67966 [details] Spreadsheet not opening correctly with 3.2
Look into the sheet 'summary'. Opening with 3.1 gives the summary of the values reported in the 'CC' sheet. Opening with 3.2 gives #VALUES error
That is the intended new behavior for converting strings. See i5658 desc215 for details. You have to correct your spreadsheet to unambiguous formulas. You can avoid any problems with date strings and locals, if you use =EOMONTH(DATE(2008;10;1);C2-1) instead of =EOMONTH("01/10/2008";C2-1) assuming 1 is the day and 10 is the month. Only strings containing ISO formats are converted now, to avoid ambiguity. You can still use =EOMONTH("2008-10-01";C2-1) I don't know, whether it is possible to convert date strings to ISO format automatically, guessing the local from the cell number format language for example. I tend to set this issue to "WONTFIX", but a developer should comment.
Thank you regina! If I have only to change the eomonth function it might be ok. For sure an import function to convert files from 3.1 to 3.2 to solve this compatibility is more than welcome :)
Add me to cc.