[Libreoffice-qa] Calc quality and compatibility tests

[Eike Rathke]

Hi Pedro,

On Thursday, 2013-02-28 08:55:54 -0800, Pedro wrote:

> > 	So - datefuns works perfectly for me in master and in 4.0; 18 out of
> > 18.
> 
> Really? I get 14 out of 18. 

No wonder, that document uses functionality that varies depending on the
locale in use and as such is an example of how a document is not to be
designed if it is to be used in an internationalized context.

Instead of using DATEVALUE() with an arbitrary string the DATE()
function should be used (best) or DATEVALUE() with an ISO 8601 string
that works in any locale (alternative).

> It surprises me that the MONTH function worked for you. It should fail for
> everyone everywhere because the date for 0 (zero) in Excel is 1/0/1900 while
> in Calc it is 12/30/1899 as default. So MONTH returns 1 in Excel and 12 in
> Calc...

Only for MONTH(0) but that is not used in the document. Excel has that
famous "1900 is a leap year" bug so claims 1900-02-29 would exist, the
one day offset in Calc compensates for that, with the result that dates
between 1900-01-01 and 1900-02-28 are one day off when imported from
Excel, but all dates starting at 1900-03-01 are correct.

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
New GnuPG key 0x65632D3A : 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Old GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD
Support the FSFE, care about Free Software! https://fsfe.org/support/?erack
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice-qa/attachments/20130308/9b589f4f/attachment.pgp>