You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Open XML SDK reports 45 errors for any Strict conformant .xlsx file. The errors are not with the file itself, but with bug in Open XML SDK. THerefore, any Strict .xlsx with these 45 errors are still valid, regardless of the error reports.
My solution for CLISC will be to write a code which ignores these errors and reports Strict valid unless it posses other errors.
The first two errors are unique, but the rest 43 errors are all related to an invalid int32 value, which involves percentages in a string.
I have reported the errors on Microsofts official Github repository for Open XML SDK, adn they have acknowledged these as bugs and explainted why they happen and what effort it will take for them to repair the code. See issue 1 and issue 2.
List of the 45 errors
--> Error 1
----> Description: The 'dateCompatibility' attribute is not declared.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Spreadsheet.WorkbookProperties
----> Path: /x:workbook[1]/x:workbookPr[1]
----> Part: /xl/workbook.xml
--> Error 2
----> Description: The element has unexpected child element 'http://schemas.openxmlformats.org/spreadsheetml/2006/main:start'. List of possible elements expected: <http://schemas.openxmlformats.org/spreadsheetml/2006/main:left>.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Spreadsheet.Border
----> Path: /x:styleSheet[1]/x:borders[1]/x:border[1]
----> Part: /xl/styles.xml
----> Related Node: DocumentFormat.OpenXml.Spreadsheet.StartBorder
----> Related Node Inner Text:
--> Error 3
----> Description: The attribute 'pos' has invalid value '100%'. The string '100%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[3]
----> Part: /xl/theme/theme1.xml
--> Error 4
----> Description: The attribute 'val' has invalid value '120%'. The string '120%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 5
----> Description: The attribute 'val' has invalid value '63%'. The string '63%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Shade
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:shade[1]
----> Part: /xl/theme/theme1.xml
--> Error 6
----> Description: The attribute 'pos' has invalid value '50%'. The string '50%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]
----> Part: /xl/theme/theme1.xml
--> Error 7
----> Description: The attribute 'val' has invalid value '103%'. The string '103%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 8
----> Description: The attribute 'val' has invalid value '90%'. The string '90%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Shade
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:shade[1]
----> Part: /xl/theme/theme1.xml
--> Error 9
----> Description: The attribute 'val' has invalid value '130%'. The string '130%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 10
----> Description: The attribute 'val' has invalid value '98%'. The string '98%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Tint
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:tint[1]
----> Part: /xl/theme/theme1.xml
--> Error 11
----> Description: The attribute 'pos' has invalid value '0%'. The string '0%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]
----> Part: /xl/theme/theme1.xml
--> Error 12
----> Description: The attribute 'val' has invalid value '102%'. The string '102%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 13
----> Description: The attribute 'val' has invalid value '98%'. The string '98%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Shade
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:shade[1]
----> Part: /xl/theme/theme1.xml
--> Error 14
----> Description: The attribute 'val' has invalid value '150%'. The string '150%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 15
----> Description: The attribute 'val' has invalid value '93%'. The string '93%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Tint
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:tint[1]
----> Part: /xl/theme/theme1.xml
--> Error 16
----> Description: The attribute 'val' has invalid value '170%'. The string '170%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:solidFill[2]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 17
----> Description: The attribute 'val' has invalid value '95%'. The string '95%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Tint
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:bgFillStyleLst[1]/a:solidFill[2]/a:schemeClr[1]/a:tint[1]
----> Part: /xl/theme/theme1.xml
--> Error 18
----> Description: The attribute 'val' has invalid value '63%'. The string '63%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Alpha
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:effectStyleLst[1]/a:effectStyle[3]/a:effectLst[1]/a:outerShdw[1]/a:srgbClr[1]/a:alpha[1]
----> Part: /xl/theme/theme1.xml
--> Error 19
----> Description: The attribute 'lim' has invalid value '800%'. The string '800%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Miter
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:lnStyleLst[1]/a:ln[3]/a:miter[1]
----> Part: /xl/theme/theme1.xml
--> Error 20
----> Description: The attribute 'lim' has invalid value '800%'. The string '800%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Miter
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:lnStyleLst[1]/a:ln[2]/a:miter[1]
----> Part: /xl/theme/theme1.xml
--> Error 21
----> Description: The attribute 'lim' has invalid value '800%'. The string '800%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Miter
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:lnStyleLst[1]/a:ln[1]/a:miter[1]
----> Part: /xl/theme/theme1.xml
--> Error 22
----> Description: The attribute 'pos' has invalid value '100%'. The string '100%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[3]
----> Part: /xl/theme/theme1.xml
--> Error 23
----> Description: The attribute 'val' has invalid value '78%'. The string '78%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Shade
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:shade[1]
----> Part: /xl/theme/theme1.xml
--> Error 24
----> Description: The attribute 'val' has invalid value '120%'. The string '120%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 25
----> Description: The attribute 'val' has invalid value '99%'. The string '99%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 26
----> Description: The attribute 'pos' has invalid value '50%'. The string '50%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[2]
----> Part: /xl/theme/theme1.xml
--> Error 27
----> Description: The attribute 'val' has invalid value '100%'. The string '100%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Shade
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:shade[1]
----> Part: /xl/theme/theme1.xml
--> Error 28
----> Description: The attribute 'val' has invalid value '100%'. The string '100%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 29
----> Description: The attribute 'val' has invalid value '110%'. The string '110%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 30
----> Description: The attribute 'pos' has invalid value '0%'. The string '0%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[1]
----> Part: /xl/theme/theme1.xml
--> Error 31
----> Description: The attribute 'val' has invalid value '94%'. The string '94%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Tint
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:tint[1]
----> Part: /xl/theme/theme1.xml
--> Error 32
----> Description: The attribute 'val' has invalid value '102%'. The string '102%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 33
----> Description: The attribute 'val' has invalid value '103%'. The string '103%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[2]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 34
----> Description: The attribute 'pos' has invalid value '100%'. The string '100%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[3]
----> Part: /xl/theme/theme1.xml
--> Error 35
----> Description: The attribute 'val' has invalid value '81%'. The string '81%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Tint
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:tint[1]
----> Part: /xl/theme/theme1.xml
--> Error 36
----> Description: The attribute 'val' has invalid value '109%'. The string '109%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 37
----> Description: The attribute 'val' has invalid value '105%'. The string '105%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[3]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 38
----> Description: The attribute 'pos' has invalid value '50%'. The string '50%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]
----> Part: /xl/theme/theme1.xml
--> Error 39
----> Description: The attribute 'val' has invalid value '73%'. The string '73%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Tint
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:tint[1]
----> Part: /xl/theme/theme1.xml
--> Error 40
----> Description: The attribute 'val' has invalid value '103%'. The string '103%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 41
----> Description: The attribute 'val' has invalid value '105%'. The string '105%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[2]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 42
----> Description: The attribute 'pos' has invalid value '0%'. The string '0%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.GradientStop
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]
----> Part: /xl/theme/theme1.xml
--> Error 43
----> Description: The attribute 'val' has invalid value '67%'. The string '67%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.Tint
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:tint[1]
----> Part: /xl/theme/theme1.xml
--> Error 44
----> Description: The attribute 'val' has invalid value '105%'. The string '105%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.SaturationModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:satMod[1]
----> Part: /xl/theme/theme1.xml
--> Error 45
----> Description: The attribute 'val' has invalid value '110%'. The string '110%' is not a valid 'Int32' value.
----> ErrorType: Schema
----> Node: DocumentFormat.OpenXml.Drawing.LuminanceModulation
----> Path: /a:theme[1]/a:themeElements[1]/a:fmtScheme[1]/a:fillStyleLst[1]/a:gradFill[1]/a:gsLst[1]/a:gs[1]/a:schemeClr[1]/a:lumMod[1]
----> Part: /xl/theme/theme1.xml
The text was updated successfully, but these errors were encountered:
Open XML SDK reports 45 errors for any Strict conformant .xlsx file. The errors are not with the file itself, but with bug in Open XML SDK. THerefore, any Strict .xlsx with these 45 errors are still valid, regardless of the error reports.
My solution for CLISC will be to write a code which ignores these errors and reports Strict valid unless it posses other errors.
The first two errors are unique, but the rest 43 errors are all related to an invalid int32 value, which involves percentages in a string.
I have reported the errors on Microsofts official Github repository for Open XML SDK, adn they have acknowledged these as bugs and explainted why they happen and what effort it will take for them to repair the code. See issue 1 and issue 2.
List of the 45 errors
The text was updated successfully, but these errors were encountered: