No formattings displayed when "Standard" cell is empty

[GoogleCodeExporter]

Take a "Standard" style cell (not Text, nor number kind cell) that is
formatted with a background color and even borders, but with no text
or just containing the number zero (that can be the result of a
formula too), the cell is not displayed at all !!!

The problem disapears as sson as you put any non-zero value in it, or a
text, or you change the cell kind (from "Standard" to "Text" for
instance).

I didn't find any code fix for this and I badly need one ! 

Original issue reported on code.google.com by [email protected] on 8 Jul 2009 at 10:41

[GoogleCodeExporter]

hmmm, I think I found a clue :
in html code rendered by the dump function should appear at least something in a
<td></td> structure, for instance :
<td> </td>

should be enaugh in order to make formattings appear

Original comment by [email protected] on 9 Jul 2009 at 12:18

[GoogleCodeExporter]

Some other possibilities in order to apply a border to empty cells (may be 
easier to
implement) :
1) The CSS way :
we can use just add this to excel.css
_______________________________
table { empty-cells:show; }
_______________________________
in a style sheet, to suggest that all empty cells be displayed as normal cells.


2) In the generation of Html code line 586, we can add the frame and box 
properties
to the <Table> tag, so, instead of :
_______________________________________________________________________
586:            $out = "<table class=\"$table_class\" cellspacing=0>";
_______________________________________________________________________

We should have this line :
_______________________________________________________________________
586:            $out = "<table class=\"$table_class\" cellspacing=0 frame=box
rules=all>";
_______________________________________________________________________

Original comment by [email protected] on 30 Oct 2009 at 8:56

[GoogleCodeExporter]

Hi, i have the problem that none of your code works for me.
I tried them all.

Still the cells which are not filled in excel sheet, are simply not displayed.
Can you help Wilfrid ?

Original comment by [email protected] on 21 Jan 2011 at 9:37