https://issues.apache.org/ooo/show_bug.cgi?id=124807
Issue ID: 124807
Issue Type: DEFECT
Summary: auto reformatting / input discarding issue unresolved
for 6 years
Product: Calc
Version: 4.1.0
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: configuration
Assignee: [email protected]
Reporter: [email protected]
This issue has been around since 2008 as this bugtracker and other forums
prove. This problem was confirmed and then forgotten about.
Strings of the format [number1]/[number2] get autoformatted into dates and
furthermore the input gets changed.
-This is immensely annoying since spreadsheet programs like calc mostly work on
a WYTIWYG principle. Having to type an extra character (specifically: ') just
to get the program to use the input you're actually giving it is extremely
inconvenient for the 21st century.
-OOo Calc replaces my string {2/8} with {41678} once i reset the format to be
numerical again. A program deciding to discard user input and use something
else instead, without an option to turn this behavior off is bugged. This
"feature" is a bug.
-Some people would like to use Calc to make tables with not only a single
string type in it. Calc deciding that it needs to change text alignment too
because instead of a numerical string i typed an alphabetical string in this
cell, can be a major annoyance.
-The date format XX/XX/XX is strictly speaking incorrect in two of the
languages i use with OOo (German and Hungarian). Thus the program interpreting
a {2/8} input as date is also grammatically wrong, because in these languages a
slash separating month, date and year is either extremely uncommon or simply
incorrect.
Suggestions:
1A) Most importantly and first of all: Calc needs a button to disable the
automatic recognition of date strings.
2A) In future versions it would be helpful and not too difficult to implement
to have checkboxes for what type of strings Calc should recognize.
2B) In future versions, along with the checkboxes mentioned above should come a
submenu for each string type detailing which format Calc should use as a
default format for all newly recognized strings of that type. (As already seen
in the R-click > Format cells window)
2C) In future versions along with the string recognition submenu should come
the Advanced options of defining how a certain string type should and should
not be recognized. (Thus being given the option to disable xx/xx registering as
a date, and being able to set that only xx.xx.xx, xxxx.xx.xx and xx.xx.xxxx
should be recognized)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
