https://bugs.documentfoundation.org/show_bug.cgi?id=145291
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ilmari.lauhakangas@libreoff | |ice.org --- Comment #3 from Buovjaga <[email protected]> --- (In reply to Colin from comment #0) > Description: > There appear to be two impacts from this situation. > > The first scenario was only apparent when the sheet was initially created > and the original formula in F5 was; > > =E5/SUM('C') > > which was replicated for the entire data column and produced validated > results. > > I considered it unusual that the result in F2 was precisely ONE. > > I changed A1 and whilst all the other columns reflected that change, Column > F and the result in F2 remained unchanged. > > I then filtered three days from Column C and whilst the rows were hidden the > result in F2 was still ONE. > > I then changed the formula in F5 to include the ad hoc label ‘B’ instead of > ‘C’ and replicated that for the entire column > > F2 and the entire Column F changed to reflect the amended formula and > amendments to A1 affected all appropriate cells. > > Subsequently, I attempted to change the formula in F5 back to the original > ad hoc label ‘C’ only to discover that the system now considers label ‘C’ to > be ZERO and produces the requisite #DIV/0! Error. > > Also, a new cell E1 with the simple formula =SUM(‘C’) returns ZERO – What > happened to the ad hoc label? > > Steps to Reproduce: > To demonstrate that it originally provided a result it will be necessary to > create a new version of what I have attached and ensure that the formula in > F5 is initially created to refer to label C > =E5/SUM(‘C’) and then replicate the formula - LO has been observed to > automatically insert the apostrophes If I fill the formula, I get these: =E6/SUM(#NAME?$E5) -- You are receiving this mail because: You are the assignee for the bug.
