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.