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: [email protected] 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
