Stream: committers
Topic: Error in Compartments.xml?
Jean Duteau (Aug 08 2019 at 18:11):
I need to add a new resource to the various compartments, but when I try to open compartments.xml in Excel, I get an error:
XML ERROR in Worksheet Setting
REASON: Bad Value
GROUP: Worksheet
TAG: Table
ATTRIB: ExpandedRowCount
VALUE: 146
I've tried in two different Excel programs. Can anyone else verify?
John Moehrke (Aug 08 2019 at 18:14):
yup, it is messed up. Still a valid xml, so just edit using an xml editor
Jean Duteau (Aug 08 2019 at 18:15):
okay thx, just wanted to make sure that it wasn't just me. :)
John Moehrke (Aug 08 2019 at 18:19):
I have two branches... my compartments.xml from 6/19 is okay so the damage was done sometime since then
Jean Duteau (Aug 08 2019 at 18:24):
okay, fixed it. Someone added a row probably in XML mode and didn't update the worksheet row count setting.
John Moehrke (Aug 08 2019 at 18:27):
wow.. love that excel tool... hope that something better comes along
Jean Duteau (Aug 08 2019 at 18:28):
yeah, why would you have an attribute telling you the number of rows when you can just count the rows. especially if you are going to throw an "i give up I can't do anything" error if the attribute doesn't match the actual number of rows?!?
Last updated: Apr 12 2022 at 19:14 UTC
