Is there some way to get OpenOffice Calc to copy the real value stored/calculated in a cell. I realize it must still be text, but is there some way to get OpenOffice to copy a higher precision value than what is shown on the screen?
I need to paste the values into another program for testing but need a higher precision. So far I've been making the spreadsheet simply have a high number of decimals displayed, but then it is quite hard to read this sheet.
For example, if the cell is showing "1.23" that is a rounded number, when I copy I want a more precise number copied (the result of the calculation), like "1.23748236483". Preferably long enough to cover the native precision of the floating point.