2018-08-15 01:42:01 +0200 received badge ● Famous Question (source) 2017-10-09 09:43:07 +0200 received badge ● Famous Question (source) 2016-11-07 17:29:49 +0200 received badge ● Notable Question (source) 2016-03-11 01:12:28 +0200 received badge ● Popular Question (source) 2016-03-10 22:21:15 +0200 received badge ● Notable Question (source) 2016-03-10 22:21:15 +0200 received badge ● Popular Question (source) 2016-01-18 14:17:20 +0200 asked a question How do I delete all rows below a certain point in LibreCalc, without causing it to hang? I did a dumb thing. I wanted to make a new column that used the same formula as an old one, but modified slightly. So I added a new column, selected a cell containing the original formula, copied it, selected the new column, and hit paste. By pasting to the entire column, I apparently told LibreCalc to paste the formula to every cell in that theoretically infinitely-long column. It has added some huge number of rows to my document (the file size has grown from 42KB to 86MB) and LibreCalc now hangs any time I try to do almost anything with the document. What I would like to do is remove anything in any row below a certain number, but I'm not having any luck finding a way to do that without causing LibreCalc to hang. I tried: Using the Undo button, to undo the paste. Creating a new sheet, cutting and pasting only the data I want into it, then deleting the original sheet. Selecting the entire sheet (by clicking the box in the upper left of the column and row headers) then shift-unselecting the data I want to keep and deleting the remaining selected space. Is there anything else I can try to recover my document to a workable state? Using Calc 4.2.8.2 (because that's the version my distro seems to have available...) 2016-01-12 16:46:04 +0200 asked a question Copying a functional pivot table between documents Using Calc 4.2.8.2 (because that's the version my distro seems to have available...) I'm trying to copy a pivot table from one document to another, and end up with a functional pivot table in the destination. The advice given here: https://ask.libreoffice.org/en/questi... specifically does NOT seem to work. More detail: I received a calc document from an outside source, and added a page with a pivot table. I offered the revised version of the doc back to the original creator, but he's not interested. Now he has released a new version of his original doc with revised numbers. I would really like to copy my pivot table from the old doc to the new, without having to recreate all of it's tedious details by hand. But every method I have tried so far - including both of the methods listed in the linked solution from this site - ends me up with a static table with values from the original sheet. Is there any way that I can copy the page and/or table from the first doc to the second, and end up with a dynamic pivot table that updates from the values in the new doc, and can be modified (if, for instance, the input range should be expanded?) Thanks for any help,  - rob.