[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #13 from QA Administrators  ---
Dear Matej HALAC,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #12 from Mike Kaganski  ---
Created attachment 175303
  --> https://bugs.documentfoundation.org/attachment.cgi?id=175303&action=edit
Excel 2016 showing dates before 1904 using base-1904

(In reply to Eike Rathke from comment #3)
> If dateCompatibility=true and date1904=true, the date base is 1904.
> Presumably Excel does not calculate dates before 1904-01-01 so the
> 1900-02-29 problem would be moot (could someone verify?)

What Excel does with pre-epoch dates in this mode is just hilarious - see the
screenshot. Anyway, as you expected, the problem for pre-1904 would not occur.

Wrt dateCompatibility attribute of workbookPr:

there is also [MS-OI29500] "Office Implementation Information for ISO/IEC 29500
Standards Support" document, which is implementation notes for MS Office. It
tells about the mentioned attribute [1]:

> g. The standard states that the dateCompatibility attribute determines whether
> the date base should be treated as a compatibility date base or should support
> the full date range of [ISO-8601].
> 
> Office ignores the dateCompatibility attribute, and always uses a 
> compatibility
> date base.
> 
> This note applies to the following products: Office 2010, Office 2010 Server,
> Office 2010 SP1.
> ...
> j.   The standard states that the dateCompatibility attribute determines 
> whether
> the date base should be treated as a compatibility date base or should support
> the full date range of [ISO-8601].
> 
> Office ignores the dateCompatibility attribute. If workbook@conformance equals
> "strict", the 1900 date system is used. Otherwise the 1900 compatibility date
> system is used. Excel does not support negative serial numbers.
> 
> This note applies to the following products: Office 2013 Client (Strict), 
> Office
> 2013 Server (Strict), Office 2013 Client (Transitional), Office 2013 Server
> (Transitional).

And indeed, the later version of ISO/IEC 29500-1 (namely, 2016 [2]) does not
mention "dateCompatibility" attribute at all.

Now the standard [2] defines workbook@conformance in "18.2.27 workbook
(Workbook)":

> conformance (Document Conformance Class)
> Specifies the conformance class ... to which the SpreadsheetML document 
> conforms.
> If this attribute is omitted, its default value is transitional.

MS implementer notes tell [3]

> b. The standard specifies that the conformance attribute is a valid attribute 
> of
> the workbook element.
> 
> Excel ignores the conformance attribute.
> 
> This note applies to the following products: Office 2010, Office 2010 Server,
> Office 2010 SP1.

... which is expected, since MSO 2010 and earlier presumably did not know (or
at least did not care at all) about that attribute.

So we *possibly* would want to specify the obsolete dateCompatibility attribute
(for completeness?), but need to realize that it will never help.

Also we need to explore why we don't export conformance at all *when saving to
"Office Open XML Spreadsheet"* (which is presumably our name for the
"strict"?). In that mode, as far as I see, dateCompatibility *is* exported
(with the expected zero significance).

[1]
https://docs.microsoft.com/en-us/openspecs/office_standards/ms-oi29500/a251e7c6-7b8a-4e2f-b284-025f9f09ba3e
[2] https://www.iso.org/standard/71691.html
[3]
https://docs.microsoft.com/en-us/openspecs/office_standards/ms-oi29500/7821b8f6-672a-4f05-bc0f-33b818210695

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #11 from QA Administrators  ---
Dear Matej HALAC,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

Aron Budea  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=37
   ||501

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

Aron Budea  changed:

   What|Removed |Added

 CC||pr.nienh...@hccnet.nl

--- Comment #10 from Aron Budea  ---
*** Bug 116572 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #9 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.2.7 or 5.3.3  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170522

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #8 from Buovjaga  ---
(In reply to sdc.blanco from comment #7)
> LO 5.1.2.2 Windows 7   Could not reproduce (with MS Excel 2010)

I still repro with MS Excel 2013
LibO Version: 5.2.0.0.alpha1+
Build ID: 16777b6bb0267c2b0602f1007a1e1fecac81329b
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; 
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-04-29_05:45:00
Locale: fi-FI (fi_FI)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #7 from sdc.bla...@youmail.dk ---
LO 5.1.2.2 Windows 7   Could not reproduce (with MS Excel 2010)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #6 from tommy27  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 

1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 

3. Leave a comment with your results. 

4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

Beluga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #5 from Beluga  ---
(In reply to Matej HALAC from comment #0)
> Steps to reproduce:
> 1. Type the date 11.1.1900 in a field.
> 2. Save as XLS.
> 3. Open in MS Office.
> 
> Current behavior:
> On LibreOffice the date is shown correctly. (11.1.1900) But when I open the
> XLS file in MS Office 2007 the date shows as 12.1.1900.

Reproduced.

Win 8 32-bit
MSO 2013
LibreOffice Version: 4.5.0.0.alpha0+
Build ID: 460b17d2712a80331a83329d2951f3e0303835cd
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-03-14_23:10:42
Locale: fi_FI

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=44453

--- Comment #4 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (4.4.0.3 or later): https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)

Thank you for your help!

-- The LibreOffice QA Team
This NEW Message was generated on: 2015-02-19

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=44453

Kohei Yoshida  changed:

   What|Removed |Added

   Assignee|kohei.yosh...@suse.de   |libreoffice-b...@lists.free
   ||desktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 44453] FILESAVE FILEOPEN .xls: EXCEL Leap year bug has to be mentioned

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=44453

Rainer Bielefeld  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 AssignedTo|libreoffice-b...@lists.free |kohei.yosh...@gmail.com
   |desktop.org |
 CC||LibreOffice@bielefeldundbus
   ||s.de
 Ever Confirmed|0   |1
Summary|EDITING: Date will show |FILESAVE FILEOPEN .xls:
   |different values in MS  |EXCEL Leap year bug has to
   |Office and Libre Office |be mentioned
   |when year is set to 1900.   |
Version|LibO 3.3.4 release  |LibO 3.3.0 Beta2

--- Comment #1 from Rainer Bielefeld  
2012-01-04 11:02:25 PST ---
[Reproducible] with Parallel Dev-Installation of  "LibreOffice 3.5.0 Beta2-
WIN7 Home Premium (64bit) German UI [Build-ID :
8589e48-760cc4d-f39cf3d-1b2857e-60db978]. References were MS OFFICE 2010, and
MS EXCEL Viewer, als Gnumeric

May be there is some kind of EXCEL-bug what has to be mentioned for export of
particular Numbers?
Comparison counting down shows

No  LibO Date EXCEL date
61  01.03.190001.03.1900 
62  28.03.190029.02.1900   

Excel Counts 1900 as a leap year, but it was not
 
 They also have a Saturday, January 0th  1900 in Redmont ;-)

Because of this we can't simply leave the "number behind the date" when we
export to EXCEL.XLS (and import), but we have to modify numbers in Date
formatted fields for import/export within particular date ranges.

That also never worked in OOo, so inherited.
Gnumeric seems to know the EXCEL bug and does it correct.

So this one is more or less a DUP of "Bug 37501 - FILEOPEN Calc shows wrong
date in Excel created .xls".  But I disagree with decision "NOTOURBUG there. We
claim to be able to open and edit EXCEL documents, and so we have to mention
EXCEL bugs for the sake of compatibility.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs