FAQ

Veelgestelde vragen voor zelfhulp.

Bekijk snel de veelgestelde vragen (en antwoorden) in de standaardlijst. Als u niet kunt vinden wat u zoekt, begin dan met het selecteren van uw Ability Office -versie en verfijn deze dan door zoektekst en/of categorie in te voeren.

Zoeken naar

Selecteer categorie

Selecteer softwareversie

Kennisbank artikel 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:

In Excel, choose a flat color, or better mix of colours (100% white over black makes no sense, 25% black on white background would import better than 75% black on white background).

In Ability, select Format/Cells/Color and set the affected cells to white (or whatever color suits).