I have a spreadsheet with multiple tabs in it. The first tab had 1149 rows of data, and the second two had various numbers of rows. I created a new tab and expanded the number of rows to 2900 in order to accommodate data that I copied from a local Excel file (the data was about 2700 rows or so). The paste seemed to work perfectly. My data was all in its place and looked great. I went on to some other data cleanup that I needed to do, and clicked over to the first, original tab. Suddenly, my data there was truncated to a little over 600 rows, and at first I thought it was just cutoff at the end, but it was missing data sporadically throughout the sheet. I had the data saved locally, so there’s no worry about data loss, but it was alarming. I used the ‘add 100 rows’ button to see if maybe the data was just hidden, but it did not appear - just 100 blank rows showed up.
I tried refreshing the page, but there was no change initially. I went on to do some other work, and a few minutes later went back to the tab and it was almost back to normal. Now it has regained most of the missing rows again. It has 1147, when originally it had 1149. I have no idea which 2 rows are missing - I’d have to do a deep dive to figure that out. I clicked the ‘add 100 rows’ button again, and again it showed me just 100 blank new rows, but the numbering was way off. It went from row 1147 directly to row 1827. Again I tabbed away and worked on other things, and when I went back and looked the next time, I was back to 1147 rows (the new added rows were gone). That’s where it stands right now.
Is there something I should have done to avoid this problem, or is this something anyone else has seen before? Or have I found a genuine bug in my adventures?
Thanks in advance for any advice/information