Excel table niggles when opened in Google Docs

[andiekit]

Hi all, I work for a company that designs spreadsheets for businesses - risk assessments and suchlike. We design them using Excel in Office 365 on PC.

However, some of our customers use Macs and some use Google Sheets (some even use Google Sheets on Macs!)

Most of the spreadsheets work fine when opened in Google Sheets (on PC and Mac) but we have noticed a few little niggles when using tables. They are:

• The borders around the edge of the table are removed completely.
• We use white bold text in column headers - this is replaced by plain black text.
• And we also highlight some content in cells by filling those cells with yellow. This yellow is removed.

I'm not sure if anything can be done, or if we'll just have to grin and bear it - but any help would be gratefully received.

Thanks!

Andie x

[JLGWhiz]

You have to be careful of those niggles!

Generally, Google Sheets will accept most Excel attributes, but there are some it will not, just as Excel does not accept all attributes or some web content. In those cases, the underlying software of the receiving application will convert the characters and attributes to what it believes to be the closest accomodating standard. Your options are propbably to find out how Google sheets produces the same effects that you want to use and how to incorporate them into your work.