https://bugs.documentfoundation.org/show_bug.cgi?id=92474
--- Comment #4 from Yann Dumont <[email protected]> --- (In reply to Cor Nouws from comment #3) > Hi Yann, > > Thanks for describing the issue. > Can you please test what happens if you save the csv file as .ods first? > I think see some pattern in your comment 2.. Hi, Thanks for asking. First, I am not sure I will use the correct translation for the function I will talk about in this comment (everything between double quotes), sorry for the inconvenience if I don't. Behaviour isn't changed at all. If I load the csv then save it in ods format, then copy paste the formula's cell, the bug happens. And if I close the now-ods file and re-opened it, and then copy the formula's cell, it happened too. Moreover, I do some further testing. - The by-pass (I still don't remember the correct word) consist simply in modifying the formula. Simply adding/removing/changing one character anywhere in the string and then correcting the formula WITHOUT using "cancel last action" works too. But the "cancel last action" function restores the error. - The same bug happened when I do a "copy" of the whole sheet on an other document (ods) : all the IF functions are messed up. - if I save, close and then reload the ods, everything works fine ! - using "recalculate" doesn't work - disabling "automatic recalculate", and then copy-pasting the formula's cell works fine ! Seems like the bug comes from loaded information in LibreOffice, not from incorrect formula. "Automatic recalculate" function may be faulty here. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
