Apache OpenOffice (AOO) Bugzilla – Issue 104346
Pattern field must remove ending spaces and not fills up with blanks
Last modified: 2020-03-06 16:11:03 UTC
the summary says it: It is annoying that one needs to define the mask for the character-entry for the whole expected length, but places that need no entry on actual data-entry will be filled up with blanks. (Like: MASK CCCCCCCCCC - entry ABC123 - should not ad four blanks/spaces) Just leave it as entered - with 6 characters as in the example Martin
are we talking 'bout pattern fields here?
>fs no, not about patterns (like the examples __.__.2009 etc) but exclusively the mask to destinguish the allowed character-input (the first of the property-fields) give it a try, and you will see what I mean: The cursor is behind the spaces inserted by the system - that looks strange and and is not functional for editing . Martin
So we *do* talk about pattern fields here :) I still do not completely get you. What do you mean with "The cursor is behind the spaces inserted by the system"? (You might want to take item 3 and 4 on http://qa.openoffice.org/issue_handling/basic_rules.html more serious :) ) So, you enter an "Edit mask" of, say, "CCCCCCCC", leave the Literal masks empty, enter a text like "abc", and the problem is that this is expanded to "abc " - yes?
yes - exactly like that Martin
I confirm that pattern is recorded as is. A string completed with ending spaces is not a problem. You can use RTRIM in SQL to remove it.