https://bugs.freedesktop.org/show_bug.cgi?id=76611

          Priority: medium
            Bug ID: 76611
          Assignee: [email protected]
           Summary: FILEOPEN: Error formula on .XLS file
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA PossibleRegression
            Status: UNCONFIRMED
           Version: 4.2.0.4 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 96393
  --> https://bugs.freedesktop.org/attachment.cgi?id=96393&action=edit
xls file that have formula error

Problem description: 
After upgrade to LO 4.2, formula error occur in xls file if formula contain
reference cell on another sheet. In old version LO and MS Excel the formula is
ok. 

in file attached the problem in sheet "SR" column G and L
Column G reference to $TPM.FA.
In sheet TPM : column FA refer to column EM column EM refer to 

Problem :
In sheet TPM : column FA → EM → JD 

Expected behavior:
In sheet TPM : column FA → EM → H 

Operating System: Windows XP
Version: 4.2.0.4 release
Last worked in: 4.1.3.2 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to