xlsx-import does not work

[Michail]

A. Do the following:

1. Create a new document.
2. Place the file SLR-Tabelle.xlsx (Ctrl+Shift+M).

Result: The keyboard no longer works. I have to restart APub. It happened with two different keyboards.

 

B. Do the following:

1. Create a new document.
2. Place the file  Table.xlsx
   (I have just created this table in Excel.)

Result: The same error message appears twice. If I close both windows, I can place the file normally.

[Jon P]

Thanks for passing this on, I'm looking into a bit further and have logged it.

[Jon P]

If you remove the additional spreadsheets in this file that are blank it will resolve the issue, there's a bug with importing a multi sheet xlsx file if one of the sheets is blank. I've logged this

[Michail]

3 minutes ago, Jon P said:

If you remove the additional spreadsheets in this file that are blank it will resolve the issue, there's a bug with importing a multi sheet xlsx file if one of the sheets is blank. I've logged this

Thanks a lot, Jon.
Were you able to reproduce problem "A"? This is even more serious, because I can't import an older table anymore.
I resaved the tables with Excel, which did not solve the problem.

[Jon P]

It's actually the same type of issue, if you remove the additional spreadsheets in that file it will also fix it. The error message gets instantly hidden and prevents keyboard entry (not 100% sure why we sometimes can close the error and sometimes it gets hidden and causes this issue, that's being looked into)

If you delete sheet 2 and 3 which are empty in the first file it will fix it, I've done so and attached my result, this is fine for me

SLR-Tabelle.xlsx

[Michail]

10 minutes ago, Jon P said:

It's actually the same type of issue, if you remove the additional spreadsheets in that file it will also fix it.

Yeah, that works. I am pleased that the problem is so easy to avoid, and hope that it can be solved soon 🙂.

[nodeus]

xlsx files with joined cells are also imported with an error.

[Jon P]

@nodeus can you attach an example? I've just imported a file with merged cells fine.

[nodeus]

17 minutes ago, Jon P said:

@nodeus can you attach an example? I've just imported a file with merged cells fine.

Here it is. The original text from the table has been replaced for confidentiality reasons, but the structure of the table has been retained.

joined cells.xlsx

[Jon P]

That file has blank sheets in like the above files, if I delete those it imports correctly so it's the same issue, I've attached a version with those sheets removed

joined cells.xlsx

[bobr666]

8 hours ago, nodeus said:

xlsx files with joined cells are also imported with an error.

Also seeing this problem with merged cells although there is only one sheet.

 

 

Top_Scorers.xlsx

[nodeus]

1 hour ago, Jon P said:

That file has blank sheets in like the above files, if I delete those it imports correctly so it's the same issue, I've attached a version with those sheets removed

joined cells.xlsx 12.72 kB · 0 downloads

Yes, it's imported and I've already tried it, but table not imported right! 

Simply compare the table in Excel with the table that is being imported. All cells are mixed and out of place.

[Jon P]

Ah ok my bad, I thoiught you were referring to the error message on import - I've passed those files on to the developers, thanks for letting us know