Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Export into Excel

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Anti-Spam Code:

* HTML is ON
* Forum Code is OFF
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

Check here to subscribe to this topic.

T O P I C    R E V I E W
Sailesh Posted - 04/17/2019 : 01:12:25
Hi ,
I have a report which has cells highlighted in color. When i export the report in excel format the highlight color does not appear in the excel file. I have a test report called 'Test color Export in Excel' which you can use for this testing.

Scott Bader
10   L A T E S T    R E P L I E S    (Newest First)
Sailesh Posted - 11/19/2020 : 09:09:15
Thank you for your reply.
The conditional format is required for OLAP report.
Ideally I prefer conditional format for the whole report.
If this is not possible then conditional format for current page would help.

Scott Bader
admin Posted - 10/22/2020 : 20:40:44
This feature was not available in build 204.

1. What is the report type (OLAP, SQL) you most need this for?
2. Would enabling Data tables excel functionality work for you? This would export current page only.
Sailesh Posted - 10/22/2020 : 09:22:28
Hello, I tested this in your latest Demo version. It appears this does not work for me. Have any idea on when this could be fixed.

Scott Bader
Sailesh Posted - 09/29/2020 : 03:28:23
We are using Microsoft Office Professional Plus 2010. When will reports with cells highlighted in colour that are exported into Excel show correctly?

Scott Bader
Sailesh Posted - 09/29/2020 : 03:19:02
[i]Originally posted by admin[/i]
[br]Sometime this year. No specific date. Sorry.

Scott Bader
admin Posted - 05/20/2019 : 20:46:58
Sometime this year. No specific date. Sorry.
Sailesh Posted - 05/20/2019 : 08:52:32
Hi, When do you think this will be available.

Scott Bader
admin Posted - 05/16/2019 : 21:30:13
Yes, we do have plans to add cell color into Excel 2007.
Sailesh Posted - 05/09/2019 : 07:12:30

thanks for that; we can confirm this works for Excel 2003 but we prefer to now use Excel 2007 export for different reasons. Do you have a plan on introducing back those export features such as the cell color into Excel 2007 export, and if you do, when do you think this will become available? Thanks.

Scott Bader
admin Posted - 04/18/2019 : 04:48:07
Excel 2007 exporting is still limited. Please try exporting to Excel 2003 format.

Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000