Bug 57597 - Spreadsheet: WEEKNUM in french localization (NO.SEMAINE) don't match with help
Summary: Spreadsheet: WEEKNUM in french localization (NO.SEMAINE) don't match with help
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
3.6.3.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: regression
Depends on:
Blocks:
 
Reported: 2012-11-27 07:49 UTC by Alexandre Scherly
Modified: 2013-03-29 20:21 UTC (History)
1 user (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 Alexandre Scherly 2012-11-27 07:49:10 UTC 
Problem description: 
In the help, the function is describe like NO.SEMAINE("01/01/1995";2). But to work properly, we need to give de date in ISO format YYYY/MM/DD 2012/11/27 . 

Current behavior:
Help don't match with the function

Expected behavior:
Change the help to describe correctly the function
              
Operating System: Windows 7
Last worked in: 3.4.4 release
Comment 1 Julien Nabet 2012-12-22 14:56:34 UTC 
On Win7 64 with 3.6.4.3 and French localization, I just opened a brand new file, copied pasted the 2 examples from Help and had the same results.
(=NO.SEMAINE("01/01/1995";1) renvoie 1
=NO.SEMAINE("01-01-95";2) renvoie 52)

Could you give a try to 3.6.4.3?
Comment 2 Andras Timar 2013-03-29 20:21:00 UTC 
No reaction from the reporter, according to Julien's comment it is a WORKSFORME.