[Libreoffice-bugs] [Bug 128517] user error? / data error? | was: 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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|DUPLICATE                   |NOTABUG
            Summary|Cyclic or iterative         |user error? / data error? |
                   |calculation is erroneously  |was: Cyclic or iterative
                   |assumed in calc 6.3.2.2     |calculation is erroneously
                   |                            |assumed in calc 6.3.2.2

--- Comment #6 from b. <newbie-02 at gmx.de> ---
source of error?: 

might be that someone changed a date in the project. having year of PRODUITS.D6
earlier than year of ENTERPRISE.B12 is questionable from the point of view of
IT (referencing in a daterange not available) and probably also of business
administration, setting theese dates to other order or identical year 'heals'
the sheet, 

<<< bug killed? >>>

never ever a dup of 124270, removing that, 

spotted one more problem: 

in ver. 5.0.0.1 on one occasion cells J5:J27 were - erroneously - calculated to
'0', 

that error was 'stable' when it occurred, replacing the term '*(1-$H5)' with
'*(1)' gave correct result in J5, re-typing it with '*(1-$H5)' had error again,
function wizard calculated correct (5425) while cell value was wrong (0), but
on retries after restart 5.0.0.1 calculated results for those cells, 

might have been dependent on whatever special condition, cannot reproduce, have
seen before that sometimes function wizard analysis tool works different to
cell value calculation ... 

for the moment i'd say #N/A in Synthese.L is correct while year of PRODUITS.D6
being smaller than year of ENTERPRISE.B12

feel free to change or reopen if i'm wrong

-- 
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/20200404/2450da79/attachment-0001.htm>