Bug 123907 - Paste Special requires unnecessary Enter and bad broken line(unnecessary)
Summary: Paste Special requires unnecessary Enter and bad broken line(unnecessary)
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Paste-Special
  Show dependency treegraph
 
Reported: 2019-03-06 18:55 UTC by Steve Dulaney
Modified: 2019-03-07 19:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
paste special problems w enter key and broken line (14.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-06 18:55 UTC, Steve Dulaney
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Dulaney 2019-03-06 18:55:48 UTC
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
Comment 1 Mike Kaganski 2019-03-06 19:26:18 UTC
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.
Comment 2 Mike Kaganski 2019-03-06 20:12:17 UTC
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.
Comment 3 Oliver Brinzing 2019-03-07 18:14:49 UTC
(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 ...
Comment 4 Mike Kaganski 2019-03-07 18:24:34 UTC
(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).
Comment 5 Mike Kaganski 2019-03-07 18:38:21 UTC
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.
Comment 6 Oliver Brinzing 2019-03-07 18:44:35 UTC
(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
Comment 7 Mike Kaganski 2019-03-07 19:55:03 UTC
(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.