Issue 81825 - exchange weeknumber formula in dutch versions of Excel and calc
Summary: exchange weeknumber formula in dutch versions of Excel and calc
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: configuration (show other issues)
Version: OOo 2.2.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-09-21 15:32 UTC by roelofz
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

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

Attachments
test.xls created with Calc (62.50 KB, application/vnd.sun.xml.calc)
2007-09-24 12:16 UTC, roelofz 		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 roelofz 2007-09-21 15:32:51 UTC 
Hi,

I hope I am not too fast in issuing this, but I couldn't find a logged
description of this, and was able to reproduce this on 3 pc's and have
reproduced this in OO 2.2.1 (1 PC) and Staroffice 8 update 8 (2 pc's), all Dutch
versions.

When opening an Excel sheet (created in Excel dutch, Office 2003-(sp2 and sp3))
in Calc containing the weeknummer formula the value gets inoperable (#MACRO?).
When using weeknum as a formula the value also gets inoperable (#NAAM?).

When correcting the values, the weeknummer formula is working again, but doesn't
get recognized by Excel when reopening the sheet in Excel.

Since I don't see the possibility to add attachments, I will include the code
for the two cells I created for testing:

=WEEKNUMMER(10-1-5;1)
=WEEKNUM(10-1-5;1)

I created two cells with the above values to evaluate the issue. When opening in
excel after saving in calc, the second cell gets garbled, both get a result
(#NAAM?).

I hope my issue has been described clearly enough for evaluation.

I hope you will be able to reproduce this, I also hope a fix is on the way as
this is tricky in exchanging spreadsheets.

Thank you for researching this!

Roelof van der Zee
Zwolle, The Netherlands
Comment 1 roelofz 2007-09-21 16:13:33 UTC 
One thing to add:

- when saving in .ods format no problems occur (also no possibility to exchange
with Excel either) but...
- also when saving in Excel format and reopening with Calc the cell with
weeknummer (correct formula) turns out as #MACRO?

It looks like the .xls conversion is the source of all this.

With Regards,

Roelof van der Zee
Zwolle, The Netherlands
Comment 2 frank 2007-09-24 11:02:21 UTC 
Hi,

please attach an Excel document showing your problem by using the create a new
attachment link next to the Attachments section of this Issue.

Thanks.

Frank
Comment 3 roelofz 2007-09-24 12:16:51 UTC 
Created attachment 48454 [details]
test.xls created with Calc
Comment 4 frank 2007-09-24 13:16:44 UTC 
Hi Daniel,

one for you I think. If needed I have an OOo2.3 NL on one of my machines.

Frank