<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Err:522 on updating data from linked sheet" href="https://bugs.documentfoundation.org/show_bug.cgi?id=127024#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Err:522 on updating data from linked sheet" href="https://bugs.documentfoundation.org/show_bug.cgi?id=127024">bug 127024</a> from <a class="email" href="mailto:dwmw2@infradead.org" title="David Woodhouse <dwmw2@infradead.org>"> David Woodhouse</a> <pre>There is a second regression here, I'm not sure if it's just fallout of the first. On 'Sheet3' see the value at O9. This is an average monthly growth rate. Set it to 0.3425 and observe that the 'ChildA APR' value in T3 comes out basically equal to the actual value of the investment, in S3. Now, open the spreadsheet again, allow it to load the CSV content, hit F9 on Sheet1!G11 and ask the goal seeker to calculate that 0.3425 for you (Formula call Sheet3!T3, target value 194.82, variable cell Sheet3!O9). It fails, and asks to insert the "closest value (-156.94%)' into the variable anyway. (If it works, you probably ignored my instruction to open the spreadsheet again after manually setting the value ) This always used to work, and *still* seems to work for Child B. It's also triggered by macros (and yes, I know you can still work out my children's names because I was too lazy to anonymise those too.) Please let me know if I should file a separate bug for that one, or if it's related to the first.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>