Bug 117779 - CALC: Change case in merged cells isn't immediately refreshed until sheet recalculated or revisited
Summary: CALC: Change case in merged cells isn't immediately refreshed until sheet rec...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
Depends on:
Blocks: Character Calc-Merge-Split CaseFolding
  Show dependency treegraph
Reported: 2018-05-24 16:24 UTC by Salim Habchi
Modified: 2024-02-06 09:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

step_to_reproduce (29.97 KB, application/vnd.oasis.opendocument.text)
2018-05-24 16:24 UTC, Salim Habchi

Note You need to log in before you can comment on or make changes to this bug.
Description Salim Habchi 2018-05-24 16:24:56 UTC
Created attachment 142264 [details]

Problem description:
When you apply a format change on merged cells, calc does not regenerate the cell.

Steps to reproduce:
1. Create a spreadsheet.
2. Merge cells A2, A3 and A4.
3. Write a lowercase text in cell A1.
4. Write a lowercase text in cell A2 (merged cells).
5. Select row 1 after that go to menu Format > text > Uppercase.
6. Select row 2 after that go to menu Format > text > Uppercase.
7. A1 is refreshed immediately but not A2.

Operating System: All
Version: Master
Comment 1 Timur 2018-05-24 17:30:54 UTC
I confirm adding that:
- it's not any format change, it's change case, so I'll rename
- same bug with previous LO where we had Format-Change Case and it's exists all the way from OO
- if we do "8. add new sheet, go to it and than to the original" or use Ctrl+Shift+F9 we'll see it is refreshed - so minor bug
Comment 2 QA Administrators 2021-02-24 04:04:43 UTC Comment hidden (obsolete)
Comment 3 Timur 2021-02-24 13:32:38 UTC Comment hidden (obsolete)
Comment 4 Timur 2022-08-12 11:57:00 UTC
Repro 7.5+.
Comment 5 Tex2002ans 2024-02-06 09:14:22 UTC
Still reproduce this in:

Version: (X86_64) / LibreOffice Community
Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

Followed all the steps in Comment #0 (+ verified Comment #1 "refreshed" the letters).

- - -

I'm also adding the "CaseFolding" metabug to this, because it's some strange edge-case.