Hi, I have 2 questions,
when I set the height of the cells to 50 ( activeWorksheet.Cells.StandardHeightPixels = 50;) I got some unexpected result, something like I’m seeing the JSON that I’m passing to the data source. attaching the pdf here (order time column) transactionreport_11_07_2022_20_23_12.pdf (75.9 KB)
also, this example is when the standardheightpixels is 70 : transactionreport_11_07_2022_20_21_50.pdf (70.6 KB)
why this is working like that?
our goal is to set the hight of the “data_area” (attached template : Transaction report PDF.zip (10.0 KB) ) to be the same cross entier report. (we can set that manually from row 3/4) there is a way to achieve that instead of set the entire excel file with the same row height? even “copy style” is not working here.
we need the row height will be the same cross all the data rows (you can see the first “table” is with some height and the rest are regular. attached current output: transactionreport_11_07_2022_19_58_30.pdf (68.7 KB)