https://bugs.documentfoundation.org/show_bug.cgi?id=113307
--- Comment #8 from ady <[email protected]> --- For the copying purposes, the only format that is being considered is the main format for the cell. IOW, conditional formatting is correctly considered for displaying within Calc, but it is ignored for copy+paste to Writer. For example, setting the main cells format to "Default" in the provided attachment in comment #1, the cells are displayed according to their conditional format within Calc: 446 -> "#,##0" (Whole numbers style) 90.9 -> "#,##0.###" (Decimal numbers style) 4.906 -> "#,##0.###" (Decimal numbers style) That last 4.906 is the display (CF) of the real value resulting from 446/90.9. When copying these cells to writer, they are pasted as: 446 90.9 4.90649064906491 Now change the main cell format from "Default" to "#,##0.00" and repeat the copy+paste to Writer, which results in: 446.00 90.90 4.91 So, Calc respects the CF for displaying the cells (independently of the Ctrl+1 format), and the copy+paste to Writer depends on the main format in Ctrl+1. Whether there is a bug (somewhere) or it is all expected behavior, I'll leave it to others. -- You are receiving this mail because: You are the assignee for the bug.
