https://bugs.documentfoundation.org/show_bug.cgi?id=166238
Bug ID: 166238
Summary: Opening .CSV file with Calc may fail to correctly
interpret formulas -- FILEOPEN
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I work with generated .csv files that contain embedded formulas in some of the
cells. This (normally) works great, you just tick the "Evaluate Formulas"
checkbox in the import wizard, and it will correctly import it with the formula
intact. However after recently upgrading to 25.2, this doesn't work anymore.
I have a hunch (but I could be wrong), some of the formulas are of the form
"=C3+D3-E3". It picks up the C3+D3 part, but not the -E3. I wonder if it's
confused, thinking the -E3 is scientific notation? (The "detect scientific
notation" box is NOT checked in the import wizard). I played around with the
wizard options a bit, but could not get the file to load properly.
I just downgraded back to 24.8, and now the same file loads fine again.
Steps to Reproduce:
1. Create a text file (.csv) with one or more formulas as I described in the
description. Include in the formula adding (or subtracting) some cell in the E
column, as I suspect that is a contributing factor.
2. Try to open the file with Calc, using Text Import wizard, with "Evaluate
Formulas" flag on
3.
Actual Results:
Formulas do not load
Expected Results:
Should load the file, including the formulas, and come up cleanly
Reproducible: Always
User Profile Reset: No
Additional Info:
That's all I've got.
--
You are receiving this mail because:
You are the assignee for the bug.
