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

--- Comment #8 from ady <[email protected]> ---
(In reply to m_a_riosv from comment #7)

> Modifying 'Sheet1' to 'Sheet10' on Excell, opens fine with Calc.
> 
> Perhaps when referring to the sheet, a formula within the sheet itself is
> causing the problem when importing it.

But that by itself does not make the address incorrect, just less common.

I doubt that the problem is a sheet referenced in some cell, because sheet2 is
also in a reference and there is no problem.

No, I think that the cells C3 and C4 containing Err:504 are just a symptom, a
mere consequence of the problem: incorrectly importing the label of the
worksheet.

I already detailed what is incorrectly parsed when importing this xlsx 2007
file in comment 4. What I do not know is what specifically triggered the
incorrect mangling. It would need someone to compare the xml code of the
original xlsx file against another xlsx file (derived from the first one,
preferably saved by the same version of Excel as the original file), with the
new file containing a similar worksheet name (say, "sheet5", lowercase, no
space characters and no special symbols).

Something is special (in terms of Calc) in the way the original worksheet label
was named, that triggered the incorrect import in Calc.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to