I inserted a column between two existing columns in a Calc spreadsheet, then created a formula in a cell in the inserted column. The formula showed the correct value in the wizard, but showed the formula, not the result, in the cell. I tried repeating this with different formulas, also in a newly created spreadsheet. The formulas evaluated correctly if put in a pre-existing cell (i.e. not in an inserted column) but not anywhere in the inserted column. I cannot recall whether I came across this situation in any previous version. I have not yet downloaded 3.5.2 RC1 to see whether this occurs in that version also.
Can you check if the column is formatted as text instead of value?
Yes, I checked that. It wasn't formatted as text.
@ Peter de Lacey Thanks for bugreport not reproduced in 3.5.4 on Fedora 64 bit. May be fixed? If not fixed, please, attach ods document that demonstrates this problem
I am now using 3.5.4.2 and it does seem to be fixed; I can't reproduce the bug now. Thank you. Peter de Lacey On 22/06/12 16:52, bugzilla-daemon@freedesktop.org wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=48007 > > sasha.libreoffice@gmail.com changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > CC| |sasha.libreoffice@gmail.com > > --- Comment #3 from sasha.libreoffice@gmail.com 2012-06-22 01:52:31 PDT --- > @ Peter de Lacey > Thanks for bugreport > not reproduced in 3.5.4 on Fedora 64 bit. May be fixed? > If not fixed, please, attach ods document that demonstrates this problem >
Thanks for additional testing Due to last comment, changing status to WorksForMe If problem will appear again, please, change status to Reopened