Error exporting data to MS Access about largexlsx HOT 5 CLOSED

Hi @artembrizinskij , @RFlipper ,
I have just released release 1.9.0 which allows to include row and cell references even when redundant.
Please feel free to check whether that solves your issue.
Thanks,
Salvo

from largexlsx.

I decided to look into it deeper, and it seems to have already been fixed in this commit ade2fed
As I found out, the row number attribute was required for the export to work

from largexlsx.

This is likely my fault: #21

According to the specification:

<xsd:complexType name="CT_Row">
 <xsd:sequence>
 <xsd:element name="c" type="CT_Cell" minOccurs="0" maxOccurs="unbounded"/>
 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
 </xsd:sequence>
 <xsd:attribute name="r" type="xsd:unsignedInt" use="optional"/>

Note the "r" attribute is marked as optional, so I would argue this is a bug in MS Access.

However, I think #31 added an option to force these attributes to be written, because it seems like a lot of readers don't correctly handle this scenario. So, you should be able to produce compliant files already with slight modification to your code.

from largexlsx.

Hi @artembrizinskij , @RFlipper ,
I'm closing this issue. Should the problem persist, please reopen it.
Thanks,
Salvo

from largexlsx.

@salvois I would appreciate if you find some time to create a new new release with the fix.

from largexlsx.