Apache OpenOffice (AOO) Bugzilla – Issue 119451
Truncating operators while addition, wrong summ vs MSOffice 2007
Last modified: 2012-06-14 16:31:56 UTC
Created attachment 77635 [details] xls file, where operators are truncated in Apache OpenOffice Apache OpenOffice 3.4.0 (Final) AOO340m1 (Build 9590) - Rev. 1327774 Russian UI/Locale on Russian Windows XP Professional SP3 (32bit) We have MS Office 2007 SP3 excel file. Cell A1 contains formula (=(20-2+1)+(31-22+1)+(40-33+1)+1+2+(53-49+1)+2+4+2+1+2+3+3+2+1+1+3+2+1+2+2+2+2+3+1+4+(135-131+1)+2+1+1+(153-147+1)+1+1+2+3+(172-169+1)+1+1+1+1+3+1+(198-194+1)+2+1+1+3+2+2+2+1+(232-225+1)+3+2+2+3+3+1+1+(270-261+1)+(275-272+1)+(282-277+1)+3+2+(308-292+1)+4+1+1+(325-320+1)+4+1+2+1+1+1+(359-355+1)+2+2+2+(376-371+1)+3+2+1+(392-387+1)+1+2+1+1+1+2+2+4+2+1+2+(437-433+1)+1+1+(450-446+1)+1+5+1+5+1+1+2+1+3+(492-486+1)+4+1+(506-501+1)+(513-509+1)+1+1+1+(531-524+1)+1+1+2+1+3+2+1+1+1+2+(577-571+1)+3+4+5+2+1+1+1+1+1+1+3+3+2+1+4+1+1+1+2+2+2+1+3+2+1+1+1+2+1+3+3+3+2+3+2+2+2+6+1+4+3+2+8+3+2+15+1+6+1+3+4+3+4+4+4+2+7+8+1+5) and we have total amount = 536 If we try to open that file in Apache OpenOffice 3.4.0, then we see that cell A1 contains ANOTHER formula, which is truncated =(20-2+1)+(31-22+1)+(40-33+1)+1+2+(53-49+1)+2+4+2+1+2+3+3+2+1+1+3+2+1+2+2+2+2+3+1+4+(135-131+1)+2+1+1+(153-147+1)+1+1+2+3+(172-169+1)+1+1+1+1+3+1+(198-194+1)+2+1+1+3+2+2+2+1+(232-225+1)+3+2+2+3+3+1+1+(270-261+1)+(275-272+1)+(282-277+1)+3+2+(308-292+1)+4+1+1+(325-320+1)+4+1+2+1+1+1+(359-355+1)+2+2+2+(376-371+1)+3+2+1+(392-387+1)+1+2+1+1+1+2+2+4+2+1+2+(437-433+1)+1+1+(450-446+1)+1+5+1+5+1+1+2+1+3+(492-486+1)+4+1+(506-501+1)+(513-509+1)+1+1+1+(531-524+1)+1+1+2+1+3+2+1+1+1+2+(577-571+1)+3+4+5+2+1+1+1+1+1+1+3+3+2+1+4+1+1+1+2+2+2+1+3+2+1+1+1+2+1+3+3+3+2+3+2+2+2+6+1+4+3+2+8+3+2+15+1+6+1+3+4+3+4+4+4+2) and we have total amount = 515 Last operators (+7+8+1+5) which were in MS Office, in Apache OpenOffice mysteriously disappeared from formula and total amount changed. Apache OpenOffice does not show any messages. If we try to add missing operators in Apache OpenOffice (not even all, only one) in formula, then we immediately get "error 512". Exactly the same problem exists in the Libreoffice 3.5.3. If we perform the same actions in Microsoft Office 2007 SP3 then all is fine (we even can add a few more operators, and all will be fine).
can reproduce with AOO3.4 release version.
(In reply to comment #1) > can reproduce with AOO3.4 release version. The same problem is with Symphony 3.0.1 and LibreOffice 3.5.4
You may want to read comment of Eike in LibreOffice bug 35411 about maximal token size. I guess it is a related problem.
(In reply to comment #3) > You may want to read comment of Eike in LibreOffice bug 35411 about maximal > token size. I guess it is a related problem. URL you provided describes different problem with office crashes because of broken profile and during startup. May be by mistake you gave wrong link ? And there is no comments by Eiko.