logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Benbabu  
#1 Posted : Wednesday, September 11, 2019 5:13:54 AM(UTC)
Benbabu

Rank: Advanced Member

Groups: Registered
Joined: 8/9/2019(UTC)
Posts: 33
India

Thanks: 10 times
Hi,

We are using the Evaluation version of the Excel/ PDF converter for now.

However Excel does not show custom colors, HTML text or images defined in the reports.

Is it a limitation of the Evaluation version ?

Edited by user Wednesday, September 11, 2019 5:21:23 AM(UTC)  | Reason: Not specified

epf  
#2 Posted : Wednesday, September 11, 2019 6:55:07 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 733
Switzerland

Thanks: 14 times
Was thanked: 135 time(s) in 131 post(s)
The Excel conversion implementation offers the tables, the charts (with conversion to excel chart when possible).
All other options like colors, fonts, tec. have to be configured manually in the scripts...

Please check https://sealreport.org/Reports#lineConverter_2 and play with the EPPlus library.
Benbabu  
#3 Posted : Tuesday, September 17, 2019 4:10:43 AM(UTC)
Benbabu

Rank: Advanced Member

Groups: Registered
Joined: 8/9/2019(UTC)
Posts: 33
India

Thanks: 10 times
But I suppose, Advanced cell script (conditional formatting) cannot be included in the Excel conversion template for the model.
Its showing the errors -
"ReportCell not found"
"cell not recognized in current context"

Is there an alternate for this ?
epf  
#4 Posted : Tuesday, September 17, 2019 5:53:44 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 733
Switzerland

Thanks: 14 times
Was thanked: 135 time(s) in 131 post(s)
You can use ResultCell and all the objects of Seal Report: make sure that you included:
@using Seal.Model

so you may have in the Data Table script:
Seal.Model.ResultCell rc = page.DataTable[row, col];

Then change your cell formatting based on the cell values...
check: https://github.com/JanKa...i/Formatting-and-styling

Edited by user Tuesday, September 17, 2019 5:54:38 AM(UTC)  | Reason: Not specified

thanks 1 user thanked epf for this useful post.
Benbabu on 10/21/2019(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.