Reset Backcolor when exporting to excel

Posted by: eager2knw on 8 September 2017, 1:33 pm EST

  • Posted 8 September 2017, 1:33 pm EST

    Hi,


    I'm exporting a cloned fpspread to an excel.


    The  original spread has its different colors set at either the column level or row level.


    Now when I export (the cloned spread)  to excel .


     It shows the colors  for the entire excel rows and entire column.


    Im somehow luking forward to to retaining the colors for the ( desired) rows and columns and


    resetting the colors for the entire remaining rows for the cloned spread.


    Rowcount of spread is 23;


    Column count of spread is 20;


    Thanks,


    Eager2knw


     

  • Replied 8 September 2017, 1:33 pm EST

    Eager2knw,


    There is not a way to do this. The Column and Row object will be the entire column or row. You would need to set the column for each cell if you did not want Excel to show the color for the extra rows and columns.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels