#785 Putting no text before a tag causes the target Microsoft Excel file not to open

[Roman Mironov]

Putting no text before a tag causes the target Microsoft Excel file not to open. Adding any text before this tag fixes the issue.

Download the project here: https://yadi.sk/d/1jkdzmFimConb

[Didier Briel]

The target file is valid XML. The issue comes from Excel not liking to have a run without any text in it. Removing completly <r><rPr><sz val="11"/><color indexed="8"/><rFont val="Calibri"/><family val="2"/></rPr><t xml:space="preserve"></t></r> solves the issue.

As a workaround, you could use a zero width space (​) at the beginning of the segment

Here, Excel 2010 offers to repair the file. After that, it opens fine.

Didier

[Roman Mironov]

Thank you for looking into this, Didier. Excel 2013 offers to repair the fie, too. However, after repairing and opening, this very line loses the red color of the [b] tags.

[Didier Briel]

It's the same with Excel 2010, the color is lost.

Didier

[Hiroshi Miura]

Does this still happen in OmegaT 6.0/6.1? Recent version has new filter for MS office files.

We may lost the reproducible project file. I could not test.

[Jean-Christophe Helary]

But the new filters are not useable because of bugs we found recently.