[Octave-bug-tracker] [bug #62246] [octave forge](io) xlsread miscalculates serial date number using UNO interface

[anonymous]

URL:
  <https://savannah.gnu.org/bugs/?62246>

                 Summary: [octave forge](io) xlsread miscalculates serial date
number using UNO interface
                 Project: GNU Octave
            Submitted by: None
            Submitted on: Fri 01 Apr 2022 12:30:09 PM UTC
                Category: Octave Forge Package
                Severity: 3 - Normal
                Priority: 5 - Normal
              Item Group: Incorrect Result
                  Status: None
             Assigned to: None
         Originator Name: 
        Originator Email: jasmin.zimmer@batop.de
             Open/Closed: Open
                 Release: 6.3.0
         Discussion Lock: Any
        Operating System: Microsoft Windows

    _______________________________________________________

Details:

Hi, 

for reading the raw data of an .ods sheet with a date format, I can see
different results in Windows 10 and Ubuntu. The raw data output on the Windows
machine is equal to the output of LibreOffice's DateValue function, whereas
under Ubuntu it's the actual correct serial date number for further wrangling
in Octave. 

We noticed that by trying the 21st Aug 2008. The output on the Ubuntu machine
is 733641, the output on the Windows machine is 39681, which equals
=DATEVALUE("2008-08-21") in LibreOffice. 

That bug only shows up using the UNO interface of xlsread, using e.g. OCT is a
suitable workaround.




    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?62246>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/