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
menu:Table>Number Recognition is checked
Locale is English(UK)
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:
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
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: firstname.lastname@example.org
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
Re: [libreoffice-users] Re: Installing Libreoffice in Ubuntu · Jean-Baptiste Faure
Re: [libreoffice-users] Re: Installing Libreoffice in Ubuntu · Virgil Arrington
Impressum (Legal Info)
: 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