https://bz.apache.org/bugzilla/show_bug.cgi?id=69544

--- Comment #2 from Matt <mat...@canva.com> ---
Additional notes:
According to the OOXML spec, section 21.2.2.115 (and the associated schema,
below) indicates the category datasource should have exactly 1 formula (f)
element, and an optional cache.

This means the XML exported from Google Sheets is technically within spec, but
isn't handled by POI.

Schema excerpt:
```
<xsd:complexType name="CT_MultiLvlStrRef">
  <xsd:sequence>
    <xsd:element name="f" type="xsd:string" minOccurs="1" maxOccurs="1"/>
    <xsd:element name="multiLvlStrCache" type="CT_MultiLvlStrData"
minOccurs="0" maxOccurs="1"/>
    <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0"
maxOccurs="1"/>
  </xsd:sequence>
</xsd:complexType>
```

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to