https://bugs.documentfoundation.org/show_bug.cgi?id=152877
Bug ID: 152877
Summary: Dates are getting formatted as dollar amounts and
can't change
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a series of spreadsheets I use for monthly spending tracking in Calc. I
had been using LibreOffice 6.x since it's release but decided to upgrade this
week. I downloaded and installed version 7.4.3 on Mac OS Catalina. The first
time I opened one of my spreadsheets (an ods file), the dates already entered
were displaying as dollar amounts. I tried clicking to format as date, creating
a new column and starting over, but still no joy.
I created a new, blank spreadsheet and entered a date into an unformatted cell,
12/23/2022 and then clicked the "format as date" button and it changed the date
to a number, 44918 and if I keep clicking it alternates between "12/23/22" and
"44918".
I'm a software engineer so I was curious what that number represented. I'm used
to dates as seconds from epoch (1/1/1970) but these numbers didn't work that
way.
I used an online date calculator and entered the date 12/23/2022 and subtracted
44918 days, it returned December 30, 1899 as the result.
So then I entered 12/23/1899 in the spreadsheet and clicked the "format as
date" button and it displayed "-7". So I think I figured out what it's doing,
just not WHY.
I can provide screenshots and a screen capture video of the issue if needed.
Steps to Reproduce:
1.create spreadsheet (.ods)
2.enter date in an unformatted cell as MM/DD/YY
3.click "format as date" button, see change to number
Actual Results:
in existing spreadsheet, dates are displaying as currency and I'm unable to
change it.
in new spreadsheet, date is displayed as number when clicking "format as date"
Expected Results:
should display cell as a date, not a number (or currency)
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
