none
Applying AutoFilter to a worksheet RRS feed

  • Question

  • Hi

    I'm generating a very simple Excel sheet with a few columns, texts and numbers. I want the first row, the header to have an AutoFilter. So I added an AutoFilter object with the correct reference ex. A1:E1, but when I open the file it tells me that its damaged. Is there somthing else that needs to be set before I can add autofilter?

    Also when opening the file without adding the auto filter and adding it through Excel 2010, it changes a lot of the cell types etc.

    How you can help me :)

    --
    Christian

    Wednesday, June 23, 2010 6:54 AM

Answers

  • Hi Christian,

    Thanks for your question.

    I suggest you using the Productivity Tool's "Compare Files" to see how to apply AutoFilter to a worksheet. It seems that you need to add elements or properties in the following three aspects:

     <sheetPr filterMode="1"/>

      <row hidden="1" r="2" spans="1:1" x14ac:dyDescent="0.25">

     <autoFilter ref="A1:A4">
      <filterColumn colId="0">
       <filters>
        <filter val="2"/>
        <filter val="3"/>
       </filters>
      </filterColumn>
     </autoFilter>

    Also you could use the Tool's "Validate" function to see what's wrong with your current file.

    Hope this helps.

    Thanks,

    Lu

    Tuesday, June 29, 2010 9:23 AM