Issue 13814 - Formula in Excel Sheet can't be edited
Summary: Formula in Excel Sheet can't be edited
Status: CLOSED DUPLICATE of issue 8640
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.3
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-04-25 14:04 UTC by andree
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
Simple spreadsheet to demonstrate problem (6.50 KB, application/octet-stream)
2003-04-25 14:05 UTC, andree 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description andree 2003-04-25 14:04:26 UTC 
When importing an Excel Spreadsheet, the formulas are evaluated correctly. When
double clicking on a cell with a formula, things look as expected, ie. there is
syntax highlighting for the formula and so forth. However, when I move the
cursor in the formula, the sybtax highlighting vanishes, the fomula is just
displayed as text. When I then click on the green tick mark the formula is
displayed as text in the cell and is not being evaluated anymore (note that I
haven't even changed anything).

I attach a simple spreadsheet to demonstrate this. To reproduce:
- open the spreadsheet with OO
- double click on the cell saying "OK"
- use the cursor key to move the cursor
- use the mouse and click on the green tick mark

=> The formula is not recognised as a formula anymore but interpreted as text.
Comment 1 andree 2003-04-25 14:05:16 UTC 
Created attachment 5883 [details]
Simple spreadsheet to demonstrate problem
Comment 2 frank 2003-04-25 14:43:34 UTC 
Hi Niklas,

1 4 u

Frank
Comment 3 niklas.nebel 2003-04-25 15:01:39 UTC 
If a cell has number format "Text", all input to that cell is stored
as text, and not interpreted. It's supposed to be that way, mainly
because other spreadsheet applications handle it like that, too. To
edit the formula, first change the cell's number format.
Comment 4 niklas.nebel 2003-04-25 15:02:03 UTC 
closing the issue.
Comment 5 andree 2003-04-26 00:24:00 UTC 
Can people please be a little more constructive.

(1) I haven't changed the cell format and in Excel it works alright.
(2) When you change the cell format to number it still doesn't work.
(3) If what you say is true, OO shouldn't evaluate the formula upon 
    opening the file which it does (and which makes sense).

So, please acknowledge this as a bug.

Best regards
Andree
Comment 6 daniel.rentz 2003-04-28 09:18:41 UTC 
Hi,

Seems that you have attached an xls file exported with OOo Calc. There
was a problem with exporting formulas that return a text. The export
filter didn't set "General", but "Text" as cell number format. This is
wrong and already fixed in OOo 1.1 beta.
What do you mean with "in Excel it works alright"? If I open your
Excel file, and hit F2 + Enter, Excel shows exactly the same behaviour
as Calc, means, it leaves the formula text, and not the result.

Regards
Daniel

*** This issue has been marked as a duplicate of 8640 ***
Comment 7 daniel.rentz 2003-04-28 09:19:22 UTC 
double->closed