Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-16 Thread Tom Williams
On 08/11/2014 08:33 PM, Brian Barker wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-16 Thread Tom Davies
Hi :) HR! Congrats for finding that!! It's difficult to deal with such things diplomatically sometimes! Things that make complete and obvious sense to a whole group of people (and therefore don't need explaining (in the same way as it's rare to explain to someone that we breathe air or

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-13 Thread Tom Williams
On 08/11/2014 08:33 PM, Brian Barker wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-13 Thread Tom Williams
On 08/12/2014 01:16 AM, Tom Davies wrote: Hi :) +1 Also ... Errr, how are the cells being hidden?!?? Of course it is possible to hide an entire row or column by clicking on the row/column header (1, 2, 3 etc or A, B, C etc) and then right-click to hide the entire row/column. This is what

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-13 Thread Tom Williams
On 08/12/2014 01:22 AM, Tom Davies wrote: Hi :) Also the 4.1.0 was VERY early in that branch's cycle. There have been numerous updates to fix lots of bugs and make it more stable. So instead of the 4.1.0 it would be better to try the 4.1.6. Similarly with the 4.0.1. That 3rd digit shows

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Tom Davies
Hi :) +1 Also ... Errr, how are the cells being hidden?!?? Of course it is possible to hide an entire row or column by clicking on the row/column header (1, 2, 3 etc or A, B, C etc) and then right-click to hide the entire row/column. To hide individual cells it might be easier to grab a

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Tom Davies
Hi :) Also the 4.1.0 was VERY early in that branch's cycle. There have been numerous updates to fix lots of bugs and make it more stable. So instead of the 4.1.0 it would be better to try the 4.1.6. Similarly with the 4.0.1. That 3rd digit shows it had only 1 update (to fix bugs) since the

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Alex McMurchy
Perhaps you can change the text colour to be the same as the background colour - effectively hiding it. Then protect the sheet/cells as per this in the help https://help.libreoffice.org/Calc/Protecting_Cells_from_Changes On Tuesday 12 Aug 2014 09:16:15 Tom Davies wrote: Hi :) +1 Also ...

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Brian Barker
At 09:16 12/08/2014 +0100, Tom Davies wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Brian Barker
At 11:30 12/08/2014 +0100, Alex McMurchy wrote: At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Alex McMurchy
No, I can't believe that Calc is magically converting cells contents to images. Is the cell subject to a formula somewhere else on the sheet? What happens when you try and delete the object that is symbolised by the anchor and green squares along the perimeter? On Tuesday 12 Aug 2014 13:05:48

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Tom Davies
Hi :) +1 I think it's more likely that the user has found ingenious and unexpected ways to hide cells, such deliberately using images. Regards from Tom :) On 12 August 2014 14:24, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: No, I can't believe that Calc is magically converting

[libreoffice-users] Question about Calc and hiding rows

2014-08-11 Thread Tom Williams
My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's looking at the spreadsheet. Today, he needed to change a cell in one of the hidden rows. When

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-11 Thread Brian Barker
At 19:34 11/08/2014 -0700, Tom Williams wrote: My dad is a long time OpenOffice user and today he called me about a problem he's having with one of his spreadsheets. Apparently, he hides rows to reduce the amount of information he sees when he's looking at the spreadsheet. Today, he needed to