Bug 158615 - Simplify storing of the "zero date" setting in Calc settings
Summary: Simplify storing of the "zero date" setting in Calc settings
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks: Calc-Date-and-Time
  Show dependency tree / graph
 
Reported: 2023-12-09 15:57 UTC by Gabor Kelemen (Collabora)
Modified: 2025-12-16 09:03 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (Collabora) 2023-12-09 15:57:51 UTC 
This is a followup to bug 158467

The Calc - Calculate - Date setting defines what should be considered the 0 value in date calculations. This setting is stored as a set of 3 keys[1], which is a bit overcomplicated for such a simple 3 state radio button.

It would be a somewhat simpler implementation to replace these 3 keys with a single (for example:) ZeroDate key.

Code pointers:

[1] https://opengrok.libreoffice.org/xref/core/officecfg/registry/schema/org/openoffice/Office/Calc.xcs?r=464d5f12#45 - the keys in question

https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/docoptio.cxx?r=14001bc7#155 - the relevant ScDocCfg class
Comment 1 Heiko Tietze 2025-12-15 09:54:20 UTC 
To my understanding we need all three options for compatibility with StarCalc and Excel spreadsheets. Plus, what could a single option "ZeroDate" mean? It's obviously tech-talk and not user-centered. => WF

(I don't follow Olivier's UNCONFIRMED to NEW change as in 'valid enhancement request'.)