Ask Your Question

byslexic's profile - activity

2017-12-05 06:59:21 +0100 received badge  Famous Question (source)
2017-12-05 06:59:21 +0100 received badge  Notable Question (source)
2016-08-13 03:07:36 +0100 received badge  Popular Question (source)
2016-08-11 22:14:03 +0100 commented answer how Do I select & delete image on Calc page

Thanks for the solution; but it's led to a related problem - the Navigator shows there are some 80+ images in the file, and most of them are named "Picture 1". Double-clicking on one in the Navigator image list does select an image, but then immediately moves the Navigator list to the bottom, so I can no longer see the image name I just selected, and it becomes very difficult to keep track of which "Picture 1" I just selected, and scroll all the way back to the same spot in the list. Ideas?

2016-08-11 01:59:15 +0100 asked a question how Do I select & delete image on Calc page

using Calc 5.1.4.2 Trying to fix a broken jpg image in my sheet.
image description

Don't seem to be able to select the broken image in order to delete it and replace with a working one. Nothing happens when I click on it, left-or-right click, or try to select with the drawing toolbar pointer. nothing selects it. Please tell me how to select & fix or delete. Thanks!

2013-10-22 19:20:11 +0100 received badge  Notable Question (source)
2013-10-22 19:20:11 +0100 received badge  Famous Question (source)
2013-10-22 19:20:11 +0100 received badge  Popular Question (source)
2013-01-04 20:27:58 +0100 commented answer Copy a functional pivot table

Thanks Kohei - that seems to work. You mentioned that there are several ways, and I'd like to know another one.

If I want 12 copies of the pivot table (one per month), I have to add 12 sheets to my workbook, which is a bit ungainly, though would do the trick. How else can this be accomplished?

2013-01-04 20:27:29 +0100 answered a question Copy a functional pivot table

Thanks Kohei - that seems to work.
You mentioned that there are several ways, and I'd like to know another one.

Copying the sheet with the pivot table does work, but if I want 12 copies of the pivot table (one per month), I have to add 12 sheets to my workbook, which is a bit ungainly, but would do the trick.
Is there another way?
Again, Thank you!

2013-01-04 20:23:47 +0100 received badge  Scholar (source)
2013-01-04 02:25:12 +0100 asked a question Copy a functional pivot table

I keep having to recreate the same pivot table over and over, then change the filter in each instance in order to sort and summarize a large table of data by month.

Is there no way to quickly copy a functional pivot table, so as to apply and display differently filtered data?

Thanks!