Bug 45664

Summary: Calc can't export the cells formulas to CSV (only the cells values)
Product: LibreOffice Reporter: fgallaire
Component: CalcAssignee: Eike Rathke <erack>
Status: RESOLVED FIXED    
Severity: enhancement CC: erack, fgallaire, jmadero.dev, robinson.libreoffice
Priority: medium Keywords: difficultyInteresting, easyHack, skillCpp, topicUI
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard: target:3.6.0
Crash report or crash signature: Regression By:

Description fgallaire 2012-02-05 18:39:19 UTC 
When you export a spreadsheet to CSV format, you can have the computed values of the cells, but not the formulas of the cells.
Add a checkbox to the export filter configuration panel could easily solve this problem.
Eike Rathke seemed to agree with that in a discussion with me at FOSDEM 2012.
Comment 1 Carl Chenet 2012-03-04 13:52:13 UTC 
Seems to me a really good idea. I'm not aware of something like that implemented anywhere.
Comment 2 Eike Rathke 2012-04-04 15:15:09 UTC 
Note that you can check Tools->Options->Calc->View Display Formulas, if that is enabled formulas are written to CSV instead of results.

If someone is interested in the EasyHack to implement the check box mentioned: dialog is in sc/source/ui/dbgui/scuiimoptdlg.cxx
If checked, a parameter needs to be passed down to ScDocShell::AsciiSave() to force the bShowFormulas in there. Implement transport of option parameter via ScImportOptions similar to bSaveAsShown.
Comment 3 Not Assigned 2012-04-25 05:22:59 UTC 
Florent Gallaire committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=c041db6f59888adc90ee8257eafe150d874c46c9

fdo#45664 EasyHack: Add a "Save cell formulas" checkbox to the CSV Export panel.
Comment 4 Not Assigned 2012-04-25 05:23:24 UTC 
Eike Rathke committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=3cceb8a900cd1fe1ae9bdb0c2e532e82a1835861

changes to fdo#45664 EasyHack
Comment 5 Robinson Tryon (qubit) 2015-12-16 00:38:00 UTC 
Migrating Whiteboard tags to Keywords: (EasyHack,DifficultyInteresting,SkillCpp,TopicUI )
[NinjaEdit]