bjh333
Level 1 (25 points)
iWork

Q: Export to csv with fomulas

I want to export file to CSV that saves cell fomulas instead of calculated values.

Is it possible?

I know OpenOffice can do that.

OS X El Capitan (10.11.5), null

Posted on Sep 3, 2016 3:36 AM

Close
bjh333

Q: Export to csv with fomulas

  • All replies
  • Helpful answers

  • by SGIII,

    SGIII SGIII Sep 3, 2016 6:14 PM in response to bjh333
    Level 6 (10,622 points)
    Mac OS X
    Sep 3, 2016 6:14 PM in response to bjh333

    You could do that after running a script that changes formulas to text in cells.  However, if OpenOffice already does that why not File > Export to > Excel ... and open that file in OpenOffice and export in whatever way already does what you want?  I can't think of a use case with Numbers.

     

    SG

  • by bjh333,

    bjh333 bjh333 Sep 3, 2016 7:43 PM in response to SGIII
    Level 1 (25 points)
    iWork
    Sep 3, 2016 7:43 PM in response to SGIII

    Yes. I know. I am just curious about "hidden power" of Numbers and compatibility is always my concern.

    BTW Numbers 3 cannot convert text string to values in csv file while numbers 2 can do that.

  • by SGIII,

    SGIII SGIII Sep 4, 2016 4:51 AM in response to bjh333
    Level 6 (10,622 points)
    Mac OS X
    Sep 4, 2016 4:51 AM in response to bjh333

    Not sure what you mean. A csv file is just a bunch of text arranged in a certain way. The importing app tries to figure out which columns contain number values and which contain non-numerical values. Your question seemed to be about exporting from Numbers, not importing into Numbers. If you are importing csv into numbers then I think you'll find it does a pretty good job In most cases. Perhaps you could give more specifics on what you are looking for.

     

    SG