Hello,
For the love of all that is digital, how do I make ONLYOFFICE stop creating endless rows and columns as I scroll the spreadsheet? I want to have a max number of rows and a max number of columns, if I need more I can create more, endlessly adding more as I scroll as default is a huge troll, please help.
Thank you.
Hello @extremelysadcustomer
Please clarify your request. For example, point us to a similar feature in other editors.
I’m not sure that I understand it correctly. There’re no endless rows\columns creation. There is limit for 1 048 576 rows and 16 384 columns.
Hi Alexandre, thanks for the response!
There are no parallels that I can remember, no other software does this as far as I can tell hence how difficult it is to explain.
Create a new google sheet, scroll as far down as you can, usually that is row number 1000, select rows from 13 to 1000, delete them, now the page does not scroll down anymore, it has only 12 rows in height.
Create a new ONLYOFFICE sheet, scroll as far down as you can, 3 days later you’re still scrolling down, it doesn’t have and "end’, it does not allow me to “delete” the extra rows to make the page only 12 rows in height.
This is bad because I am constantly over scrolling, having to scroll back to the content, over scrolling, having to scroll back to the content, over scrolling having to scroll back to the content.
I hope this makes sense, I am feeling like a lunatic for being the single person in the entire internet to have such problems with this (I searched for this relentlessly before this post), maybe I am the oldest person on the internet using ONLYOFFICE and ya’ll young folks have extra steady scrolling hands ¯_(シ)_/¯
Thanks, have a good weekend!
Hi @extremelysadcustomer,
it is exactly as Alexandre has said. The only exception is google sheet, which shows you first of all only 1.000 rows when you create a new sheet.
At the bottom of the sheet there is a box where you can add 1.000 additional rows and so on.
Excel behaves exactly like Onlyoffice and lets you scroll to the final row
Have a nice day!
Ouch, all right, thanks for confirming that is not a something that can be set in the configuration. In any case there is probably no demand for a feature like this so thanks for clarifying.
Have a good one!
But Excel allows you to hide all this excess space quickly and, importantly, the hiding eliminates scrolling that causes page to move around.
See here:
Can you hide rows/columns like this in Onlyoffice? Well, you can hide rows I know but how can we “select” all rows to the end like in the video?
FYI: Google Spreadsheets isn’t the only major spreadsheets app with the ability to easily hide practically superfluous columns and rows. Apple Numbers offers that feature relatively prominently as well.
And from a UX perspective I think it is a very valuable feature, as an amount of rows and columns which feels nearly endless isn’t really helpful for many typical users, but rather creates clutter, causes long scroll bars and quickly leads to left columns becoming hidden if users accidentally scroll to the right (where there’s actually no content, so no need for columns either).
Hello @jmi
Thank you for sharing your feedback. We have collected it and we will discuss it internally. I will update this thread once we have something to share.
Dear OnlyOffice dev team,
Has anything been decided regarding the possibility to limit the number of rows and columns in a given spreadsheet ?
Personally, I think that this is a killer feature of Apple’s Numbers that I’m really happy to have enabled by default on my OSX machine. It really is a life changer when working on a daily basis on moderate sized data: 150 lines and around 35 columns is what is use the most, it doesn’t really fit on a single screen (but almost) and having the scrolling stop at the end of data really helps.
In my opinion, this, as well as their interface to sort data (decide the number of row and column headers, sort lines according to a lexicographical order of columns that can be dynamically modified), really make Numbers stand above the crowd of spreadsheet software.
Regards.
Hello @zebulon
Unfortunately, there’s no news on this feature. We are still looking into it.
We will update this thread when we have something to share.