[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

sheet name error in the LibreOffice Calc.



There might be a bug in the libreOffice Calc sheet name order, version: 5.2.7.2, build ID: 1:5.2.7-1+deb9u4

I open the calc, the default sheet name is Sheet1, now open a new sheet, the name is Sheet2, just before the Sheet1. The Sheet2 is in front of Sheet1.
Now type a in A1, b in A2, in the Sheet1.
Type 1 in A1, 2 in A2, in the the Sheet2.
All these data save as Miscrosoft Excel 2007-2013 XML type.

In the libreoffice calc, the data and the tables are just right.

But in the API programming, the first sheet name is nil, and the second sheet name is Sheet2. The right order name should be, the first sheet name is Sheet2, the second is Sheet1.

Here is my elixir with the help of https://github.com/hongseokyoon/xlsxir, a Xlsx parser for the Elixir language.
```
iex -S mix
iex(1)> [{_, t1}, {_, t2}] = Xlsxir.multi_extract("/home/getong/a.xlsx")
iex(2)> Xlsxir.get_info(t1)
[rows: 2, cols: 1, cells: 2, name: nil]
iex(3)> Xlsxir.get_info(t2)
[rows: 2, cols: 1, cells: 2, name: "Sheet2"]
```

My friend test it with the php parser, use the library https://github.com/nuovo/spreadsheet-reader , the same error.

Reply to: