`freeze_panes` does not appear to work

[informationsea]

`freeze_panes` does not appear to work

[Christoph-AK]

I do it for every sheet directly before saving the file and it works fine.

Pass the amount of rows and columns you want to lock!

So in your case (1,2)

    sheet1.freeze_panes(1, 1);
    sheet2.freeze_panes(1, 1);
    sheet3.freeze_panes(1, 1);

    if excel.close().is_ok() {...}

[ryanmcgrath]

Hmmmm... well, I'm certainly open to being wrong. Suppose I'll tinker a bit more, there's probably something I've missed then. Thanks for the sanity check!

[Christoph-AK]

If you post some code that refuses to work I might be able to help out more.

[jmcnamara]

It should work as expected. The only thing to look out for is to make sure that splitting cell is after the split, like in Excel.

I need to freeze the header (row 0) and the first two columns (columns 0 and 1).

In that case you would need to split at row = 1 and column = 2. This is still zero indexing but the split needs to be specified in the bottom right quadrant instead of the top left. Here is an example.

So Here is an example:

use xlsxwriter::Workbook;

fn main() -> Result<(), xlsxwriter::XlsxError> {
    let workbook = Workbook::new("freeze.xlsx");
    let mut worksheet = workbook.add_worksheet(None)?;

    for row in 0_u32..10_u32 {
        for col in 0_u16..8_u16 {
            worksheet.write_string(row, col, "Text", None)?;
        }
    }

    worksheet.freeze_panes(1, 2);

    workbook.close()
}

Output:

I'd suggest closing this issue.

[ryanmcgrath]

Thanks!