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

Colin <that.man.co...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
     Ever confirmed|1                           |0

--- Comment #5 from Colin <that.man.co...@gmail.com> ---
Hi Gilward,
I believe this is the Eureka moment I had hoped for.
Whilst it is not identical, many of the aspects are the same.
I was indeed working on sheet 1, using drag to fill and the cells I referenced
were the result of formulae where the calculation would dictate the offset to
the current row.
I had allowed myself to think the trigger was possibly the fact that I was
pausing in the drag to fill in order to expose more screen rows.
In my instance I wasn't getting an incorrect reference and result I was getting
a null result - it was as though there was not even a formula in the cell. The
omly reason it was spotted was because the data was being graphed and it was an
improbability to have two zero results c1/3rd and c2/3rds along the axis in an
otherwise densely populated chart with a couple of hundred events on the axis.
I am unable to confirm that saving and re-loading the sheet could have remedied
the situation but I can identify that copying and pasting the formula from two
or three rows above had no beneficial impact. Clearing the cell and physically
retyping the formula was my successful remedy. In all honesty, my objective was
to make the thing work rather than a critical path analysis of the error.
Well spotted sir.

-- 
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