Bug 61796 - QUERYDESIGN limit window silently ignores invalid values
Summary: QUERYDESIGN limit window silently ignores invalid values
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) Master
Hardware: All All
: medium normal
Assignee: Tamás Zolnai
Depends on:
Reported: 2013-03-04 15:27 UTC by Lionel Elie Mamane
Modified: 2013-03-04 17:11 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Lionel Elie Mamane 2013-03-04 15:27:08 UTC
In query design mode, when entering into the LIMIT box (rightmost element of the default toolbar) any "invalid" string, such as for example "my tailor is rich", the new value is silently discarded instead of displaying a helpful error message.

IMHO that error message should have two buttons, one button that discards the new value and goes back to the old one, and one button that gives the user the opportunity to edit the string without losing what he/she has typed.
Comment 1 Lionel Elie Mamane 2013-03-04 15:32:55 UTC
The "Font Size" box in Writer does yet something else: it silently discards non-digits (such as letters and spaces).

For the sake of consistency, maybe it would be better to do the same for the LIMIT box in Query Design, rather than my personal idea/preference of error message.
Comment 2 Tamás Zolnai 2013-03-04 16:51:07 UTC
Yes, FontSizeBox inherite this behaviour from NumerciBox, from which LimitBox is also derived, so it works the same, at least from this point of view.
Comment 3 Lionel Elie Mamane 2013-03-04 17:11:40 UTC
Indeed, I now see that the new value is completely discarded only if the newly entered string has no digit at all. If I enter a mix of letters and digits, then indeed the letters are dropped and the digits kept. I had not noticed that when I entered this bug.

This is indeed the same behaviour as other similar boxes in LibreOffice, and reasonable. Closing this bug as invalid.