Created attachment 149771 [details] paste special problems w enter key and broken line You All do an excellent job 1 A few suggetions. Broken Lines in paste special serves no purpose as far as I can see, and you have to hit the enter key (for no reason at all) Openoffice calc did not have this And it messes up my macros See Brokenlines attached file Can you take the broken lines Out and need to hit the Enter key Out 2 The msgboxes , print and msgbox in macros would be better without the Warning or the big i. If i want warning or i, I will write it in the msgbox. Not everything is a warning or a big i. 3 Libre office messed up my borders as opposed to Openoffice. An old trick is to format an area to white borders and with in it have a smaller area to format to black. Otherwise you would have to get rid of the grid and add the borders to huge areas. You only need a white area for a small part of the screen that the user sees. Openoffice does the corners right. 4 when I start libreoffice calc it would be nice if it asked if i want to recover a file 1 time, not three times. Other than that you all have done vast improvements. Great job Excellent Excellent Excellent
So - what is a "Broken line"? How do I see it? and where do I need to press Enter key and for what? Please don't make reports with multiple problems. One problem per report, please.
I suppose that the "broken lines" are the animated rectangular selection around A1:B2 after the macro execution. I do reproduce a problem with the macro in the attachment. First, it indeed keeps the selection frame around A1:B2 (unlike AOO) - but I'm not sure it's a bug: the macro literally repeats user's actions, and there's no action to cancel the selection in the macro. The real problem is that after the macro finishes, the data is already pasted to the target range, *but the paste function is still working*, so if you don't press Enter or Esc immediately, but instead put cursor to, say, C5, and then press Enter, the clipboard contents is pasted there second time. At the same time, the toolbar controls return to normal state. Tested with Version: 6.2.2.1 (x64) Build ID: fcd633fb1bf21b0a99c9acb3ad6e526437947b01 CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded Setting to NEW. Please note that this issue should be *only* about the macro problem. Please file the other problems separately. Thanks.
(In reply to Mike Kaganski from comment #2) > I do reproduce a problem with the macro in the attachment. if i copy and paste the cell range manually, the "broken" lines are still visible too, canceling works with ESC key btw: ms excel does it same ...
(In reply to Oliver Brinzing from comment #3) > (In reply to Mike Kaganski from comment #2) > > I do reproduce a problem with the macro in the attachment. > > if i copy and paste the cell range manually, the "broken" lines are still > visible too, canceling works with ESC key > btw: ms excel does it same ... Hmm - but I hoped I was clear in my reproduction description: I said that, while I see the selection kept, I'm not sure that it's a problem, since it literally follows user's actions - but what *is* a problem is that *after* it pasted, pressing Enter makes second paste (which is visible if you reposition selection before pressing Enter).
Steps: 1. Open the attachment, allow macros; 2. Press the button => see that G1:H2 is selected and filled with copy of A1:B2 3. Click to G5 and press Enter => G5:H6 is selected and filled with copy of A1:B2.
(In reply to Mike Kaganski from comment #5) IMHO this is a feature, cause this is excatly the same way as excel does: szenario 1 (copy once) - select cell range - ctrl+c - select target cell - (enter) -> cell range is copied, "broken" lines disapear, ctrl+v does not work szenario 2 (copy multiple times) - select cell range - ctrl+c - select target cell - ctrl+v -> cell range is copied - ctrl+v -> cell range is copied - enter -> cell range is copied, "broken" lines disapear, ctrl+v does not work or use ESC to stop
(In reply to Oliver Brinzing from comment #6) You are quite right! I didn't notice that using the UI, I have the same behavior. (In reply to Steve Dulaney from comment #0) So this is not a bug. Your macro just repeats user actions; and performing those actions in LibreOffice gives the same results. That user interactions in LO changed was the result of UI improvements, so not UI in LO and AOO differs. You need to use LibreOffice API to create a robust macro, not macro recorder, to reach your goal. Closing NOTABUG.