In a xlsx file, I need to create a cell with an empty string. When I do
ws.WriteText(0, 0, '');
ws.WriteNumberFormat(0, 0, nfText);
the result is
<c r="A1" s="1"><v></v></c>
but I need an explicit empty string in sharedStrings.xml and the c element to refer to it.
The original xlsx file I'm rewriting with fpS has it that way, btw.
I need that because the file I generate is later read by a stupid program that interprets empty cells (as fpS writes them) as 0.
So is there a way to make fpS add an empty string in sharedStrings.xml and refer to it in cells I explicitly assigned an empty string to?