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.
Please attach test file and printscreen of Text import dialog's settings.
Created attachment 200398 [details] test input file
Created attachment 200399 [details] 25.2.About
Created attachment 200400 [details] 25.2.Import.FAILS
Created attachment 200401 [details] 25.2.Result.FAILS.png
Created attachment 200402 [details] 24.8.About
Created attachment 200403 [details] 24.8.Import.success
Created attachment 200404 [details] 24.8.Result.success
This was tested on a Mac (as you can see from the screenshots). The failure was exactly the same on Windows. I already downgraded my Windows box back to 24.8, and do not want to go back to 25.2 because of this bug.
Hello, please try to set Character set = Unicode (UTF-8) at Text import dialog.
OK, well that fixes it.... But I never would have guessed to change the encoding in the text input dialog. Why does Calc 25.2 default to "UTF-7"? I don't even know what that is. I did NOT change the encoding selection -- after I installed 25.2, the first time I loaded a .CSV file it came up with that by default. (I didn't notice it until you pointed it out.) That just seems wrong. Most users are not going to know what encoding to choose, much less know the difference between UTF-7 and UTF-8. .CSV files are simple text files, and all the characters are standard ASCII characters. I have never seen a .CSV file that is not pure ASCII. Calc should be smart enough to know that, and it should have the correct encoding to read standard ASCII as the default on the import dialog. I've never had a problem like this with any prior version of LibreOffice. Never had that happen with Excel either.