https://bugs.documentfoundation.org/show_bug.cgi?id=159071
--- Comment #2 from [email protected] --- Happy to add an attachment if necessary but it's not complicated to explain so I'll try that first. The string "=Sum(E1:E4)" is a formula. It won't do anything in a csv, of course, but it doesn't stop being a formula - a string with an '=' in it is a formula (usually). Just like the string "Nc3 Nf6" is a chess move, whether or not is in some software that can read chess moves. If one is saving an ODS to a CSV (most likely for transfer to some other software), then it's possible one might want to save the 'formula' not the result of the formula. Presumably this is why all these confounded options abound in the first place. I'm just pointing out that the means by which one might go about doing this are very counter-intuitive in that one would use the process - Click on 'Save As...' and select to overwrite, edit filter settings, 'Save cell formulae instead of values' - but after that's done and the the file is closed, LibreOffice ignores this instruction and saves the values anyway. -- You are receiving this mail because: You are the assignee for the bug.
