https://bugs.documentfoundation.org/show_bug.cgi?id=156520
Bug ID: 156520
Summary: Date acceptance pattern keeps overriding my cells.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Please allow me to turn off date acceptance patterns. If I input any data, that
is arranged anyway like a date, that I want to calculate later off of I get a
date. Changing the cell format to number changes it to a value of the date it
was changed to not the original values. Text format is useless to me as I am
using the data to calculate off of. Forcing your preferences on me makes your
software unusable to me. This is not a feature it is a virus. I have spent over
100 hours trying to make work arounds for this. Keep the Date acceptance
pattern and just allow me to have no patterns in the field, or a check box to
turn it off.
Steps to Reproduce:
1.Type any into any field Jun 17.
2.Calc changes it to 06/17/23.(or whatever you have it changed to in "Date
acceptance pattern")
3.Go to "Date acceptance pattern", find no off button.
Actual Results:
06/17/23
Expected Results:
Jun 17
Reproducible: Always
User Profile Reset: No
Additional Info:
I have to import large sums of data and some data has dates some does not. Any
data similar to a date or is a date not covered by your approved formats, gets
changed to an "approved date format". I am getting flack for this, please help.
--
You are receiving this mail because:
You are the assignee for the bug.
