Issue 24672 - Formulas changing when saving Excel 97 files
Summary: Formulas changing when saving Excel 97 files
Status: CLOSED DUPLICATE of issue 24129
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-01-22 08:26 UTC by black665
Modified: 2004-08-24 14:20 UTC (History)
1 user (show)

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

Attachments
Sample file that is showing the described problem (261.50 KB, application/vnd.ms-excel)
2004-01-23 07:16 UTC, black665 		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 black665 2004-01-22 08:26:09 UTC 
Ok, here's what I do: If you open a File created with Excel 97 that contains a 
formula like

=WENN(ODER(O12<>"";A12="Sa";A12="So");"";$O$3)    (german version)

, this formula is then displayed as 

=IF(OR(O12<>"";A12="Sa";A12="So");"";$O$3)

in Open Office. But the problem now is that if you save the file as a Excel 
97|2000|XP-File and reopen it again, the formula changed to something like

=IF((F6-SUM(A6:IS6)=0);"ok";(F6-SUM(A6:IS6)))

by itself, resulting in an #NAME? 
Opening such a 'damaged' File in Excel 97 displays a #NAME? aswell. The problem 
only seems to occour in tabs of a file you actually edited with Open Office 
(like with my example, it's a timetable with january, february... So if I edit a 
line in january, the whole january tab gets messed up, february is still okay 
though).
Comment 1 kla 2004-01-22 08:38:44 UTC 
Wrong component and owner.
I change it.
Comment 2 black665 2004-01-22 08:41:02 UTC 
Thanks, and sorry. ^^° Kind of confusing webinterface...
Comment 3 frank 2004-01-22 09:23:38 UTC 
Hi,

this sounds strange. To investigate it please attach a file showing this problem
and a step by step description of what you're doing to get this result.

Frank
Comment 4 black665 2004-01-23 07:16:05 UTC 
Created attachment 12670 [details]
Sample file that is showing the described problem
Comment 5 black665 2004-01-23 07:21:49 UTC 
Please check the attached file. Now again, all I did was:

1. Open the file with Open Office
2. Filled in all usual working times (8:00 - 16:30) in january already, that's 
why that tab is looking okay
3. Then I only filled in the -first- row in the february tab and saved the file 
as "Excel 97/2000/XP" compatible
4. Closed the file and opened it again... The rows in february changed to #NAME? 
and the formulas in each cell seem to have changed aswell.
Comment 6 frank 2004-01-23 11:01:54 UTC 
Hi,

this is a duplicate to Issue 24129.

And I have a workaround for you. The problem are shared formulas there our XLS
Filter got some problems. To avoid trouble with your document you can do the
following each time you've worked on the file with a native Excel :

Make your changes and save the document to OOo Calc's own file format (sxc).
Select reload from the File Menu (now there are no shared formulas anymore).
Save the file to XLS (If you do not touch the file with an Excel and save it
where, you can open and edit the file without problems in OOo Calc. After
opening this file and editing it with Excel, you have to go through the
workaround the next time you edit the file with OOo.

Thanks for your help.

Frank

*** This issue has been marked as a duplicate of 24129 ***
Comment 7 frank 2004-01-23 11:02:20 UTC 
closed double
Comment 8 frank 2004-08-24 14:20:11 UTC 
found fixed in cws dr20