https://bugs.documentfoundation.org/show_bug.cgi?id=153598
--- Comment #11 from Mark Pawelek <[email protected]> --- Previously I said that closing the sheet and reopening fixed the issue. I was wrong. Closing and reopening fixes the issue for some formulas but not for all. Nothing fixes it. Even closing the application and rerunning it does not fix the issue! This issue is seen with a big spreadsheet: thousands of rows of data, scores of columns and at least 5 or 6 sheets. With some formulas dependent on other forumula results. There are no macros nor used-defined functions in this worksheet, but is has lots of named ranges used in forumlae. I don't want to insult anyone but it seems to me, your code and UI tests are way too limited. How are you doing you UI tests? I don't expect devs to do manual tests, but I expect sophisticated tests to test the code & formulas. Re: Jollytall's previous test using RAND(). That is not a sensible test. One is supposed to know the expected result of a formula. So any data created by RAND() will be pointless. -- You are receiving this mail because: You are the assignee for the bug.
