[libreoffice-users] Re: Installing Libreoffice in Ubuntu

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
menu:File>New>Text
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)
and
=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?

> https://bugs.documentfoundation.org/show_bug.cgi?id=94727

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: users+unsubscribe@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