Issue 119451 - Truncating operators while addition, wrong summ vs MSOffice 2007
Summary: Truncating operators while addition, wrong summ vs MSOffice 2007
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: PC Windows XP
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: https://bugs.freedesktop.org/show_bug...
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-28 09:14 UTC by Timon
Modified: 2012-06-14 16:31 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
xls file, where operators are truncated in Apache OpenOffice (20.50 KB, application/octet-stream)
2012-05-28 09:14 UTC, Timon
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Timon 2012-05-28 09:14:03 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).
Comment 1 Li Feng Wang 2012-06-14 05:18:17 UTC
can reproduce with AOO3.4 release version.
Comment 2 Timon 2012-06-14 08:45:23 UTC
(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
Comment 3 Regina Henschel 2012-06-14 16:05:54 UTC
You may want to read comment of Eike in LibreOffice bug 35411 about maximal token size. I guess it is a related problem.
Comment 4 Timon 2012-06-14 16:31:56 UTC
(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.