Losing Conditional Formatting when Saving to HTML

Aspose.Cells Product Family
1

Hi -

I’ve attached some files to help explain my issue…

Basically, I’m trying to save the attached XLS file as HTML with the following code:

Dim workbook As New Aspose.Cells.Workbook()
workbook.Open(“C:\TestCondFormat.xls”)
workbook.Save(“C:\TestCondFormat_out.htm”, Aspose.Cells.FileFormatType.Html)

The alternate shading on rows 14-16 are setup as Conditional Formatting using the following formula:

=IF($D$4=1,MOD(ROW(),2)=0)

This is displayed correctly when displaying in either XLS or PDF, but not at all when saving as HTML. Any help you could offer would be appreciated. Thanks!


Sean Clauson

2

Hi Clauson,

Thanks for providing us the template files.

We found the issue as you have mentioned after an initial test, we will figure it out soon.

Your issue has been logged into our issue tracking system with an issue id: CELLSNET-14505.

We will inform you when it is sorted out.

Thank you.

3

Hi,<o:p></o:p>

Please try the attached version. We have fixed the "Losing Conditional Formatting when Saving to HTML" issue.

Thank you

4

It works – Thanks!

5

The issues you have found earlier (filed as 14505) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.