Issue 77927 - WEEKNUM function is not converted from Excel correctly
Summary: WEEKNUM function is not converted from Excel correctly
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://starsky51.googlepages.com/Book...
Keywords: ms_interoperability
: 93622 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-05-30 11:26 UTC by starsky51
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

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

Attachments
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 starsky51 2007-05-30 11:26:18 UTC 
When a excel workbook is opened which contains a cell using the WEEKNUM
function, the formula is converted to WEEKNUM_ADD, as it should be. However,
only one parameter is included in the converted formula (eg. WEEKNUM_ADD(A1)).
This gives an err:504 because WEEKNUM_ADD takes two parameters (eg.
WEEKNUM_ADD(A1;1)). Example attached.
I've only been able to test this in Windows.
Comment 1 gercokees 2007-06-04 10:02:14 UTC 
Confirming this one:
In excel enter:
=WEEKNUM(NOW())
save and close and open in OOo
Comment 2 frank 2007-07-09 14:15:38 UTC 
Hi Daniel,

Excel sets 1 as second parameter if not set by the user.

Frank
Comment 3 Martin Hollmichel 2007-11-09 16:51:48 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 4 daniel.rentz 2007-11-28 10:52:43 UTC 
target
Comment 5 daniel.rentz 2007-11-28 12:45:35 UTC 
fixed in SRC680/xmlfilter02. Import filter will add the parameter 1 (all file
formats: BIFF, OOXML, OOBIN).
Comment 6 daniel.rentz 2008-04-21 08:19:02 UTC 
fixed for XLSX and XLSB files (see issue 88519), XLS still open
Comment 7 daniel.rentz 2008-04-21 08:19:50 UTC 
started
Comment 8 daniel.rentz 2008-09-09 15:30:35 UTC 
*** Issue 93622 has been marked as a duplicate of this issue. ***
Comment 9 daniel.rentz 2008-12-15 15:02:45 UTC 
retargeted due to 3.1 deadline
Comment 10 daniel.rentz 2009-10-13 16:42:20 UTC 
new target