Ask Your Question

Dev Null's profile - activity

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 (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 (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:

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.