Bug 149810 - FILEOPEN CSV containing formula not recognized
Summary: FILEOPEN CSV containing formula not recognized
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-07-01 18:27 UTC by Jay Schwartz
Modified: 2022-07-04 11:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Test CSV (19 bytes, application/vnd.ms-excel)
2022-07-04 10:39 UTC, Timur 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jay Schwartz 2022-07-01 18:27:47 UTC 
Formulas in cells are treated as text. 
The leading = is not signalling formula. 
Seeing this in version 7.3.4.2.
Worked in 7.2 and earlier.
Comment 1 m_a_riosv 2022-07-04 07:31:35 UTC 
Have you followed the instructions?, https://help.libreoffice.org/latest/en-US/text/scalc/guide/csv_formula.html?DbPAR=CALC#bm_id3153726

If so, please attach a sample file.
Comment 2 Timur 2022-07-04 10:39:07 UTC 
Created attachment 181105 [details]
Test CSV

I confirm the change from 7.3 with the simple test CSV. Seems regression.
Comment 3 Timur 2022-07-04 11:56:30 UTC 
Meh, this seems like NotABug because of new option "Evaluate Formulas".
Please confirm that using it solves your issue.