Apache OpenOffice (AOO) Bugzilla – Issue 56869
AutoInput does not honour reproduce case of previous entry
Last modified: 2009-07-22 12:17:03 UTC
NB version may be incorrect (help about shows 1.9.122) In a new sheet (with autoinsert on) if you insert: A1: "Test" (return) A2: "TE" (return) - completes to "TEst" Note that A2 reads TEst (with both initial letters upper case). The documentation suggests: "AutoInput is case-sensitive. If, for example, you have written "Total" in a cell, you cannot enter "total" in another cell of the same column without first deactivating AutoInput." This would suggest, we would expect to see "Test" rather than "TEst" in cell A2 Furthermore: A3 -> "Test" (return) (or "T" or "Te", or "Tes") gets converted to "TEst". This means that I can never go back to the original Test entry once I have entered TEst in the column. I can't actually work out what rules are used to determine whether the old version, or new version should be used. In particular: B1 -> "alpha" B2 -> "Al" (return) -> "alpha" B3 -> "aL" (return) -> "aLpha" B4 -> "al" (return) -> "aLpha" B5 -> "AL" (return) -> "ALpha" B6 -> "al" (return) -> "ALpha" B7 -> "Al" (return) -> "ALpha" Either way there should be some consistency, either the case should be consistent throughout (which is what I understand the documentation as meaning), or it should be possible without revering to the completion list of entering any version of the autoinput text.
Can't reproduce with OOo 2.0 680m143 Build8986 (WinXP SP2). after entering "alpha" on B1 all others entries returns me "alpha". seems to be fixed.
I'm closing this one, as it can't be reproducible anymore. Reporter, feel free to reopen it if the behavior returns.
This still does not work correctly in Calc Ooo 2.1 * Open a blank spreadsheet * Enter "De Clippeleer" then in the next cell "De Brabander" * Now have autoinput do its work: in the next cell, type "de b". After pressing Enter, "de brabander" is entered instead of "De Brabander" Another example (but less "real life") * enter "tEST" * In the next cell type "te" and Enter: "Test" rather than "tEST" is entered.
The Issue you raised has been marked as 'Resolved' and not updated within the last 1 year+. I am therefore setting this issue to 'Verified' as the first step towards Closing it. If you feel this is incorrect, please re-open the issue and add any comments. Many thanks, Andrew Cleaning-up and Closing old Issues ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
As per previous posting: Verified -> Closed. A Closed Issue is a Happy Issue (TM). Regards, Andrew
In Open Office 3.1.0 this issue seems to have re-appeared. Do we reopen, or post a new bug? On a side note, while I miss the auto-capitalization it would be nice to be able to do both... i.e. accept the autoinput, but then also be able to enter the cell and make a variation on it. But I'm not using Calc in any kind of Traditional way.