Copy spreadsheet table to writer with conditional formatting

I have a nice table with conditional coloured numbers but when I copy it to writer, this kind of formating just does not copy. No matter if I copy as a table or just a GDI or even BMP - pure bitmap image. I´m loosing the conditional formating. Any clue how to solve it?

image

2023-03-10 12 31 34

1 Like

this does insert the table, but without the conditional formatting, ie no colour numbers are maintained.

this is the result

It works in my spreadsheet.

example.odt (35,8 KB)

Version: 7.3.7.2 (x64) / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded


Version: 7.4.5.1 (x86) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: en-CA (de_DE); UI: en-US
Calc: threaded

1 Like

@Stasio
Be aware that this is an OLE object. You may work on it in Writer in a Calc environment. @PKG 's example works for me quite well. You can transfer the OLE contents back to another Calc table and check again… It is okay.
.
For better checking your problems upload a sample document.