Issue 81825

Summary: exchange weeknumber formula in dutch versions of Excel and calc
Product: Calc Reporter: roelofz <roelof>
Component: configurationAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.2.1   
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
test.xls created with Calc none

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