Odd cell.s value

[CMiller3]

Version

0.13.0

Description of the bug

When querying a cell's "s" value, cell.s, defined in the documentation as

  // FIXME: Attribute "s" in a cell is an index into the styles table,
  // while the cell type "s" corresponds to the shared string table.
  // Can XMLCoder distinguish between an attribute and an
  // element having the same name?

Then querying the styles table as:

let styles = file.parseStyles() 
styles.cellStyles[Int(cell.s)]

//or 

styles.cellStyles?.items.first(where: {$0.builtinId == Int(cell.s ?? "") || $0.formatId == Int(cell.s ?? "")})

offers index out of range or nil in each respectively.

Expected behavior

I expected the cellsStyle table with index of cell.s to be the style sought.

[MaxDesiatov]

Thanks for creating this @CMiller3, would you kindly fill in the fields as specified in the description of the issue? Unfortunately, I won't be able to investigate it without this information.

[MaxDesiatov]

Thanks for updating the description, let me have a look...

[CMiller3]

I could also be completely wrong -- just thought that was how the library worked. Thank you!

[CMiller3]

Thank you for the attention -- it turns out the fields I was looking for were not in cellStyles but in cellFormats

styles.cellFormats?.items[Int(cell.s ?? "") ?? 100]

offered the clues of where to head next. I will say, intuitively I expected Formats to be more number format, not cell 'stylings' with colors and fonts.

[MaxDesiatov]

I agree with you, this is not a great name, but this is how the Microsoft folks have chosen to name it, unfortunately.

BTW, I've opened #135 to simplify lookups in formats and fonts, which will be included in the next release.