Bug 35148 - Pasting raw text doesn't highlight affected cells
Summary: Pasting raw text doesn't highlight affected cells
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Paste
  Show dependency treegraph
Reported: 2011-03-09 05:52 UTC by Dakov
Modified: 2020-06-07 15:45 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Dakov 2011-03-09 05:52:27 UTC
Normally when pasting cells the affected cells are highlighted which is very useful.

But pasting this raw text (notice the tabs):

11,473	11,882
11,882	12,44
12,44	12,973
12,973	13,112
13,112	13,495
13,495	13,887
13,887	14,478
14,478	15,019
15,019	15,159
15,159	15,591

...into a spreadsheet brings up the text import options - there I turn on Tab as seperator and press Return - overwrites the cells but they aren't highlighed.
Comment 1 Björn Michaelsen 2011-12-23 11:47:18 UTC Comment hidden (obsolete)
Comment 2 Florian Reisinger 2012-08-14 14:00:23 UTC Comment hidden (obsolete)
Comment 3 Florian Reisinger 2012-08-14 14:01:30 UTC Comment hidden (obsolete)
Comment 4 Florian Reisinger 2012-08-14 14:06:14 UTC Comment hidden (obsolete)
Comment 5 Florian Reisinger 2012-08-14 14:08:15 UTC Comment hidden (obsolete)
Comment 6 Dakov 2012-08-14 14:11:25 UTC
Paste this into a filled (not empty) spreadsheet (must be seperated by tabs):

11,473	11,882
11,882	12,44
12,44	12,973
12,973	13,112
13,112	13,495
13,495	13,887
13,887	14,478
14,478	15,019
15,019	15,159
15,159	15,591

Accept the Text import options (Tab is selected as seperation)

Notice that the overwritten cells are NOT highlighted even though they should be to show what you changed.

When you Undo the pasting the cells get highlighted but otherwise there's no indication of which was overwritten (I think there used to be).
Comment 7 Florian Reisinger 2012-08-15 07:02:28 UTC
Okay, can confirm that ;)

There is only one thing left: Could you please set "Version" to the oldest version affected. Please set the status to "NEW" after doing that. I can confirm it with
Comment 8 Dakov 2012-08-15 07:21:42 UTC
I'm sorry I don't remember what it said - I just changed it to my current version and re-opened it.
Comment 9 Rainer Bielefeld Retired 2012-08-17 05:12:53 UTC
@filkin , Florian,
To be honest: I do not understand anything you are discussing here. 
Of course I can reproduce the effect that ANY copy paste from a different application than Calc to Calc will not highlight the cells with pasted contents. Although I never did a methodical research, I am pretty sure that this behavior never has been different. At least a quick test with OOo 1.1.5 and copy / Paste some text with TABs in the columns also did not highlight.

What do you want to tell with "notice the tabs" in your report? the numbers in a line are not in your example are not separated by TABs, but by spaces. And why do you insist in a filled table? For me there is no difference whether I paste into empty cells or into filled ones, pasting from other applications never highlight the target cells.

As you see I am not sure whether I understood the report. Is the effect I described above the reason for your report? If yes, I see this as an enhancement request. And I agree, for very most applications it really is useful to have the target cells highlighted.

Please mention you OS in your comments!
Comment 10 Florian Reisinger 2012-08-18 19:28:11 UTC
(In reply to comment #9)
> @Florian:
> Please mention you OS in your comments!

Sorry, Win 7 SP1 x64

IMHO this seems like NOTABUG... Isn't it??
Comment 11 Dakov 2012-08-18 20:49:52 UTC
Wait, guys. I think I remember why I reported this many years ago.

If you paste copied CELLs into a filled sheet those cells overwritten gets highlighted right?

If so clearly pasting raw text should act the exact same way to keep consitent and logical behaviour, predictability and user-friendliness, right??
Comment 12 Joel Madero 2013-05-28 15:37:46 UTC Comment hidden (obsolete)
Comment 13 Florian Reisinger 2013-05-28 18:04:35 UTC
Okay -> enhancement, as Rainer said since OO.org times... Thanks for reporting :)
Comment 14 Thomas Lendo 2017-09-24 22:39:40 UTC
Reproducible with Version:
Build ID: 722161e26437b25adc449f773836d369bd0cb081
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; 
Locale: de-DE (de_DE.UTF-8); Calc: group
moggi's auto updater build, 2017-09-24

For me, this is a bug and not an enhancement request as other paste events are highlighting effected cells. Not here.