Custom format and borders


#1

I set a custom format to cells but a top border appears on the cells where there is a bottom border on the row before (rows 22, 39 and 44 in the example).

Aspose.Cells.Workbook w = new Workbook();

w.Open("C:\\format.xls");

Aspose.Cells.Worksheet xlSheet = w.Worksheets[0];

for(int i = 20; i < 45; ++i)

{

for(int j = 8; j < 15; ++j)

{

Aspose.Cells.Cell c = xlSheet.Cells[i,j];

c.Style.Custom = "#,##0.00 $";

}

}

w.Save("C:\\aspose.xls");

Thanks

Alexandre


#2

Hi Alexandre,

Thanks for considering Aspose.

Well, We will sort out this issue and response you soon.

Regards

Amjad Sahi

Aspose Nanjing Team


#3

Hi Alexandre,

I did check the source and the output file with your code.

They are absolutely fine. You say that there is a top border before row 22, 39, 44 etc.. actually row 21, 38 and 43 are hidden and the top line is just the indication of the hidden rows and not border. Exapnad all those rows and make them visible and you will notice the results.

If you still have queries, feel free to contact us any time.

Thanks,

Regards

Amjad Sahi

Aspsoe Nanjing Team


#4

Here is the output I have (version 4.0.3.0)

The columns K and N (and also other columns that are hidden) have a top border for the rows 22,39 and 44 and they didn't have one before I executed the code to set the format.


#5

Yes, we find this problem and will fix it with the formula lost issue. You will get a new fix at the start of next week.


#6

Thank you Laurence.