Skip to content

Excel fgcolor theme swapped. #389

@foreverpw

Description

@foreverpw

If I select the fgcolor theme 'lt1' in Excel, the style is like <fgColor theme="0" />.
But in clrScheme:

<a:clrScheme name="Office">
  <a:dk1><a:sysClr val="windowText" lastClr="000000"/></a:dk1>
  <a:lt1><a:sysClr val="window" lastClr="FFFFFF"/></a:lt1>
  <a:dk2><a:srgbClr val="1F497D"/></a:dk2>
  <a:lt2><a:srgbClr val="EEECE1"/></a:lt2>
  <a:accent1><a:srgbClr val="4F81BD"/></a:accent1>
  <a:accent2><a:srgbClr val="C0504D"/></a:accent2>
  <a:accent3><a:srgbClr val="9BBB59"/></a:accent3>
  <a:accent4><a:srgbClr val="8064A2"/></a:accent4>
  <a:accent5><a:srgbClr val="4BACC6"/></a:accent5>
  <a:accent6><a:srgbClr val="F79646"/></a:accent6>
  <a:hlink><a:srgbClr val="0000FF"/></a:hlink>
  <a:folHlink><a:srgbClr val="800080"/></a:folHlink>
</a:clrScheme>

so theme 0 represents 'dk1', the same for dk2 and lt2;

Do I need to hardcode in my code to get the right fgcolor color?

References:
http://stackoverflow.com/questions/2760976/theme-confusion-in-spreadsheetml
http://openxmldeveloper.org/discussions/formats/f/14/p/557/1700.aspx

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions