https://bugs.documentfoundation.org/show_bug.cgi?id=163724
Bug ID: 163724
Summary: Missing autodetect functionality for number formats
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Often, one pastes as text values into cells which are actually date & time
specifications; and one then has to Format > Cells... to set the appropriate
number format, especially in the case of Date or Date&Time - and even then, the
setting is manual.
Instead, I believe this should be automated on two levels:
1. When selecting a range of cells, or pasting a range of cells, we should get
a small pop-up for suggested formats to choose.
2. When entering the relevant tab of Format > Cells..., I should be offered an
auto-detected number format based on the values in the selected cell; at least,
I should be able to select an autodetect
If multiple formats are applicable, a choice among them should be offered
rather than just one being a single selected format.
--
You are receiving this mail because:
You are the assignee for the bug.
