Issue 85970 - Calc can not preform math on a cell that contains a formula and a number value.
Summary: Calc can not preform math on a cell that contains a formula and a number value.
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2008-02-08 20:33 UTC by sgibbs
Modified: 2008-02-08 21:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Spreadsheet for Issue 85970 (33.00 KB, text/plain)
2008-02-08 20:35 UTC, sgibbs
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sgibbs 2008-02-08 20:33:01 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.
Comment 1 sgibbs 2008-02-08 20:35:48 UTC
Created attachment 51439 [details]
Spreadsheet for Issue 85970
Comment 2 Regina Henschel 2008-02-08 21:28:10 UTC
You try to calculate with text. That doesn't work. See also issue 5658.

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 Regina Henschel 2008-02-08 21:29:07 UTC
closing duplicate