numere-org / NumeRe

Framework for numerical computations, data analysis and visualisation
https://www.numere.org
GNU General Public License v3.0
20 stars 7 forks source link

Loading of XLSX files with more than one headline does not work correctly #86

Closed numeredev closed 1 year ago

numeredev commented 1 year ago

DESCRIPTION

Describe the bug Loading an XLSX file, which contains more than one headline converts everything to string columns. Might need a fix like in #45, where we used some kind of a heuristic.

To Reproduce Steps to reproduce the behavior:

  1. Load the file xlsx-8_shortVersion.xlsx
  2. Open the loaded file in the table viewer
  3. See error

Expected behavior The first two rows should be used as table headlines instead of leaking into the table columns.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

Additional context Add any other context about the problem here.

(Do not write below this line)


DEVS' SECTION

ANALYSIS

The issue is in fact identical to the one solved within #45. Futhermore, the same problem occurs with ODS files.

IMPLEMENTATION STEPS

(see also our Wiki for implementation guidelines)

DOCUMENTATION STEPS

(see also our Wiki for further information)

PULL REQUEST