Page 1 of 1

xlsx save options

PostPosted: Wed Sep 23, 2020 5:31 pm
by GK0059
Hi,

Is there a way to save the .xlsx file created or loaded using doc4j into the "Strict Open XML Spreadsheet" format directly?

The problem I am facing is that when I open the file I created on a different machine with different resolution, the row height is automatically changed. However, if I open the file on my machine in Excel application, save it in Strict Open XML Spreadsheet format, and then transfer to a different machine, the row heights do not change.


Thanks in advance :)

Re: xlsx save options

PostPosted: Sat Sep 26, 2020 12:00 pm
by jason
docx4j uses schema which aim to keep abreast of what Microsoft uses in practice, rather than the narrower "Strict" schemas.

It would be possible to offer the option of using the strict schemas, but there has historically been little demand for them.

In this case, a better approach may be just to delete the XML causing the unwanted behaviour.

If you can attach 2 xlsx files exhibiting this behaviour, I will try to identify it for you.

Re: xlsx save options

PostPosted: Mon Sep 28, 2020 4:34 pm
by GK0059
Hi Jason,

Here are the two files that exhibit the behavior I mentioned above.
If you open the files with 100% scaling, you will find everything aligned properly.
However, if you apply 125% scaling and reopen the files. You will find that many frames overlap.
This is because the row height of all the rows is changed.

Re: xlsx save options

PostPosted: Thu Oct 01, 2020 12:14 pm
by jason
I tried opening output1.xlsx in Excel (365 version 2008 build 13127.20408), at resolutions 1920x1440 and 1280x1024

I didn't notice any "overlap".

So could you please provide more detailed steps to replicate?

Re: xlsx save options

PostPosted: Thu Oct 01, 2020 8:30 pm
by GK0059
Hi Jason,

As I mentioned in my previous reply, to reproduce we need to change the scaling percentage.
To do this you can go to windows Display Settings and find the options for scaling under "Scale and layout".