Hello,
I’m trying to make some documents in Calc and to highlight images with shapes, after re-opening the shapes return to a default colour, either black or blue. This is very inconsistent and some shapes stay the same colour that I had made them. I thought this was a basic task, but is is turning out not to be. I’ve tried saving under a different name, compressing all the images and saving multiple times, allowing the save bar to disappear before performing another function, but nothing seems to work.
I guess that you are saving them as .docx which does not support many colours.
Always save in native format, .ods (Open Document Format). If someone else needs a copy in .docx do File > Save a Copy and send that to them, but you continue working in .ods
Hi, I have been saving them as .xlsx files, but I will try your solution.
Thanks
This works, but when it is exported to excel, loses it’s formatting and reverts back to the other colours. Tried saving as and saving a copy.
Sorry, I meant .xlsx. I was wrong about the limited colours in Excel; it works OK for me, see
ColourInExcelFormat.xlsx (12.5 KB)
What OS, Version of LO, etc. Click Help > About LibreOffice. In the dialogue that opens, click the icon just after Version Information (tooltip Copy all version information in English) and paste into question or a comment.
.
Can you upload a small sample in .ods that changes to black or blue when saved as .xlsx?
No worries, I’m using :
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631)
UI render: Skia/Raster
VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
It appears to be the latest version.
Files are in link below.
https://drive.google.com/drive/folders/1ky5DJFHtmO4jHk4r5-sezdkMq0-Ex0F_?usp=sharing
I suspect that your document and shapes style have been damaged by constant conversion to and from .xlsx every time it is opened and then when it is saved. There are a huge number of of different Normal cell styles. It might be best to start with a clean document and rebuild, always saving as .ods.
.
Open the Styles pane and go to Drawing Styles. Right click on Default and select New, give it a name like “Arrow” in the General tab; select the Area tab and click the Colour button and under New in the Hex field enter 1cf802 (lime green); select the Line tab and in the Colour field, select the lime green colour from the recently used colours. OK.
.
Select each arrow in turn and double-click the “Arrow” style to apply it
.
Repeat the entire process for the hollow shapes, circles and squares, maybe call them “Surrounds”, I believe the colour is the same
Your blue heading row changes to mustard in Excel. Save a Copy as .xlsx seems to work best if you use Cell styles (and Shape styles)
This is more the sort of small sample I meant
_180_DAY_SOPNewdocument.ods (17.0 KB)