We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Custom conditional formatting that shows when opening the file on a different computer?

asked 2021-05-01 01:10:09 +0200

lindzwc gravatar image

updated 2021-05-17 13:38:05 +0200

Alex Kemp gravatar image

I've made a spreadsheet with multiple sections, each with a different color of alternating rows. So one section has alternating rows of yellow and white, another has alternating rows of blue and white, etc, using custom styles of conditional formatting.

But when I send the spreadsheet to another person, none of those colors show up. Is there a way to lock it to document? Or are there default styles that will accomplish the same effect and look the same on different computers?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2021-05-01 09:59:31 +0200

Please have a look at the Getting started guide. Your question lack key details like the OS (yours and the recipient's) and most important, the file format and if the recipient also uses LO.

If there is MS Excel at the other end or if the file format is .xls(x), then you may have such compatibility problems indeed. The .xls(x) format was not designed to be compatible with anything else than MS Office. Thus, the solution would be to save in native ODF (.ods). Else, stick to MS Office.

You can also upload a sample file (see How do I attach a file?) so that we can have a look.

To show the community your question has been answered, please tag the best answer (), and/or vote for any helpful answer. Else, please edit your question to add information (answers are for solutions only).

Will change this answer to a comment if further discussion is needed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-05-01 01:10:09 +0200

Seen: 32 times

Last updated: May 01