Apache OpenOffice (AOO) Bugzilla – Issue 85970
Calc can not preform math on a cell that contains a formula and a number value.
Last modified: 2008-02-08 21:29:07 UTC
I have a spreadsheet that has cells that contain formulas that pull numbers from other cells in the workbook and will then display a value in that cell. When I try to preform any kind of math function on that value, it doesn't calculate anything. When I remove the formulas from the cells and type in the numbers manually the math functions will work. If you want I can email the spreadsheet to you. Just let me know where to send it to.
Created attachment 51439 [details] Spreadsheet for Issue 85970
You try to calculate with text. That doesn't work. See also issue 5658. *** This issue has been marked as a duplicate of 5658 ***
closing duplicate