Bug 168585 - WEEKNUM_EXCEL2003 is not stored to ODS
Summary: WEEKNUM_EXCEL2003 is not stored to ODS
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-09-28 08:39 UTC by Mike Kaganski
Modified: 2025-10-02 12:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2025-09-28 08:39:40 UTC 
Create a Calc document.
Put this formula to a cell:

=WEEKNUM_EXCEL2003("2025-12-31";1)

Check that the result is 53.

Save to ODS and reload

=> the formula is '=WEEKNUM("2025-12-31";1)', and the result is 1.
Comment 1 m_a_riosv 2025-09-28 09:19:49 UTC 
Reproducible with
Versión: 5.4.7.2
Id. de compilación: c838ef25c16710f8838b1faec480ebba495259d0
Subprocs. CPU: 16; SO: Windows 6.2; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: CL


Importing with Version 3.6.7.2 (Build ID: e183d5b), Excel WEEKNUM() is imported as 
WEEKNUM_ADD() and it is preserved, saving as ODS.

Maybe the WEEKNUM_ADD was not rename properly in every place toWEEKNUM_EXCEL2003
Comment 2 Saburo 2025-10-02 12:48:31 UTC 
Version: 5.1.0.0.alpha1+
commit f830600ece806ec365a4839e79afabe183c5e36d
tdf#50950 Add ODFF1.2 Calc function ISOWEEKNUM,

Even before this commit, other lcm_add and gcd_add are saved as lcm and gcd.

Adding CC: Eike Rathke
tdf#50950 comment 6 wrote
/scaddins/source/analysis/analysishelper.cxx
Are UNIQUE and DOUBLE related?