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 wilfrid....@gmail.com 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 wilfrid....@gmail.com 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 wilfrid....@gmail.com 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 sba...@gmail.com on 21 Jan 2011 at 9:37