https://bugs.documentfoundation.org/show_bug.cgi?id=102851

--- Comment #4 from Rob Swan <robertdavids...@hotmail.com> ---
Created attachment 128000
  --> https://bugs.documentfoundation.org/attachment.cgi?id=128000&action=edit
ODS Spreadsheet file exhibiting the problem.

Attached is the original file in which I experienced the problem.
I have 'played' with it to try and narrow down the source of the problem, which
does not appear in all cases. The problem should appear if you load the file in
Calc and do exactly the following:
In Cell Q306 enter 1800.00 (Replacing formula with fixed value)
Then... From Q383 to bottom of Column Q and all of Column R should display
'Err:522'
Then... In Cell Q306 enter another fixed value (ie. 1500.00) and the problem
disappears. Also saving and reloading file (with fixed value in Q306) will
cause the problem to disappear.
The problem does not occur when a fixed value is entered in any cell in Column
Q - only some. Because of existing data (ie. fixed values in some cells
Q1:Q293) the problem will not appear for values entered in cells above Q294.
Hope this helps.
Happy for file to be circulated freely.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to