P
P
Pekky2019-08-10 14:32:03
excel
Pekky, 2019-08-10 14:32:03

An excel document after allowing editing, does it change the size of the columns?

I use the phpspreadsheet library to create excel reports, (for printing, a sheet as a4) I set the size of each column in the code, when I open the document - everything is fine, just click the allow editing button, the size of the columns immediately changes, adds about 2 to each column -3 mm and I have one column shrinking, how to solve this problem? I even put a ban on editing, nothing helped
Screen, before and after:
5d4eaae3b0d7f951557957.png
5d4eab25a4de0336396983.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2019-08-10
@idShura

Try setting setAutoSize(false) for the required columns

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question