Correct Colours In .xls export

PflaumeGrau,

The difference can probably be explained by how you are checking the color. Do not use the Color Picker (magnifying glass icon). Doing this will result in your picking up the screen color, with perhaps some correction applied, and not the assigned color. To check the cell's assigned Fill color, Select the cell and click on the color patch in the Cell Background section of the Table Inspector, then read the RGB slider positions in the Colors Pane. I'm no expert in colors, but I know enough to warn you about this apparent shift when picking them from the screen.

Jerry

For many years, I have never been able to convert an MS Office document (any app in the suite) and have the colors translate exactly the same in the corresponding Apple program, nor vice versa. It is especially annoying with presentations.

The only explanation I've ever gotten is that MS Office programs do not use fully standard color palettes, but I've never delved into it much. Its nothing new to me though, and if you are trying to save cross platform and keep colors just so, you will end up with little to no hair left, and files that still look different in the end.

At least with older versions of Excel, I believe they actually did not use RGB per se, but rounded the values to the closest thing in their 56 color palette. So even though it said RGB, it actually was not. I thought that had changed at least, since Office 2007 or older.

Honestly I have never found a solution. With presentations, I know if I make one in Keynote, but the forum specifies they will be use Powepoint, I make it a point to check my slides in Powerpoint on a Windows machine. Even in the past, going from MS Office for Mac to MS Office for Windows did not maintain colors (although they would usually be close and not so much it rendered things unreadable). I never did get a real answer to why their own product on different platforms was not consistent in color - even HEX colors would be off

Hopefully some people on the MS side will have a better answer for you - I just got frustrated pursuing it years ago and just gave up looking for an explanation or fix. I suppose it is possible that excel still has some internal library fixed limit on colors (hopefully more then 56 by now) and is in fact, matching your values "as close to" its internal limts as possible. I also seem to recall that at one time, the RGB function in excel actually returned values in the order BGR - don't know if that still applies either.