https://bugs.documentfoundation.org/show_bug.cgi?id=159071
Bug ID: 159071
Summary: Inconsistent approach to formulae in csv
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Saving formulae as written in csv files is already fraught with
inconsistencies, but this latest is most problematic.
1. Open a csv file with formulae (using the 'Evaluate Formulas' option) - the
formulae can be shown resolved in the open file (depending on your settings) -
the result is shown.
2. Click on 'Save As...' and select to overwrite, edit filter settings, 'Save
cell formulae instead of values'
3. Continue working with the sheet, the formulae continue to work (results are
shown), but make no new edits.
4. Close the sheet - **no new dialogue opens because apparently no changes have
been made since the last save**
5. Examine the csv - **the formulae have been saved as their results, not as
formulae**
This is inconsistent because the last save specifically requested that the
formulae be saved as formulae and no other edits have taken place since and no
new save dialogue opens up (confounding the impression that the file is saved
exactly as last requested).
Why is it not simply that the 'Save' button (which already saves a csv if it
was opened as csv) use whatever defaults the 'Save As...' option is set to?
Why default to filter settings the user has specifically asked not to be used
for this file?
--
You are receiving this mail because:
You are the assignee for the bug.
