Hi there Aspose,
I would like to ask for help on row height after copying some rows.
where Aspose does not behave like Excel.
ENVIRONMENT:
Aspose 8.9.0.5
Excel 2013
PROBLEM:
When I am copying rows using ws.Cells.CopyRows(),
I have found out that some rows do not have their final* row height copied correctly.
*Using GetRowHeight() before saving gives me the correct value (11.25)!
RESULT:
- Aspose
The result is correct for rows with height == 19.5 and 15.75
where as copying rows with row height 11.25 gives me 12.75 when opened in excel
- Excel
2/3 of my testing machines gives the exact same row height (11.25 == 11.25)
the last machine gives me behaviour similar to Aspose.
POSSIBLE REASON:
*I have attached the excel *
The rows to be copied sized from 11.25 to 19.5
This problem started to appear when my colleague tested on my program,
where he has checked some options in the cell format,
something to do with “fit text to column width” etc. ( I guess? )
Steps: I did with aspose copyRows()
“Invoice” is the source worksheet
"Result" is the destination worksheet
1. Result.Cells.CopyRows(Invoice.Cells, 0, 0, 20)
2. Result.Cells[“O1”].value = getRowHeight()…etc.
3. wb.Save(“MID.xlsx”)
4. Check row height on Excel 2013
Tests: on Excel copying for all 3 machines
Test 1. Mouse highlighting “Invoice!A1:L20”; ctrl + c; ctrl + v on "Result!"
Test 2. Mouse highlighting “Invoice!$A:$L”…
Test 3. Mouse highlighting “Invoice!” row 1 to 20…
Sorry for the long post
and no potatoes
Regards,
Jonathan Lau