https://bugs.documentfoundation.org/show_bug.cgi?id=100458

--- Comment #3 from Jan-Marek Glogowski <glo...@fbihome.de> ---
61c39eae570d6d6040b65bfe93127b30e6080cc8 Display blank cell instead of zero in
matrix cells with blank text result

actually breaks the import.

Couldn't really prove it, as I wasn't able to build 4.0 to do a bisecting, but
reading the commit message makes it quite clear.

And since in the content.xml diff "calcext:value-type" is set to "float" for
current saved document from Calc on master and the current code runs into 

void ScXMLTableRowCellContext::EndElement()
{
    HasSpecialCaseFormulaText();
    if( ... )
    {
        CellType = util::NumberFormat::TEXT;

in debugrun for the original document, breaking the import.

Commenting the "CellType = util::NumberFormat::TEXT;" line fixes the import,
but is definitly wrong. I still try to understand, what the code is expected to
do.

There is this comment, which I think is exactly my use case

// If a matrix formula has a matrix reference cell that is intended to have
// a blank text result, the matrix reference cell is actually saved(export)
// as a float cell with 0 as the value and empty <text:p/>.
// Import works around this by setting these cells as text cells so that
// the blank text is used for display instead of the number 0.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to