https://bugs.documentfoundation.org/show_bug.cgi?id=169937
Bug ID: 169937
Summary: Allow Data Validation (List/Cell Range) to Transfer
Source Cell Formatting
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hi Devs,
I am requesting an important feature enhancement for LibreOffice Calc's Data
Validation (list from cell range).
1. Current Limitation: When creating a drop-down menu (Data Validation) using a
list of values from a cell range (e.g., from Sheet3), the selected value is
transferred to the target cell (e.g., Sheet1.A1), but the formatting (such as
font color, background color, bold text) of the source cell is lost.
2. Why This is a Problem for Users: Many users rely on cell formatting
(especially color) in the source list to convey information (e.g., Red =
Urgent, Green = Complete). When the list is very large (e.g., 500 unique
items), each with a unique or specific color, the only way to re-apply the
formatting is through Conditional Formatting.
Creating 500 separate Conditional Formatting rules (one for each value/color
combination) is extremely time-consuming, difficult to maintain, and does not
scale efficiently. This forces users to resort to complex StarBasic Macros,
which should not be necessary for a basic UI function.
3. Proposed Solution: Please integrate an option within the Data Validation
dialog box that allows the user to automatically apply the formatting of the
source cell to the target cell upon selection.
A simple checkbox in the Criteria tab (where the source range is defined) would
solve this issue:
[ ] Transfer/Apply Source Cell Formatting
If checked, the target cell formatting properties (e.g., CharColor, CharWeight,
CellBackColor) should be inherited from the cell in the source range that holds
the selected value.
Thank you for considering this enhancement, which would significantly improve
Calc's usability for large, color-coded datasets.
--
You are receiving this mail because:
You are the assignee for the bug.
