Frequently asked questions for self help.

Knowledge base article 86

Black cells appears black after import from Excel

Excel allows two colors to be mixed together to form a pattern fill for a cell. Ability only supports a single flat color - so we chose to import the color from Excel that is set as background, which is usually fine.

However, if the Excel user mixes 75% white onto a black background (a sort of grey in Excel) Ability only imports the background, e.g. 100% black. Note that some versions of Excel allow a black background with a 100% white over the top - resulting in a white cell (crazy but true). If this apparantly normal cell is imported, you'll get a surprise.

The solution is either: