# How do I export and import formulas to CSV? [closed]

I'm using LibreOffice 4.3.0.4 on a Mac running OS/X Yosemite. I'm trying to follow the instructions at https://help.libreoffice.org/Calc/Imp... 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:

```
9
"BBC"
```

and not the formula.

**Is it possible to import formulas from, and export formulas to, a CSV file?**

** Are the instructions at https://help.libreoffice.org/Calc/Imp... incorrect? **

Thanks!