wordpress hit counter
indexedcolors length ? - SpreadsheetML - Formats - OpenXML Developer

indexedcolors length ?

Formats

Discussions about working with different Open XML Formats

indexedcolors length ?

  • rated by 0 users
  • This post has 1 Reply |
  • 1 Follower
  • Hi,

    In my current development, i create an <indexedcolors> table in styles.xml to replace the default one.  Everything is going well if the number of entries (colors defined) in this table is lower than the number of entries in the default indexedcolors table.  However, when the length of my table exceeds this number, strange things happen when opening the xlsx file in Excel, as if my table is ignored and the default one restored and used repeatedly.  I have seen examples however stating <color indexed="81">... Also, the OOXML Language Reference states that the number of entries in the <indexedcolors> table is unbounded...

    Here is part of my styles.xml...

    - <x:fills count="34">
    - <x:fill>
      <x:patternFill patternType="none" />
      </x:fill>
    - <x:fill>
      <x:patternFill patternType="gray125" />
      </x:fill>
    - <x:fill>
    - <x:patternFill patternType="solid">
      <x:fgColor indexed="40" />
      <x:bgColor indexed="0" />
      </x:patternFill>
      </x:fill>
    - <x:fill>
    - <x:fill>
    - <x:patternFill patternType="solid">
      <x:fgColor indexed="71" />
      <x:bgColor indexed="0" />
      </x:patternFill>
      </x:fill>
      </x:fills>
    - <x:colors>
    - <x:indexedColors>
      <x:rgbColor rgb="00000000" />
      <x:rgbColor rgb="00FFFFFF" />
      <x:rgbColor rgb="00FF0000" />
    ....
      <x:rgbColor rgb="00FFFFF0" />
      </x:indexedColors>
      </x:colors>

    What I am doing wrong ?

    Thanks in advance for helping me out.

    Mark

  • Hi there

    Could you upload the document so we can analyze details of the issue.

    Regards,
Page 1 of 1 (2 items)