https://bugs.documentfoundation.org/show_bug.cgi?id=156088
Bug ID: 156088
Summary: Cutting selected cells in Calc removes direct
formatting
Product: LibreOffice
Version: 7.5.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Cutting selected cells in Calc results in any direct formatting being removed.
I couldn't believe this behavior and thought that there must be some way to
change it, but the answers here confirm that doing so is not possible:
https://ask.libreoffice.org/t/how-to-prevent-cell-formatting-being-removed-when-values-are-cut/53102
I'm sure this bug report will prompt recriminations about using styles rather
than direct formatting, but from my perspective, the issue is one of
consistency: if you direct format a table cell in Writer (e.g., select a cell
and bold it), select the cell, and cut it, it does not revert any direct
formatting made to the cut cell. (Please, please, please don't apply my plea
for consistency in the direction of changing the behavior of cutting Writer
table cells to match the current Calc behavior; I can't fathom why anyone would
want the current Calc behavior in the first place.)
My first choice would be to change the Calc behavior to match that of Writer
tables -- cutting removes the *contents* of the cell (with its formatting), but
does *not* affect the formatting of the cell itself. My second choice would be
to provide a configuration option, similar to what the current "delete
contents" function provides, but allowing setting defaults for cut behavior
rather than having to choose them each time.
Steps to Reproduce:
1. Direct format a cell in a Calc spreadsheet, e.g., bold it.
2. Type some text in the cell.
3. Cut that cell.
4. Type new text in that cell.
Actual Results:
The new text is formatted in the default formatting of the cell, before the
direct formatting changes were made.
Expected Results:
The new text should be formatted according to the direct formatting of the cell
before the cut.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
