Failure to process numbers file containing email addresses

[Mark Rogers]

I received a numbers file from a client which, when opened in LibreOffice, truncated at the first email address in the content. So I used numbers2ods to create a .ods files, which LO complained was corrupt. I then used numbers2ods to create a flat ODS file to look at the output generated.

A typical email address was generating the following XML snippet:
<table:table-cell table:style-name="Sheet0_cell2">
   <text:p text:style-name="S0">
      <text:a xlink:href="mailto:<email address hidden>" xlink:type="simple">
          <email address hidden>
    </text:p>
</table:table-cell>

Note that <text:a> is never closed

Given that the LO and numbers2ods seem to break at the same point on the same input I would imagine there is a common cause (is writerperfect used by LO?) and if so the bug is sure to be affecting more people using LO than writerperfect directly, but it's with numbers2ods that I have been able to diagnose the problem hence the report here.

ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: numbers2ods 0.9.6-2build1
ProcVersionSignature: Microsoft 4.4.0-19041.488-Microsoft 4.4.35
Uname: Linux 4.4.0-19041-Microsoft x86_64
ApportVersion: 2.20.11-0ubuntu27.16
Architecture: amd64
CasperMD5CheckResult: skip
Date: Mon May 31 13:04:52 2021
ProcEnviron:
 TERM=xterm-256color
 PATH=(custom, no user)
 LANG=C.UTF-8
 SHELL=/bin/bash
SourcePackage: writerperfect
UpgradeStatus: No upgrade log present (probably fresh install)