incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 119451] New: Truncating operators while addition, wrong summ vs MSOffice 2007
Date Mon, 28 May 2012 09:14:03 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119451

          Priority: P3
            Bug ID: 119451
          Assignee: ooo-issues@incubator.apache.org
           Summary: Truncating operators while addition, wrong summ vs
                    MSOffice 2007
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: Windows XP
          Reporter: kaktebyavirubit@gmail.com
          Hardware: PC
            Status: UNCONFIRMED
           Version: AOO340
         Component: open-import
           Product: spreadsheet

Created attachment 77635
  --> https://issues.apache.org/ooo/attachment.cgi?id=77635&action=edit
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).

-- 
You are receiving this mail because:
You are the assignee for the bug.

Mime
View raw message