Bug 86099 - Mass selection of cells acts funny after Format Paintbrush has been used
Summary: Mass selection of cells acts funny after Format Paintbrush has been used
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: x86-64 (AMD64) All
: low minor
Assignee: Not Assigned
Keywords: preBibisect, regression
Depends on:
Blocks: Clone-Formatting
  Show dependency treegraph
Reported: 2014-11-10 08:45 UTC by Ajinkya Dahale
Modified: 2021-05-23 02:29 UTC (History)
3 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 Ajinkya Dahale 2014-11-10 08:45:47 UTC
Problem description: 
Regardless of where one copies the formatting from, once the formatting has been pasted and some editing is performed, Shift + arrow keys select all cells from A1.

Steps to reproduce:
1. Go to an arbitrary cell and press Format Paintbrush.
2. Copy the formatting to to any other arbitrary cell, optionally edit content, and press Enter.
3. Press shift + arrow keys to select multiple cells.

Current behavior:
Calc treats it as if all the cells from A1 to the current cell were selected. So Shift + Down selects A2:<current cell>, Shift + Right selects B1:<current cell> and Shift + Up/Left selects A1:<current cell>. 

Expected behavior:
Selecting a rectangular region starting from the originally selected cell.
Comment 1 raal 2014-11-16 15:23:59 UTC
I can confirm with Version:
Build ID: 2f342c61616418c6ad7303d7f5efa27a28378681
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-11-12_00:13:54
Comment 2 raal 2014-11-16 15:27:22 UTC
Same problem in LibreOffice 3.5.0 Build ID: d6cde02, setting version to oldest known.
Comment 3 Matthew Francis 2015-04-23 10:23:04 UTC
I can reproduce this in LibreOffice 3.3.0, but not OOo 3.3.0 - so this appears to be one of our rare first release bugs
Comment 4 Robinson Tryon (qubit) 2015-12-14 05:40:09 UTC Comment hidden (obsolete)
Comment 5 Jean-Baptiste Faure 2016-04-10 11:54:11 UTC
Still reproducible with LO and master (Version:
Build ID: 43109b751bf5fd36318de56b2fb686acc724673f) built at home under Ubuntu 15.10 x86-64.

That said, the button "clone formatting" is not anymore in the default formatting toolbar and it is not in the sidebar.
It is enough to deselect and reselect the current cell to prevent this weird behavior. So lowering the importance of this bug.

Best regards. JBF
Comment 6 QA Administrators 2017-05-22 13:26:10 UTC Comment hidden (obsolete)
Comment 7 Jean-Baptiste Faure 2017-07-29 21:12:03 UTC
Not reproducible anymore for me with LO built at home under Ubuntu 16.04 x86-64. 

Closing as WorksForMe.
Please feel free to reopen and set back to NEW if you still reproduce this bug.

Best regards. JBF