[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Octave-bug-tracker] [bug #62246] [octave forge](io) xlsread miscalculat
From: |
anonymous |
Subject: |
[Octave-bug-tracker] [bug #62246] [octave forge](io) xlsread miscalculates serial date number using UNO interface |
Date: |
Fri, 1 Apr 2022 08:30:11 -0400 (EDT) |
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/
- [Octave-bug-tracker] [bug #62246] [octave forge](io) xlsread miscalculates serial date number using UNO interface,
anonymous <=