Summary: | Iteration causes error 522 after closing and reopening | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Joe Calderone <joe935> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | enhancement | ||
Priority: | medium | CC: | chdh |
Version: | 3.3.0 RC4 | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | feature | ||
i915 platform: | i915 features: | ||
Attachments: | worksheet with iteration problem |
Description
Joe Calderone
2011-01-21 03:50:41 UTC
@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. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.