Bug Hunting Session
Bug 33330 - Iteration causes error 522 after closing and reopening
Summary: Iteration causes error 522 after closing and reopening
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 RC4
Hardware: All Windows (All)
: medium enhancement
Assignee: Not Assigned
Whiteboard: feature
Depends on: 126866
Blocks: Calculate
  Show dependency treegraph
Reported: 2011-01-21 03:50 UTC by Joe Calderone
Modified: 2019-08-13 04:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

worksheet with iteration problem (24.46 KB, application/x-zip-compressed)
2011-01-25 05:53 UTC, Joe Calderone

Note You need to log in before you can comment on or make changes to this bug.
Description Joe Calderone 2011-01-21 03:50:41 UTC
I have used a running total of dividends in Lotus 123 and it works properly,
but it does not work in OpenOffice.
an Example
using 1 Row and 3 Columns
. 1st column is the Dividend payment entry column
. 2nd column has =B2A1 Keeps running total of ytd dividends
. 3rd column has =B3+A1 Keeps running total of all dividend since purchase date
Iteration is set to 1
at the end of year column 2 is cleared

Calculations are performed correctly, But when the spreadsheed is closed and then reopened column 2 and 3 show :ERROR 522
Comment 1 Noel Power 2011-01-21 03:55:29 UTC
@Joe Calderone Can you please supply a simple example document
@kohei for you I guess
Comment 2 Joe Calderone 2011-01-21 05:22:54 UTC
(In reply to comment #1)
> @Joe Calderone Can you please supply a simple example document
> @kohei for you I guess

 I am unable to send a document that i created in Libre. as I removed the app and the worksheets from my Win7 PC. The example i gave in my original post should show the problem and should be easy to enter into a blank worksheet.
Comment 3 Joe Calderone 2011-01-25 05:53:25 UTC
Created attachment 42456 [details]
worksheet with iteration problem

Here is an example of the iteration bug
This example works in Lotus 123 the formula is a bit different but the idea is the same
You should be able to enter an amount in column H2 thru H8
and a running total should result in I2 and J2 etc
when the worksheet is closed and then reopened Error 522 appears in H2 etc
I have also had to device the amount by 2 as you will see in the formula or twice the amount is added.
Would be nice if you could fix the problem
Iteration step is set to 1
Comment 4 Joe Calderone 2011-01-25 05:54:51 UTC
This morning i installed the LibreOffice 3.3 and the problem persists
Comment 5 Kohei Yoshida 2011-01-25 07:29:08 UTC
The iteration feature has been broken for many years since the OOo time.  So this is not something that gets fixed overnight.
Comment 6 Kohei Yoshida 2011-01-25 07:30:37 UTC
Since the iteration invokes an entirely different calculation engine, re-working this to make it robust is more a feature request than a bug fix.
Comment 7 Joe Calderone 2011-01-26 03:16:35 UTC
Well, If I may say, It's about time they get it fixed. The fact that it does not work makes it impossible to keep running totals.