Free Support Forum - aspose.com

Merge and Hidden Cells

Aspose.Cells Product Family
#1

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We are interested in your Aspose cell product and we want to know if your product can solve the merge and hidden cells problem in our reporting services Excel export?

Regards

Champika

Rascal Solutions Ltd
Sigma House

Northfield Drive
Northfield

Milton Keynes
Bucks

MK15 0DQ

Tel: 01908 695795
Fax: 01908 200229

Email: champika@rascal-solutions.com

Url: www.rascal-solutions.com

This message was posted using Email2Forum by nausherwan.aslam.
#2

Hi,

Thank you for considering Aspose.

Aspose.Cells provides the functionality for Merging / Unmerging of Cells in a worksheet and also provide the Hide / Unhide rows and columns features. Please see the following documentation link in this regard:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net/merging-unmerging-cells-in-the-worksheet.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net/hidingunhiding-rows-and-columns.html

Also, please provide us further details regarding your requirements and share your template and resultant file here. We will check them and get back to you soon.

Thank You & Best Regards,

#3

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Also, to further update you, if your requirement is to use Aspose.Cells for Reporting Services than following are the detail regarding your requirements:

1. For Merging issue: Aspose.Cells for Reporting Services does support the Merge functionality and merge the cells in generated excel report when two or more cells are merged.

2. For Hiding issue: Aspose.Cells for Reporting Services normally exports data into Excel when the textbox report item’s visibility is set as hidden.

Does it meet your requirement? If you need any further assistance and support, kindly feel free to contact us any time.

Thank You & Best Regards,

#4

Hello<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We are using reporting service 2005 and as you can see from the following screen shot we get lots of merge and hidden cells when we export the report to excel ( we only use report manager to do exports). The problem with this is that when we can use it for select and copy past tabs etc.. . Can you confirm if your Aspose cell , excel export extension for reporting services could solve this problem

This message was posted using Email2Forum by nausherwan.aslam. (attachment)
#5

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

We have checked your shared image file; we think that you want to reduce merge cells and hidden cells.

For Merging Issue: If you want to reduce merging cells count, you must adjust your report define file (RDL). For precise positioning of report items we need the cell merging option.

Please post your report define file (RDL) here. We will check your report define file and analyze the reason of general hidden cells.

Thank You & Best Regards,

#6

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

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