On 12/29/2012 03:28 PM, Girvin R. Herr wrote:
Greetings,
I noted that after I updated LO from 3.5.7 to 3.6.4, the Base date
entry format flexibility has changed. With a 3.5.7 (and before) Base
form, I could enter 12-29-12 and it would be changed to 12/29/12.
With 3.6.4, entering 12-29-12 will result in a strange date, as if it
were interpreting the dashes as a formula and maybe subtracting the
numbers. Okay, I could live with that because it was apparent that
the date was incorrect. But now I see this is resulting in a Java
error when I accidentally use dashes and try to save the record. I
get "Java.lang.IllegalArgumentException" errors. Even that could be
worked around, if the error message had any diagnostics, such as the
offending date. However, this is all I get. No SQL. No indication
as to what the problem really is. I got a clue by doing a web search
and found a similar error with dates and put two-and-two together to
determine the real cause. I guess my complaint is that between 3.5
and 3.6, the error messages stopped putting diagnostic data into the
message. Has anyone else seen this "feature"?
Is there an option somewhere to add the diagnostics to error messages?
Note that I tried entering 12-29-12 into a Calc date cell where the
format was "MM/DD/YY" and it kept the dashes.
Girvin Herr
If you are going to use a date format with hyphens, perhaps
learning to use this format: YYYY-MM-DD. This is recognized by both Base
and Calc. (Probably by most databases and spreadsheets.
--Dan
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
