I have Collabora COOLWSD 22.05.12.4 on an iPad 12.9 5Gen with iOS 16.4.1(a). I was using an Apple Magic Mouse (first gen) with the iPad. I wanted to insert a row in an existing .ods file last accessed from Libre Calc on Windows.
I tried clicking the line number, click and hold, finger tap, long press… No insert menu. (I later found I could actually right click on the mouse like on Windows and get the “Insert Above/Below” menu options - I didn’t know that ever worked on iOS!)
I searched help and the web, and every hit said I needed the Sheet menu. But there was no Sheet menu! After a maddening trial of every item on every menu, I found View → Compact View which made the Sheet menu appear among the others. And it showed the “Insert Row” text option!
But why wasn’t Sheet there before, by default? Eventually I found View → Use Tabbed View which took me back to the no Sheet mode. And moved the View menu way to the right. Where it showed the Compact View option again.
Later I found that in the default “Tabbed View” Layout menu option (or in the Home menu option but way off the right edge of the screen) there are icons with 4x4 squares and arrows, and one of them will insert the row I wanted - but it is hard to guess which one… Turns out if you just mouse over them, you don’t get the popup clues. But if you finger tap something in that tab line, then everything you later mouse over shows a popup explanation! That would have saved me so much struggle…
So maybe I know how to work through this now. Except for one thing… While I was trying every option, in the row of icons below the Compact View menu items, I tapped the short horizontal line between the circle “shapes” dropdown and the “insert hyperlink” button. It drew a horizontal line 3.5 columns wide and 1/3 of the way up the row at a random location in the middle of the sheet. Tried again and it drew another one, lower and farther right. I can’t seem to select them with finger or mouse, or affect them in any way. If I delete the row they are in, they stay in the same screen position and another row moves up under them. What are these, and how can I get them out of my sheet?
Is any of this worthy of a bug report, or a documentation improvement request, or am I just dense?