[Libreoffice-bugs] [Bug 128517] New: Cyclic or iterative calculation is erroneously assumed in calc 6.3.2.2

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128517

            Bug ID: 128517
           Summary: Cyclic or iterative calculation is erroneously assumed
                    in calc 6.3.2.2
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: alain.touret at free.fr

Description:
The enclosed sheet used to work in calc version 6.2.8 but generates many calc
522 errors in version 6.3.2.2. 

Steps to Reproduce:
1.open the enclosed spreadsheet in calc 6.3.2.2
2.go to sheet "Synthese", column "Rattrapage TVA a psoteriori" (column L)
3.it shows an error 522, the error propagates throughout the spreadsheets
4.open the enclosed spreadsheet in calc 6.2.8
5.go to sheet "Synthese", column "Rattrapage TVA a psoteriori" (column L)
6.it shows the result of a processing (0), there may be some propagation
problems (data processing does not get always automatically actualized on other
sheets) but most often, the results are ok


Actual Results:
In libreoffice 6.0.7.3 this column (L) in "Synthese", as some parts of the
spreadsheet are not calculated : #N/A results

In libreoffice 6.2.8 the spreadsheet is usually well calculated, this column
results in numbers, not error. Please note that the refresh and propagation of
the data modification (between sheets) is not well done and sometimes needs
some manual modification on the destination sheet to be refreshed. 

In libreoffice 6.3.2.2 most parts of the spreadsheet are not calculated : error
522 results (even with iteration validated in parameters)


Expected Results:
The L column shall be always 0 due to the parameters adopted. 
This spreadsheet has worked on libreoffice 6.2.8 (with refreshing and
propagation problems). This column shall result in numbers, not error. The
propagation of calculations shall be done across all the right side sheets
(with names not only made of uppercase characters), including "Fiscalité". 


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191031/8cef846d/attachment.html>