[Libreoffice-bugs] [Bug 135514] identical formulae give different values
https://bugs.documentfoundation.org/show_bug.cgi?id=135514 tor...@yahoo.com changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- 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
[Libreoffice-bugs] [Bug 135514] identical formulae give different values
https://bugs.documentfoundation.org/show_bug.cgi?id=135514 --- Comment #6 from tor...@yahoo.com --- Created attachment 164291 --> https://bugs.documentfoundation.org/attachment.cgi?id=164291=edit file with addition Bad.ods: c=a+b=B3=7, OK Select B1, hit ^x; B1 is blank, B3=3, OK. Select cells B2:C2, drag them up; B1 is now 3, but B3=6—wrong, since B2 is blank. Select B2, hit ^v; B2 is now 4 (B1 and B2 have been exchanged), but B3 remains 6—false. -- 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
[Libreoffice-bugs] [Bug 135514] identical formulae give different values
https://bugs.documentfoundation.org/show_bug.cgi?id=135514 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 CC||xiscofa...@libreoffice.org Status|UNCONFIRMED |NEEDINFO --- Comment #5 from Xisco Faulí --- Hello, Please mention the steps to generate such a file from scratch -- 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
[Libreoffice-bugs] [Bug 135514] identical formulae give different values
https://bugs.documentfoundation.org/show_bug.cgi?id=135514 --- Comment #4 from m.a.riosv --- I don't know if it was LO saving this file in an inconsistent state. If you have the steps to arrive at save in an incorrect state please detail them. Hard recalc is there from the beginning for something. And also there are options about recalculate opening the file in Menu/Tools/Options/LibreOffice calc/Formula, I guess also for something. -- 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
[Libreoffice-bugs] [Bug 135514] identical formulae give different values
https://bugs.documentfoundation.org/show_bug.cgi?id=135514 --- Comment #3 from tor...@yahoo.com --- (In reply to m.a.riosv from comment #1) > Seems the file was saved in a inconsistent state. What is that? If LO saves in such a state, is this not a bug? > Doing a hard-recalc Menu/Data/Calculate/Recalculate hard, solves the issue. That's a work-around, it does not ‘solve the issue’—which result can be trusted and when is a result wrong? Actually, selecting B25 and hitting f9 recalculates —not ‘hard’. But why should I suspect this formula (or any other) needs recalculation? -- 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
[Libreoffice-bugs] [Bug 135514] identical formulae give different values
https://bugs.documentfoundation.org/show_bug.cgi?id=135514 tor...@yahoo.com changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #2 from tor...@yahoo.com --- Editing the formula B21 without changing it (eg, deleting ‘3’ and restoring it) forces the update of B25 to the correct value. -- 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
[Libreoffice-bugs] [Bug 135514] identical formulae give different values
https://bugs.documentfoundation.org/show_bug.cgi?id=135514 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #1 from m.a.riosv --- Seems the file was saved in a inconsistent state. Doing a hard-recalc Menu/Data/Calculate/Recalculate hard, solves the issue. What could matter is if there are steps to generate the inconsistent state. -- 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