Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Am 10.10.2015 um 15:27 schrieb Florian Reisinger:
Would you be so kind as to tell us which aspects got worse?

Would you be so kind as to tell us how to enter some numbers into a
Writer table?
LibreOffice 4.4
Ctrl+F12 [Insert]
menu:Table>Number Recognition is checked
Locale is English(UK)

09      3.14
1999-12-31      5.87%
23:45:59        True

Everything is text.
Oh, the number format code of my new table is "@". May be this is the
reason. Change it to "General" since I have entered various subtypes and
"General" is the number format to accept and represent any subtype.
To my surprise, changing the number format attribute converts the text
data to this:

9       3.14
36525   0.06
0.99    1

Everything is converted and rounded to integer and 1/100th decimals.
23:45:59 --> 0.9900000

OK, let's append a new table and apply number format "General" _before_
typing in numerals. Wow, this time it seems to work.
But why is
=SUM(<B1:B3>) = 4.1987000 (correct)
=COUNT(<B1:B3>) = 4.1987000 (expected value is 3)

And why is
=SUM(<B1:B3>) = 3,14
after reloading the same file with a German locale?
Cell B1 has still the "General" number format, B2:B3 is text.
Almost the same in column A. A1 is "General" A2:A3 is "@" but the
forumal cell in A4 still shows the old result cut down to 2 decimals.
When I hit F2 to inspect the formula, the formula bar shows an equal
sign only.

By the way: Did anybody notice that the glorious "date acceptance
patterns" do not work at all?

Just watch the screen shot and the spreadsheet. Every spreadsheet in the
world accepts 2/10/ or 2/10 or 2/ (this month's 2nd) on the num pad.
With German LibreOffice locale it is impossible to enter any date on the
num pad without typing a full ISO date.
You messed this up. The dumb users are happy because they get what they
type as literal text. The educated users (normal users, no experts) are
wondering why there are any "date acceptance patterns" if they get
invalid text data anyway.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.