Issue 81825 - exchange weeknumber formula in dutch versions of Excel and calc
Summary: exchange weeknumber formula in dutch versions of Excel and calc
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:
Depends on:
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: ---

test.xls created with Calc (62.50 KB, application/vnd.sun.xml.calc)
2007-09-24 12:16 UTC, roelofz
no flags Details

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

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

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:


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

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

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


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.