strictdoc icon indicating copy to clipboard operation
strictdoc copied to clipboard

Bug: Excel import generate unexpected .sdoc

Open johanenglund opened this issue 1 year ago • 1 comments

Describe the bug

test.xls

Import of the attached .xls gives the unexpected grammar below. Fields are in different order than columns in .xls, fields are repeated and fields that does not exist in .xls appeared. Maybe there are some required formatting of the .xls that I'm missing?

[GRAMMAR]
ELEMENTS:
- TAG: REQUIREMENT
  FIELDS:
  - TITLE: UID
    TYPE: String
    REQUIRED: False
  - TITLE: LEVEL
    TYPE: String
    REQUIRED: False
  - TITLE: STATUS
    TYPE: String
    REQUIRED: False
  - TITLE: TAGS
    TYPE: String
    REQUIRED: False
  - TITLE: TITLE
    TYPE: String
    REQUIRED: False
  - TITLE: STATEMENT
    TYPE: String
    REQUIRED: False
  - TITLE: RATIONALE
    TYPE: String
    REQUIRED: False
  - TITLE: COMMENT
    TYPE: String
    REQUIRED: False
  - TITLE: SOURCE
    TYPE: String
    REQUIRED: False
  - TITLE: AREA
    TYPE: String
    REQUIRED: False
  - TITLE: STATUS
    TYPE: String
    REQUIRED: False
  - TITLE: REQTYPE
    TYPE: String
    REQUIRED: False
  - TITLE: VERIFICATION
    TYPE: String
    REQUIRED: False
  - TITLE: OWNER
    TYPE: String
    REQUIRED: False
  - TITLE: RATIONALE
    TYPE: String
    REQUIRED: False

Expected behavior

A grammar consisting of the column headers, in the same order.

Environment

  • Ubuntu 24.04
  • Strictdoc 0.3.0

johanenglund avatar Nov 28 '24 07:11 johanenglund

This can be done together with: https://github.com/strictdoc-project/strictdoc/issues/1379.

stanislaw avatar Mar 16 '25 23:03 stanislaw