[Libreoffice-bugs] [Bug 117289] New: Severe bug in LibreOffice (Calc Speadsheet)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 117289
           Summary: Severe bug in LibreOffice (Calc Speadsheet)
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sarti_carlo at yahoo.com

Description:
I do not agree about bug 117049 was marked as duplicate of 114482 (referred
e:523).
It is impossible to speak about e:523 (convergence problems) if I have not this
message.
The default setting are related to make many iterations to reduce the error
smaller than a prefixxed value.
I want make "AN ONLY" iterations. For this, the considerations done by Mike
Kaganski are not valid.

I put below the steps to reproduce the problem (wrong data in calculation).
I would attach a my file, but I do not see, in this page, the key "Add an
attachment" enabled. I hope it is in the next one (after "Submit Bug Report").
If I will not be able to add it, you will not can to use it, but the following
considerations are valid.
My program calculate my economic balance.
I have ATTIVO/PASSIVO (CREDIT/DEBIT) at the beginning year: I put the data with
the last results of previous year.
I have ATTIVO/PASSIVO, at the current date. The ATTIVO/PASSIVO are equal the
initials vaiues +/- ENTRATE/USCITE (INCOMES/EXPENDITURES).
The ENTRATE/USCITE (from C23 and E23 and following rows) are obtained as the
couple as A1 and B1 (see below in "Steps to Reproduce").

If I use my program for commercial purposes (naturally suitable modified to
satisfy the complete rules of Economic balance), I would go in prison.
My program well works in Excel (that I have not, but that I tested with it) and
in Softmaker (PlanMaker).
>From this site, I downloaded a free version for Windows an another for Linux; I
received, by mail, two license numbers.
In Excel and in PlanMaker I have correct results; with LibreOffice (Calc
Speadsheet) I have wrong results.


Steps to Reproduce:
1. Open LibreOffice.
2. Open Calc Spredsheet (main page).
3. Click on Tools to open the drop down menu.
4. Select Options.
5. Open LibreOffice Calc
6. Open Calculate.
7. Check Iterative References
8. Set Steps (first parameter in Iterations) at 1 (minimum value).
9. Set Minimun Change (second parameter in Iterations) at 1000000 (a very high
value, this is MANDATORY not to have e:523).
10. Click on OK.
11. Return to Calc Spredsheet (10th step).
12. Put 0 in A1 and B1.
13. From B1, write in the Insertion cell (referred to B1) =A1+B1.
14. If you obtain the message #VALUE!, you can use my trick: repeat 3td ÷ 11th
step, adding some clicks on conditions for General Calculations (the message
#VALUE! can be considered a little bug), instead of doing change for 8th and
9th step.
15. With 0 in A1 and B1, put 100 in A1, then ENTER; then put 0 in A1 and
finally ENTER.


Actual Results:  
The result in B1 (wrong) is B1=A1+B1=100*2+0=200 (per first input) and
B1=0*2+200=200 (for the second input).


Expected Results:
The result in B1 must be B1=A1+B1=100+0=100 (per first input) and B1=0+100=100
(for the second input).
A value in A1 is added/subtracted (depending on positive/negative value) in B1
(value updated). You are ready for a new other input.



Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/47.0.2526.106 Safari/537.36

-- 
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/20180427/7918148a/attachment.html>