xlsx save options

[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

[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.

[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.

[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?

[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".

[GK0059]

Hi Jason,

Were you able to identify the cause?