I have used a running total of dividends in Lotus 123 and it works properly,
but it does not work in OpenOffice.
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
@Joe Calderone Can you please supply a simple example document
@kohei for you I guess
(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.
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
This morning i installed the LibreOffice 3.3 and the problem persists
The iteration feature has been broken for many years since the OOo time. So this is not something that gets fixed overnight.
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.
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.
sorry for undigging an old bug, would be nice if we can close some of them ...
as of today and with ver 22.214.171.124 unthreaded i'd say 'worksforme',
sample from comment #3: entering values in H2:H8 works as long! as you stay within the limit set by 'minimum change' in the iteration settings. if you exceed this - in the sample key in higher values than 1 - the formula in column I switches to err:523, but does the calculation!, the value in Ix is incremented, you can see that by subsequent entering a smaller value.
Also column J works correctly, the division by 2 is not neccessary, and J switches to err:523 when the minimum change limit is exceeded for this cell, thus in original sample when keying in values above 2 in col. H.
Version: 126.96.36.199 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US