Bug 50419 - Truncating operators while addition, wrong summ vs MSOffice 2007
Summary: Truncating operators while addition, wrong summ vs MSOffice 2007
Status: CLOSED DUPLICATE of bug 35411
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-28 02:19 UTC by Timon
Modified: 2013-12-05 15:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
xls file, where operators are truncated in LibreOffice (20.50 KB, application/vnd.ms-excel)
2012-05-28 02:19 UTC, Timon
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Timon 2012-05-28 02:19:05 UTC
Created attachment 62156 [details]
xls file, where operators are truncated in LibreOffice

LibreOffice 3.5.3.2 Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 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 LibreOffice 3.5.3, 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 LibreOffice mysteriously disappeared from formula and total amount changed. LibreOffice does not show any messages.

If we try to add missing operators in LibreOffice (not even all, only one) in formula, then we immediately get "error 512".

Exactly the same problem exists in the Apache Openoffice 3.4.0 Final.

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 Timon 2012-06-14 01:47:57 UTC
The same problem was confirmed in Apache OpenOffice 3.4.0
https://issues.apache.org/ooo/show_bug.cgi?id=119451
Comment 2 bfoman (inactive) 2012-06-22 04:14:42 UTC

*** This bug has been marked as a duplicate of bug 35411 ***