https://bugs.freedesktop.org/show_bug.cgi?id=80983
--- Comment #4 from [email protected] --- You just CONFIRMED it is a bug, did you NOT? Since "Ctrl-Insert and Shift-Insert are not assigned any bindings", should it not just do what it did for the past 20 years ??? Talking about what "MS Excel does" is a distraction, because this does not relate to Excel or any other spreadsheet software. It worked correctly in the previous versions. The correct way is: you want a piece of a text or equation from one cell pasted into a cell or equation in the other cell, you DO NOT EVER want the complete properties of one cell moved to another, otherwise you would NOT be editing the contents in the first place. Say you wanted a piece of an equation to be copied and paste it to finish some equation in another cell. Would you like fries with that? For example: your background to be changed to RED and your text color to BLUE and set borders around the cell you are editing an equation in? But the bug goes on much deeper than that. I just discovered that while I pasted a table from a web browser into one spreadsheet, the plaintext of that was inserted into a SINGLE cell in another spreadsheet that was open somewhere else, the contents of it thus are: "=H11/2'file:///home/user/documents/tables.ods'#sheet1.a10792014-6-15 0:0:0 521.001 542 571.371 502 629..." I do not know who, when or for what purpose changed the behavior, but this is one serious hack. Should I assume that Libre Office just accesses the contents of the buffer and pastes it anywhere it likes? I corrected the part of the table, erased "cell formatting" on the range, set format to display one digit. Saved. Now it displays "###". Repeat ad libitum. The button to decrease the number of decimal places does not do anything, only either manually change cell properties or erase formatting and set anew. When I paste the contents here, it is clear why the "###". No matter how many times I click in decreasing the number of decimals, nothing changes. What process happens during the save that edits the spreadsheet? Why does save do any spreadsheet WRITE access? 11.1023381948 22.2046763896 67 8.2174608927 16.4349217855 49 6.0822019956 12.1644039911 36 4.5017775683 9.0035551365 27 3.332017136 6.6640342721 20 2.4662120743 4.9324241487 15 1.8253813673 3.6507627346 11 1.3510667516 2.7021335032 8 1 2 6 -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
