You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/05/03 15:02:29 UTC
[Issue 124807] New: auto reformatting / input discarding issue
unresolved for 6 years
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: issues@openoffice.apache.org
Reporter: ilikeweirdstuffs@gmail.com
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.
[Issue 124807] auto reformatting / input discarding issue unresolved
for 6 years
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124807
ilikeweirdstuffs@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |UNCONFIRMED
Resolution|DUPLICATE |---
--- Comment #3 from ilikeweirdstuffs@gmail.com ---
I know that perfectly well.
However
a) it is not an exact duplicate of that issue, because i did not only address
the /disabling/ of the /DATE/ completion in the report
-date string recognition disabling
-GUI addition to better manage ALL string recognition
-addition of string recognition settings to prevent FORMATTING issues
-local date format should have an effect on date recognition
b) That issue has been completely disregarded for the past 6 years. We had two
entirely new versions of OOo since then. I wanted to somehow signalize that
this has been swept under the rug for too long.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124807] auto reformatting / input discarding issue unresolved
for 6 years
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124807
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC|rainerbielefeld_ooo_qa@biel |
|efeldundbuss.de |
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124807] auto reformatting / input discarding issue unresolved
for 6 years
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124807
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Resolution|--- |DUPLICATE
--- Comment #2 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
This is all well known and reported, for example
"Issue 44378 - AutoCorrect Changes Entered Value to Fraction in Date Field"
"Issue 90581 - Option to prevent auto completion of date"
So nothing new in this report, mark it as DUP.
@ilikeweirdstuffs@gmail.com
May I ask you to read <https://wiki.openoffice.org/wiki/QA/HowToFileIssue>
before you submit more reports?
*** This issue has been marked as a duplicate of issue 90581 ***
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124807] auto reformatting / input discarding issue unresolved
for 6 years
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124807
Kay <ks...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Latest|--- |4.1.0
Confirmation on| |
Ever confirmed|0 |1
--- Comment #5 from Kay <ks...@apache.org> ---
See sample 3 column spreadsheet. First column explicitly formatted as "text",
second as "date", and third with default formatting. Entries for all columns
were input exactly as the first column. It therefore seems possible by using
"text" format for complete columns or individual cells to bypass the normal
behavior of converting date-like entries to dates.
Not sure if this a defect. We would need to check the specs and/or discuss this
further on "dev".
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124807] auto reformatting / input discarding issue unresolved
for 6 years
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124807
Kay <ks...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kschenk@apache.org
--- Comment #4 from Kay <ks...@apache.org> ---
Created attachment 83631
--> https://issues.apache.org/ooo/attachment.cgi?id=83631&action=edit
Date like text
Three column spreadsheet and effects of column formatting on processing.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124807] auto reformatting / input discarding issue unresolved
for 6 years
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124807
ilikeweirdstuffs@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ilikeweirdstuffs@gmail.com
--- Comment #1 from ilikeweirdstuffs@gmail.com ---
Additional Comments:
Problems with the "intelligent" input recognition and changing were one of the
reasons i personally switched to OOo. A lot of people i have been talking to
had the same opinion. Now OOo is heading down the same alley.
Basically, i would like any editor program to write exactly what i type,
exactly with the settings i typed it with, by default.
If, and only if i explicitly state that i would like to use its wisdom on how
to do and write things (by pressing a button when typing or clicking a radio
button on program startup) should it make changes to what i typed in.
Having a program that thinks it knows what i want to type better than i do per
default and not even having so much as an OFF switch for this behavior, is
simply awful.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.