Format Painter


#1

How can I use Format Painter in Excel ??


#2

Do you mean that you want to set a range of cells with same formattings? Please check http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/FormatRoutine.html .


#3

Thanks for the reply.

I needed the format painter to hide the row outlines for the 2 rows and show for the 3rd row so that 3 rows will look like a single cell. I can achieve this in excel throw format painter?? I'm wondering how can we achieve through aspose.

255.00%
140.00%
Pass
161.90%
130.00%
Pass


#4

Sorry, I am not clear about your need. Do you mean merged cells? Could you post a sample file here to show your need?