https://bugs.documentfoundation.org/show_bug.cgi?id=117049
--- Comment #8 from [email protected] <[email protected]> ---
Mike Kaganski,
I want to add another comment.
You reproduced the described behavior, also you are not sure if it is a bug. I
am sure.
If I set the iterations number at 1 and I write B1=A1+B1, what does it mean?
It means I want to do 1 loop (Iterations number) to calcolate the function
B1=A1+B1.
Now, if I have A1=100 and B1=0 (initial setting), I have B1=A1+B1=100+0=100
(correct value), but I do another loop (2 iterations), I have
B1=A1+B1=100+100=200 (wrong result).
I know that circular references are used to reduce the error "UNDER" (not
closer) the Minimum Change and, for this, the Iterations number is set high,
but I use the circular references to do a continued addition.
Look at the piggy bank. If, today, you put inside 10$, tomorrow 5 and 15$ and
day after tomorrow 10$, how money have you in the piggy bank?
You can calcolate it with the technique previous described. The reset the data
at 0 is not necessary. It needs in my file. If you don't reset the value, when
you enter a value in another raw, you have an addition for two value.
Have I invented a new technique? Must I patent it? I don't think.
Best regards
Carlo Sarti
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
