title: How to copy conditionally formatted cells from Calc as a table into Writer
body: <p>I have a LibreOffice Calc spreadsheet that uses some conditional formatting of cells. I would like to copy it into Writer as a table. The colours/formats of the cells should remain as they were due to the conditional formatting in Calc. Unfortunately when I do that, the formatting vanishes.</p>
  
  <p>How can I copy it keeping the formatting?</p>
  
  <p>Of course the Writer version no longer has to be conditional, but I need to keep current colours.</p>
  
  <p>My work is done so eventually I can do the trick in Calc first (abandon the "conditional" part, and just preserve the formatting as - is). However due to amount of data I would prefer not to do it manually.</p>
  
  <p>Is macro the only way to do that?</p>