Why is this patternType showing as solid instead of none?

Kyle Rosenberg 171 Reputation points

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

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

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

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?

Office Open Specifications
Office Open Specifications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
126 questions
{count} vote

Accepted answer
  1. Mike Bowen 1,436 Reputation points Microsoft Employee

    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.


    Michael Bowen
    Escalation Engineer - Microsoft Open Specifications

0 additional answers

Sort by: Most helpful