https://bugs.freedesktop.org/show_bug.cgi?id=46047
Bug #: 46047
Summary: today() off-by-one
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 57039
--> https://bugs.freedesktop.org/attachment.cgi?id=57039
what's shown on my screen
The date of today() shown on my screen is off-by-one, see the attachment. Doing
something in the spreadsheet to cause recalculation or just retype the content
of the fields don't seem to have any effect.
If I copy the cells and paste them to notepad, they show up right.
format as date format as numbers
“=now()” 02/14/12 10:43 AM 40951.45
“=today()” 02/14/12 40951.00
“02/13/12” 02/13/12 40950.00
The value is not always wrong. It just changes sometime while I keep the file
open (not necessary overnight, sometimes middle of the day, but I can't tell
exactly when). Usually exiting Calc and restarting it once or twice will get
the correct value back.
LibreOffice 3.4.5
OOO340m1 (Build:502)
(From PortableApps.com)
Options/LibreOffice Calc/Calculate/Date is set to "01/01/1900 (StarCalc 1.0)"
Operating System: Windows XP
Eastern Standard Time
--
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
