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

          Priority: medium
            Bug ID: 81757
          Assignee: [email protected]
           Summary: Calculations order do not follow cell dependencies
          Severity: major
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: All
            Status: UNCONFIRMED
           Version: 4.2.5.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 103462
  --> https://bugs.freedesktop.org/attachment.cgi?id=103462&action=edit
file with problem

The attached spreadsheet was created a while ago, from this what I can check
the last version of libreoffice that was working as expected was 4.0.
I have check this on Windows with 4.1.6 and linux 4.2.5 release versions.
It looks like cell recalculation are based on position not dependencies.
In attached file sheet1 is used to calculate bend allowance data for sheet
metal flat layout calculation, it contains working macro and formulas.
We have just noticed different results in cells I8, F28, in different program
versions. It looks like the value of cell I8 is calculated before I4.So the
value of I8 is based on previous value of I4. If I copy this formula to call I6
the value is updating correct in I6, but not in I8.

-- 
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