Why is this patternType showing as solid instead of none?

Kyle Rosenberg 171

This excel file (https://windwardstudios.box.com/s/t1mh7xlgwlwni3b4j6l8x986ymiqvsf1) has a conditional formatting rule that adds a light red background.

In xl/worksheets/sheet2.xml, I can see that the dxfId of the cfRule is "1"

However, in xl/styles.xml, I see that the patternFill tag is missing the patternType attribute.

I have referenced multiple resources online (including learn.microsoft.com) that all tell me that when missing, the default patternType is "none", which means not to show any fill. So my question is: what part of the xml in this spreadsheet is indicating to excel that it should show the fill as solid instead of none?

Obaid Farooqi MSFT 591 Reputation points Microsoft Employee

2021-09-01T20:34:26.887+00:00

Hi @Kyle Rosenberg
I have alerted the open specifications team regarding your inquiry. A member of the team will be in touch soon.

Regards,
Obaid Farooqi - MSFT
Mike Bowen 1,781 Reputation points Microsoft Employee

2021-09-01T21:58:43.017+00:00

Hi @Kyle Rosenberg ,

Thanks for uploading the file. I will look into what part of the xml is causing the cell to show the fill and let you know what I find. From the rule in your image "Cell Value > 4" it looks like the behavior is correct, but you are looking for the cause, is that right?

Best,

Michael Bowen
Escalation Engineer - Microsoft Open Specifications
Kyle Rosenberg 171 Reputation points

2021-09-02T22:05:16.517+00:00

I think that excel is behaving correctly based on my actions in the UI, but not based on the xml. Since the patternFill tags don't have a patternType attribute I would expect there to be no fill in the cells. I am looking to know why it is still showing a solid fill.

Accepted answer

Mike Bowen 1,781 Reputation points Microsoft Employee

2021-09-03T17:59:16.81+00:00

Hi @Kyle Rosenberg ,

The reason the DXFs are not rendering the way you describe is that DXFs represent incremental formats, so in that context unspecified values are truly unspecified and generally do not adopt defaults unless the schema dictates otherwise. In this case patternType has no schema level default, so when it is omitted a DXF will treat that as being unspecified as opposed to None.

Please let me know if that answers your question.

Best,

Michael Bowen
Escalation Engineer - Microsoft Open Specifications
Please sign in to rate this answer.
Kyle Rosenberg 171 Reputation points

2021-09-03T18:20:20.123+00:00

This answers my question, thanks for your help
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Why is this patternType showing as solid instead of none?

0 additional answers

Your answer