Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE
Vote for ONLYOFFICE

Copy formatting, formulas and data validation from table to autoexpanded rows

Do you want to: Suggest a feature / Ask a how-to question
Type of installation of the Document Server: rpm
OS: Fedora 35

Hi! First post here so please be nice! :wink:

It would be nice if the program could copy the formatting, formula, and data validation information etc. from the other rows when the table autoexpands as you add more rows to the table. Don’t know if this already is a feature of the program or not, but excel has had it for a long time. And it is a real burden to have to use excel just for that feature…

Best regards

Hello @unknown
Could you please provide us with test file and description of usage scenario? We would like to check it out.
Also, if it’s possible, please point us to mentioned feature in MS.

Hi! Sorry for the late reply but I haven’t been in from of my computer for a few days.

I’m attaching two files, one for excel and one for onlyoffice. If you open up both files in their respective program, and try to write two sixes below the fives you’ll see that excel will copy the formula to the new row, but Onlyoffice wont. The same goes for the data validation column, in excel you’ll see that on the new row you get a drop down in that column like you get on the rows above.
And lastly you’ll also see that if you try to write an integer in the custom number formatting column, that excel will add a bunch of zeros as I’ve formatted it like that. But the same goes here onlyoffice doesn’t copy this information to the next row.

Another thing that has been a little bit disturbing is that if I in excel select a few columns or rows and double click on the line between them to auto size them. Excel auto sizes all columns that I have selected but Onlyoffice only auto sizes the column that I did the double click on.

If you want something else just tell me and I will see what I can help out with! :slight_smile:

Couldn’t upload the xlsx files here, as the forum only seems to allow pictures. So I’ve uploded them to this share. They should be available for 30 days according to the host.

Best regards

Edit: Don’t know if it is necessary or not but I realised that I didn’t tag you, @Alexandre

Hello @unknown
I am glad that you came back with test files.

I’m attaching two files, one for excel and one for onlyoffice. If you open up both files in their respective program, and try to write two sixes below the fives you’ll see that excel will copy the formula to the new row, but Onlyoffice wont. The same goes for the data validation column, in excel you’ll see that on the new row you get a drop down in that column like you get on the rows above.
And lastly you’ll also see that if you try to write an integer in the custom number formatting column, that excel will add a bunch of zeros as I’ve formatted it like that. But the same goes here onlyoffice doesn’t copy this information to the next row.

I am able to reproduce it, we are checking the situation.

Another thing that has been a little bit disturbing is that if I in excel select a few columns or rows and double click on the line between them to auto size them. Excel auto sizes all columns that I have selected but Onlyoffice only auto sizes the column that I did the double click on.

To be honest, I’m not sure that I understand scenario right. Could you please record a video file with usage scenario?

Hello @unknown

I’m attaching two files, one for excel and one for onlyoffice. If you open up both files in their respective program, and try to write two sixes below the fives you’ll see that excel will copy the formula to the new row, but Onlyoffice wont. The same goes for the data validation column, in excel you’ll see that on the new row you get a drop down in that column like you get on the rows above.
And lastly you’ll also see that if you try to write an integer in the custom number formatting column, that excel will add a bunch of zeros as I’ve formatted it like that. But the same goes here onlyoffice doesn’t copy this information to the next row.

We have checked described situations and we added a bug and suggestion to internal tracksystem (internal numbers: 43063 and 57648). We have started working on it.