Description: Libreoffice 6.4.5 on Linux 64bit, Debian testing, German language Database in Base based on Sqlite3: numbers have dots as decimal, Base shows them correct and can use them When copying a table, view or query directly from the base main page, and then pasting to a new calc spreadsheet, numbers are not recognized, either decimal is left out to result in big integers, or numbers are treated as text. Steps to Reproduce: 1. Open database in Base, select query/table, right click, select "copy" 2. Open new spreadsheet, select first cell, right click, select "paste" Actual Results: Numbers have either lost its decimal, or are treated as text Expected Results: numbers are pasted as numbers preserving their value Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Bug happened with 6.4.5, not selectable with the version drop-down above, and I do not recall experiencing this bug in versions before, using this procedure pretty often, so would like to mark it as regression. And it belongs to Base AND Calc, not selectable either and this clearly happens only in languages that do not use dot as decimal
further testing reveals, it's not as simple as this. Numbers, pasted from tables with numbers, stay numbers when pasted. The bug appears when I copy a query that has sums in its columns, then calc won't recognize the sums as numbers. So to reproduce: In Base, create a query with columns that use "sum" as function. Then copy this query, and paste it to a new spreadsheet. The sums paste wrong. Further finding: If I use "paste contents", I can choose between "RTF" or "HTML", but that's the same when pasting a table. So I believe the bug resides within Base, it seems to format sums differently to simple values.
Have tested this with different versions: Created a query with a sum for values with decimal-places. Copy the query through the clipboard (right click - copy, in Calc right click - paste). The decimal-separator has been changed form comma to dot. The value is only recognized as text. Take the query and drag the query from Base to Calc. The decimal separator is comma in Base and in Calc. The value has been recognized as decimal. It's the same behavior in all LO-Versions here. Tested with LO 6.4.5.2 and also older versions like LO 6.1.5.2 Don't know if it is a regression, but I remember there are similar problems diffenert from copy-paste and drag-drop between Calc and Base.
Have forgotten to write down my system: OpenSUSE 15.1 64bit rpm Linux Different LO-Versions tested, oldest version here: LO 6.1.5.2 Tested with internal HSQLDB.
Dear Heinz Repp, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Couldn't reproduce the bug any more with LO 7.3.5.1 on OpenSUSE 15.3 64bit rpm Linux. But couldn't reproduce it also with older versions like LO 6.4.0, where I could reproduce it before. One note: Copying the query through clipboard copies only the decimal places, which are shown through the format in the table. Drag and drop will show the real decimal places saved in the database. I would prefer to set this one to WORKSFORME. Feel free to reopen the bug.
Haven't realised: The decimal separator by the format in Base should be a dot. So changed the language in the table to English and copied through the clipboard into an empty Calc table, which has default language German. Pasting in Calc will shows the dot (and text instead of decimal number), drag and drop from base to Calc wont show the dot, will show comma instead and decimal number. Copy and pasting through clipboard will always show what has been shown when opening the table/query. If there is a dot it will copy a dot, if there are only 2 decimal places instead of 3 decimal places, it will show this 2 decimal places. Don't know if we should set this one as WONTFIX, because it could be an intended behavior and difference between drag and drop and copy and paste.