Issue 6762 - offset cell formula does not work
Summary: offset cell formula does not work
Status: CLOSED DUPLICATE of issue 577
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: All Other OS
: P2 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-08-05 16:09 UTC by ostkamp
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

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

Attachments
ZIPfile including excel file for import and resulting broken OOo file (7.06 KB, application/octet-stream)
2002-08-05 16:12 UTC, ostkamp 		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 ostkamp 2002-08-05 16:09:40 UTC 
The cell formula "=VERSCHIEBUNG(A1;;2)" does not work in OpenOffice 1.0.1.
I am using the German version, so just for your understanding: This code 
translates to table:formula="=OFFSET([.A1];;2)" in the content.xml file.

The above code is automatically generated when opening a valid MS Excel 
document with the formula "=BEREICH.VERSCHIEBEN(A1,,2)".

I have found out that the formula to "=VERSCHIEBUNG(A1;0;2)" would work, but 
don't know whether the excel importer is broken or the original formula without 
the "0" is expected to work.
Comment 1 ostkamp 2002-08-05 16:12:19 UTC 
Created attachment 2441 [details]
ZIPfile including excel file for import and resulting broken OOo file
Comment 2 daniel.rentz 2002-08-06 12:13:17 UTC 
The bug/missing feature is, that Calc does not support empty function
arguments. The Excel import filter does not know the default values
for each argument (it's not always 0), so it imports an invalid formula.

As you have written, inserting a value solves the problem.

*** This issue has been marked as a duplicate of 577 ***
Comment 3 daniel.rentz 2002-08-06 12:13:37 UTC 
Double