I’m using LibreOffice 22.214.171.124 on a Mac running OS/X Yosemite. I’m trying to follow the instructions at Importing and Exporting Text Files - LibreOffice Help because I have a PHP program creating a spreadsheet out of a server database. The PHP creates a CSV file and I want to import that into LibreOffice.
If the csv file says
"=sum(2,3,4)" "=hyperlink(""http://bbc.co.uk"", ""BBC"")"
then libreoffice imports those cells as free text, not as formulae, independent of the setting of the
libreoffice - preferences - calc - view - formulas checkbox. If I click in that free text and edit it by adding a space at the end and hitting return, it changes into a formula.
If I have a real formula in a spreadsheet giving a calculated value, the wiki page suggests that I can export the formula (as opposed to a computed value) to a csv file by setting the
libreoffice - preferences - calc - view - formulas checkbox. When I do that, I can see the formulas in the cells on the screen in LibreOffice. Then when I export it to a CSV file, the CSV file contains:
and not the formula.
Is it possible to import formulas from, and export formulas to, a CSV file?
Are the instructions at Importing and Exporting Text Files - LibreOffice Help incorrect?