Forum
Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Export into Excel
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

Sailesh

United Kingdom
22 Posts

Posted - 04/17/2019 :  01:12:25  Show Profile  Reply with Quote
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

admin

1615 Posts

Posted - 04/18/2019 :  04:48:07  Show Profile  Reply with Quote
Excel 2007 exporting is still limited. Please try exporting to Excel 2003 format.
Go to Top of Page

Sailesh

United Kingdom
22 Posts

Posted - 05/09/2019 :  07:12:30  Show Profile  Reply with Quote
Hi,

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

Edited by - Sailesh on 05/09/2019 07:13:10
Go to Top of Page

admin

1615 Posts

Posted - 05/16/2019 :  21:30:13  Show Profile  Reply with Quote
Yes, we do have plans to add cell color into Excel 2007.
Go to Top of Page

Sailesh

United Kingdom
22 Posts

Posted - 05/20/2019 :  08:52:32  Show Profile  Reply with Quote
Hi, When do you think this will be available.

Scott Bader
Go to Top of Page

admin

1615 Posts

Posted - 05/20/2019 :  20:46:58  Show Profile  Reply with Quote
Sometime this year. No specific date. Sorry.
Go to Top of Page

Sailesh

United Kingdom
22 Posts

Posted - 09/29/2020 :  03:19:02  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]Sometime this year. No specific date. Sorry.



Scott Bader
Go to Top of Page

Sailesh

United Kingdom
22 Posts

Posted - 09/29/2020 :  03:28:23  Show Profile  Reply with Quote
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
Go to Top of Page

Sailesh

United Kingdom
22 Posts

Posted - 10/22/2020 :  09:22:28  Show Profile  Reply with Quote
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
Go to Top of Page

admin

1615 Posts

Posted - 10/22/2020 :  20:40:44  Show Profile  Reply with Quote
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.
https://datatables.net/reference/button/excel
Go to Top of Page

Sailesh

United Kingdom
22 Posts

Posted - 11/19/2020 :  09:09:15  Show Profile  Reply with Quote
Hello
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
Go to Top of Page
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000