Bug 161308 - Spreadsheet formatting changes after upgrading from V7 to V24
Summary: Spreadsheet formatting changes after upgrading from V7 to V24
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
24.2.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Undo-Redo Calc-Cells
  Show dependency treegraph
 
Reported: 2024-05-28 18:13 UTC by steve_atkins
Modified: 2024-05-30 04:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
spreadsheet (62.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-05-28 18:15 UTC, steve_atkins
Details
Screenshot of formatting without borders after pressing Ctrl+Z (16.74 KB, image/png)
2024-05-29 06:25 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description steve_atkins 2024-05-28 18:13:33 UTC
Description:
I have a spreadsheet which I use for solving Suduko.   After upgrading to V24 the formatting changes when I enter a number into the grid.   I can't figure out why.
It happened on the first V24 release and I went back to V7.   Just upgraded again with the latest release and it still happens.   It's really odd.

Steps to Reproduce:
1.Type in a number between 1-9 in any square in the blue-shaded grid (N3-AN29)
2.The formatting in rows 3-11 now changes
3.Type Ctrl-Z and the number disappears but the formatting does not revert

Actual Results:
The number typed appears in the blue shaded grid and disappears from the orange-shaded grid.   However, the formatting of the top part of the blue-shaded grid changes permanently.

Expected Results:
The number typed appears in the blue shaded grid and disappears from the orange-shaded grid.   The formatting does not change.


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 steve_atkins 2024-05-28 18:15:48 UTC
Created attachment 194406 [details]
spreadsheet
Comment 2 raal 2024-05-28 19:04:40 UTC
No repro with Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 71f3be3bee2e8a07f85594c02a9b44627b219e95
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded Jumbo
Comment 3 Robert Großkopf 2024-05-29 06:25:00 UTC
Created attachment 194413 [details]
Screenshot of formatting without borders after pressing Ctrl+Z

Could confirm the buggy behavior.
When pressing Ctrl+Z in 

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

borders in row 3, 6 and 9 of the blue grid will be lost. Also some other depending borders aren't shown any more.
Comment 4 Robert Großkopf 2024-05-29 06:32:00 UTC
This bug won't appear in 

Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 6084962f93efc005b6827edceae12d3170f17ccd
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded