search

tfussell / xlnt

:bar_chart: Cross-platform user-friendly xlsx library for C++11+
Other
1.43k stars 402 forks source link

Unexpected attribute 'ca' when working with formular in xlsx file. #716

Open sean1832 opened 9 months ago

sean1832 commented 9 months ago

Hi, I got error "Unexpected attribute 'ca'" when trying to load the excel file. This file can be open with python library. Following is the .xml file that is failed to load:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2" xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{00000000-0001-0000-0100-000000000000}"><dimension ref="A1:F28"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"><selection activeCell="A28" sqref="A28"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25"/><cols><col min="1" max="1" width="25.5703125" customWidth="1"/><col min="2" max="2" width="13.85546875" customWidth="1"/><col min="3" max="3" width="8.140625" customWidth="1"/><col min="4" max="4" width="16.7109375" customWidth="1"/><col min="5" max="5" width="17" customWidth="1"/><col min="6" max="6" width="14.7109375" customWidth="1"/></cols><sheetData><row r="1" spans="1:6" ht="23.25" customHeight="1" x14ac:dyDescent="0.35"><c r="A1" s="12" t="s"><v>0</v></c><c r="B1" s="13"/><c r="C1" s="13"/><c r="D1" s="13"/><c r="E1" s="13"/><c r="F1" s="13"/></row><row r="3" spans="1:6" ht="15.75" customHeight="1" x14ac:dyDescent="0.25"><c r="A3" s="4" t="s"><v>1</v></c><c r="B3" s="4" t="s"><v>2</v></c></row><row r="4" spans="1:6" x14ac:dyDescent="0.25"><c r="A4" t="s"><v>9</v></c><c r="B4" t="s"><v>28</v></c></row><row r="5" spans="1:6" x14ac:dyDescent="0.25"><c r="A5" t="s"><v>3</v></c><c r="B5" s="7" t="s"><v>4</v></c></row><row r="6" spans="1:6" x14ac:dyDescent="0.25"><c r="A6" t="s"><v>5</v></c><c r="B6" s="1" t="s"><v>6</v></c></row><row r="7" spans="1:6" x14ac:dyDescent="0.25"><c r="A7" t="s"><v>7</v></c><c r="B7" s="2" t="s"><v>8</v></c></row><row r="10" spans="1:6" ht="15.75" x14ac:dyDescent="0.25"><c r="A10" s="4" t="s"><v>38</v></c><c r="B10" s="4" t="s"><v>29</v></c></row><row r="11" spans="1:6" x14ac:dyDescent="0.25"><c r="A11" t="s"><v>9</v></c><c r="B11" t="s"><v>30</v></c></row><row r="12" spans="1:6" x14ac:dyDescent="0.25"><c r="A12" t="s"><v>10</v></c><c r="B12" s="5" t="s"><v>31</v></c></row><row r="14" spans="1:6" x14ac:dyDescent="0.25"><c r="E14" t="s"><v>11</v></c><c r="F14" t="s"><v>12</v></c></row><row r="15" spans="1:6" x14ac:dyDescent="0.25"><c r="E15" s="8"><f ca="1">Table25[[#This Row],[Invoice Date]]</f><v>45197</v></c><c r="F15" s="9"><f ca="1">TODAY()</f><v>45197</v></c></row><row r="17" spans="1:6" x14ac:dyDescent="0.25"><c r="A17" t="s"><v>13</v></c><c r="B17" t="s"><v>14</v></c><c r="C17" t="s"><v>15</v></c><c r="D17" t="s"><v>16</v></c><c r="E17" t="s"><v>32</v></c><c r="F17" t="s"><v>33</v></c></row><row r="18" spans="1:6" x14ac:dyDescent="0.25"><c r="A18" s="10" t="s"><v>34</v></c><c r="B18" s="6" t="s"><v>35</v></c><c r="C18" s="6" t="s"><v>36</v></c><c r="D18" t="s"><v>17</v></c><c r="E18" s="11" t="s"><v>37</v></c><c r="F18" s="6" t="s"><v>18</v></c></row><row r="19" spans="1:6" x14ac:dyDescent="0.25"><c r="A19" s="10"/><c r="B19" s="6"/><c r="C19" s="6"/><c r="E19" s="11"/><c r="F19" s="6"/></row><row r="20" spans="1:6" ht="18.75" customHeight="1" x14ac:dyDescent="0.25"><c r="A20" s="6"/><c r="B20" s="6"/><c r="C20" s="6"/><c r="E20" s="6"/><c r="F20" s="6"/></row><row r="21" spans="1:6" x14ac:dyDescent="0.25"><c r="A21" s="6"/><c r="B21" s="6"/><c r="C21" s="6"/><c r="E21" s="6"/><c r="F21" s="6"/></row><row r="22" spans="1:6" x14ac:dyDescent="0.25"><c r="A22" s="6"/><c r="B22" s="6"/><c r="C22" s="6"/><c r="E22" s="6"/><c r="F22" s="6"/></row><row r="23" spans="1:6" ht="18.75" customHeight="1" x14ac:dyDescent="0.3"><c r="A23" s="3" t="s"><v>19</v></c><c r="B23" s="6"/><c r="C23" s="6"/><c r="E23" s="3"><f>E18+E19+E20+E21+E22</f><v>160</v></c></row><row r="26" spans="1:6" ht="18.75" x14ac:dyDescent="0.3"><c r="A26" s="3" t="s"><v>20</v></c></row><row r="27" spans="1:6" x14ac:dyDescent="0.25"><c r="A27" t="s"><v>21</v></c><c r="B27" t="s"><v>22</v></c><c r="C27" t="s"><v>23</v></c><c r="D27" t="s"><v>24</v></c></row><row r="28" spans="1:6" x14ac:dyDescent="0.25"><c r="A28" t="s"><v>25</v></c><c r="B28" t="s"><v>2</v></c><c r="C28" s="5" t="s"><v>26</v></c><c r="D28" s="5" t="s"><v>27</v></c></row></sheetData><mergeCells count="1"><mergeCell ref="A1:F1"/></mergeCells><hyperlinks><hyperlink ref="B6" r:id="rId1" xr:uid="{00000000-0004-0000-0100-000000000000}"/></hyperlinks><pageMargins left="1.085" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/><pageSetup scale="92" orientation="portrait" horizontalDpi="1200" verticalDpi="1200" r:id="rId2"/><tableParts count="3"><tablePart r:id="rId3"/><tablePart r:id="rId4"/><tablePart r:id="rId5"/></tableParts></worksheet>

I think it has to do with the part:

<f ca="1">Table25[[#This Row],[Invoice Date]]</f>
<f ca="1">TODAY()</f>