Bug 93653 - Space added when pasting a cell in the formula bar
Summary: Space added when pasting a cell in the formula bar
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: Other All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: possibleRegression
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2015-08-25 13:52 UTC by Nikos Platis
Modified: 2019-05-09 09:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nikos Platis 2015-08-25 13:52:22 UTC
1. Create a new spreadsheet with, for example, text "abc" in A1 and "def" in A2.
2. Go to cell A2 and copy it (Ctrl + C)
3. Go to cell A1, go to the Formula Bar, and paste (Ctrl + V).

--> On the formula bar you see "abcdef " (with a space appended at the end).

4. Press Enter and inspect cell A1 again: the appended space has disappeared!

5. Repeat steps 2 and 3, and this time, try to delete the appended space by pressing BackSpace. Observe that on the Formula Bar you seem to actually be deleting the appended space, but on the cell it appears that you delete the last letter! Press Enter and observe that the contents of the cell, not the Formula Bar, get stored in the cell.

All this is obviously wrong.

Notice that it happens only if you have copied and pasted a full cell, not simple text (in which case it works correctly).
Comment 1 Matthew Holloway 2015-08-27 01:59:53 UTC
Reproducible.

Interesting that copying the `def` cell into gedit results in def\x0A, and then copying gedit's content into the `abc`'s formula bar doesn't cause this behaviour. This implies that there's an interaction between the clipboard format and the formula bar (if indeed this is a bug)
Comment 2 raal 2015-08-31 08:38:19 UTC
Reproducible with LO 5.0.0.5
ID build: 1b1a90865e348b492231e1c451437d7a15bb262b, win7
Comment 3 QA Administrators 2016-09-20 10:28:21 UTC Comment hidden (obsolete)
Comment 4 Nikos Platis 2016-09-20 11:03:23 UTC
Partially fixed in version 5.2.1.2 (on Arch Linux).

The first three steps of the original report still hold:

1. Create a new spreadsheet with, for example, text "abc" in A1 and "def" in A2.
2. Go to cell A2 and copy it (Ctrl + C)
3. Go to cell A1, go to the Formula Bar, and paste (Ctrl + V).

--> On the formula bar you see "abcdef " (with a space appended at the end).

This space at the end (in fact, at the end of the pasted content) is still there.


Fortunately, this space is handled correctly during deletion, so the rest of the original report (steps 4 and 5) does not hold.
Comment 5 QA Administrators 2018-06-21 02:51:38 UTC Comment hidden (obsolete)
Comment 6 Nikos Platis 2018-06-21 04:32:41 UTC Comment hidden (obsolete)
Comment 7 Nikos Platis 2018-06-21 04:34:00 UTC
(In reply to Nikos Platis from comment #6)
> Still holds exactly as reported in Comment 4

Sorry, forgot to mention version: now on version 6.0.4.2
Comment 8 Timur 2019-05-09 09:19:37 UTC
Please don't confirm titles like "Strange behavior" but describe that behavior. 
I change to "Space added when pasting a cell in the formula bar".
It's in no way "major".

No repro LO 5.1. Repro 5.2 and 6.3+.

Question here is could or should this be fixed or why cell can be pasted in formula bar at all. MSO doesn't allow this. 
If space is a price, then it may be acceptable.