Re: freeing pane not from top row

It seems none of the images made it through, at least I cannot see them.

Maybe you can show a minimal code-snippet that you use to create a file
which does not work for you?

Dominik.

On Tue, Sep 26, 2023 at 1:38 PM Yair Ogen <[email protected]> wrote:

>
>
>
> I can't make poi work for creating xlsx file with freeze pane starting not
> in cell (0,0).
> consider this raw excel:
>
> [image: image.png]
>
> I want to freeze it using POI to look like this:
>
> [image: image.png]
>
> Meaning: freezing 10 rows and 5 column. but top left freeze pane should be
> cell (9,5) cell A10.
>
> I tried to apply it with the 2 overloads of xssfSheet.createFreezePane -
> none seem to work.
> either I get the correct freeze pane size but starting from A1 or I get an
> error in the excel file meaning it wasn't saved properly.
>
>
>