https://bugs.documentfoundation.org/show_bug.cgi?id=150264
Bug ID: 150264
Summary: FORMATTING: UI improvements to add automatic data
validation of dates
Product: LibreOffice
Version: 7.5.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 181585
--> https://bugs.documentfoundation.org/attachment.cgi?id=181585&action=edit
UI mockup of suggested checkbox addition to the Format Cells dialog.
Given the proper context, it's just nice when software does some things
automatically for you. Take for example formatting text data cells to date
format. It would just be amazing beyond all reason if there were a checkbox to
include a data validation pass which checks the contents of the cells being
reformatted and, providing the contents match the given Format Code, Calc
should then convert the contents to match the data type of the cell.
I've attached a mockup of my initial idea for this - Placing it in this
dialogue under the Format Code makes it both a convenient and intuitive
solution, which negates the need for a separate dialogue.
I think it's fine if it's off by default. It's discoverable enough that the
user has a clear choice. I suspect with regard to dates, most users will check
that box, but I'm open to also discussing alternative solutions, which don't
require installing plugins, or using error-prone reg-ex or find and replace
methods. :)
--
You are receiving this mail because:
You are the assignee for the bug.
