Bug 105959 - FORMATTING in Calc --change case does not happen across cells
Summary: FORMATTING in Calc --change case does not happen across cells
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Character Calc-Cells
  Show dependency treegraph
Reported: 2017-02-12 16:16 UTC by kussh
Modified: 2021-02-25 10:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description kussh 2017-02-12 16:16:34 UTC
I have to change the case of each cell one by one. The contents of the marked cells' contents cannot be formatted in one go. This is a pain as each cell has to be navigated to, one by one, then marked and then formatted. I removed all formatting from the sheet also and used control-M shortcut to get the change case feature to work but it didn't happen as it should. I even closed Libreoffice and reopened the sheet but the change case formatting feature did not work across any of the marked cells. They had to be marked one by one and then formatted .
Comment 1 Buovjaga 2017-02-12 18:07:13 UTC
I have no problem changing the case with Format - Text on a selection with multiple cells. The cells can be anywhere and I select with Ctrl click.

Do you have the problem in a compeltely fresh file or just some specific file?
Please also try with a newer version.

Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.

Arch Linux 64-bit, KDE Plasma 5
Build ID: ac8197327d3ef4f3c94fb0746393863404df086b
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on February 11th 2016
Comment 2 kussh 2017-02-12 20:28:29 UTC
Yes the problem goes away when individual cells are marked by using Ctrl and Click. Then they can be formatted as desired.

I had not used this method of individually marking each cell earlier. But had marked from 1st cell to last cell across various columns and rows using shift and CTRl-end keys. When thus selected, the formatting by changing the case does not work.
Comment 3 kussh 2017-02-12 20:42:59 UTC
My problem is solved by marking each individual cell this way using CTRL and click. However it would be better to have this formatting work using SHIFT and Home and Shift and end keys. 

I have a workaround now for the bug. A little extra effort but Thanks. I am using Ubuntu 16.04 and this version of libreoffice comes with it--so i don't want to upgrade libreoffice manually which is a very tiresome process. 

I checked the workaround in a new ods file i created as well as the one where the problem occured and was reported. Both files needed to use the CTRL + click workaround
Comment 4 m_a_riosv 2017-02-12 23:01:07 UTC
With SHIFT the selection it's up to first/last cell on the row.

But with SHIFT or SHIFT+CTRL+(home|end), cell conversion it's only done on the first cell of the selection.

There is some kind of issue.
Comment 5 QA Administrators 2018-02-13 03:32:47 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2021-02-24 04:04:19 UTC Comment hidden (obsolete)
Comment 7 kussh 2021-02-25 08:25:58 UTC Comment hidden (obsolete)
Comment 8 kussh 2021-02-25 08:26:14 UTC
Comment 9 Buovjaga 2021-02-25 10:10:11 UTC
Yeah, wfm for me as well