Bug 164792 - Conditional Format entries for all sheets visible at all times, without disambiguation
Summary: Conditional Format entries for all sheets visible at all times, without disam...
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.4.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2025-01-21 20:44 UTC by altasilvapuer@gmail.com
Modified: 2025-01-25 09:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
ZIP contains two ODS files: test.ods created in normal mode, and test_safe.ods created in safe mode. (18.17 KB, application/x-zip-compressed)
2025-01-21 20:44 UTC, altasilvapuer@gmail.com
Details

Note You need to log in before you can comment on or make changes to this bug.
Description altasilvapuer@gmail.com 2025-01-21 20:44:09 UTC
Created attachment 198658 [details]
ZIP contains two ODS files: test.ods created in normal mode, and test_safe.ods created in safe mode.

There are a couple of images in the discussion following my investigation here:
https://ask.libreoffice.org/t/conditional-formatting-window-in-lo-24-8/116898/3

Two test files are attached: test.ods and test_safe.ods.
The first was performed in normal mode, immediately following a computer restart.  The second was performed in safe mode (radio button set to the "factory settings" option, and then hit "Continue"), immediately following the creation of test.ods.  (I closed LibreOffice in between the two tests, but did not restart the computer).

Reproduction procedure:
1. Open LibreOffice
2. Create new Calc Sheet
3. Enter random values in Column A on Sheet1.
4. Add new sheet, “Sheet2”, via the Plus sign at the bottom.
5. Enter random values in Column A on Sheet2.
6. Navigate back to Sheet1.
7. Format >> Conditional >> Manage
8. Click “Add”
9. Manually input “A:A” in the range, put the value “foo” (in quotes) in the value field, and select a style. Hit “OK”.
10. Navigate to Sheet2.
11. Repeat steps 7–9, without ever going back to Sheet1. Note that the conditional from Sheet1 was already visible in the window.


NOTE: There was also a transient bug in my general use and in my initial testing where conditional formatting for Sheet1 appeared to become also attached to Sheet2 (as if it had been CREATED on Sheet2, as well as Sheet1), but I haven't isolated or reproduced it in focused testing, so I haven't created a bug for that, yet.  I only mention it in case it brings to mind anything relevant for other testers.  If/when I'm able to consistently replicate it and rule out user error, I'll create a separate bug for it.
Comment 1 altasilvapuer@gmail.com 2025-01-21 21:06:22 UTC
Forgot the version info:

Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 16; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 2 Johannes 2025-01-22 10:37:07 UTC
Reproducible in
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: kf6 (cairo+wayland)
Locale: nl-NL (nl_NL.UTF-8); UI: nl-NL
24.8.4-2
Calc: threaded

But not in
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 47e110fc66292e76152252a90a0e20580c33c13d
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+wayland)
Locale: nl-NL (nl_NL.UTF-8); UI: en-US
Calc: threaded

Can you please check this in 25.8? I think this has been solved already.
Comment 3 raal 2025-01-23 18:25:59 UTC
You can download dev version it here:
http://dev-builds.libreoffice.org/daily/master/
Thank you