https://bugs.documentfoundation.org/show_bug.cgi?id=92468
--- Comment #2 from Óvári <[email protected]> --- Eike Rathke work in enabling correct references in LibreOffice is to be congratulated. As Jerzy Tyszkiewicz has raised a concern about LibreOffice Calc formulae capabilities, it might be advisable to continue to use Excel until the resolution of this circular reference. LibreOffice Calc formula does not correctly flag a circular reference and provides in the spreadsheet while Excel does flag the circular reference correctly. Thinking further a solution to ensure that any formulae entered or pasted, LibreOffice Calc should check and change if necessary each range in the LowerBound:UpperBound to be in ascending order for both column and row. For example: B10:B1 should be changed and stored as B1:B10 C:A --> A:C A3:B2 --> A2:B3 B2:A3 --> A2:B3 $E3:C$8 --> C3:$E$8 The Name Box in LibreOffice Calc automatically list the range correct if you select cells from E8 to C3, or E3 to C8, or C3 to E8 or C8 to E3. Perhaps the code in the Name Box could be reused to change the formulae in ascending order. Thank you -- 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
