First time here? Check out the FAQ!
asked 2012-09-08 04:10:07 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Greetings: I am trying to adjust prices according to a formula (D2*.28+D2). While this works quite well within the confine of the original sheet, I need to export this to a .csv and upload to a server. Without its reference, it throws an error.
The question is: Is there any way to change a dynamic formula to a static one? I apologize in advance if my terminology is not correct, but I would rather ask then to key in 750+ entries by hand.
(I would add a sample, but I don't have the "karma" yet)
In your workbook in any arbitrary cell write number 1.28.
Copy this cell (Ctrl+C or Ctrl+Insert).
Select the data that you want to change (in your example it's the cells in column D)
Choose Edit-Paste Special (or press Ctrl+Shift+V). Check Operatiopns-Multiplay. OK.
Remove (clear) cell in which you wrote 1.28
Export the list in csv-file.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-08 04:10:07 +0200
Seen: 112 times
Last updated: Sep 08 '12