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 it had only 1 update (to > fix bugs) since the beginning of it's branch. Better to try the 4.0.6 !
I had him reinstall OpenOffice 4.0.1 because that was the previous version he used before I upgraded it to 4.1.0. Thanks! Peace.. "The Other" Tom > On 12 August 2014 09:16, Tom Davies <tomc...@gmail.com> 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. >> >> >> To hide individual cells it might be easier to grab a graphic, drag it >> onto the spreadsheet, perhaps right-click again to "Anchor to" - "page" and >> resize to fit the cell(s). >> >> It's also probably possible to put a frame over the cells and then have >> writing or number in the frame although it might be difficult to then reach >> those numbers in calculations in the rest of the spreadsheet because they >> wont be recognised as being in a cell. >> >> Regards from >> Tom :) >> >> >> >> >> On 12 August 2014 04:33, Brian Barker <b.m.bar...@btinternet.com> 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 looking at the >>>> spreadsheet. Today, he needed to change a cell in one of the hidden rows. >>>> When he tried to make a change, he showed the row but wasn't able to change >>>> a cell because something prevented him from making changes. When he showed >>>> the hidden row, he saw an icon for an anchor and green squares along the >>>> perimeter of the selection of the now shown rows. >>>> >>>> He sent the spreadsheet to me and when I open it in LibreOffice Calc, >>>> 4.2.4.2 on Linux, I see the same behavior he describes. From what I can >>>> tell, it looks like Calc converts the hidden row into an image or graphic >>>> of some kind such that when he tries to change it, he can't because those >>>> rows are now part of an image/graphic or "object" that's embedded in the >>>> file. >>>> >>> I doubt very much that Calc has converted values to a picture of those >>> values. But yes: you very probably do have a graphic or other object in or >>> covering the relevant cells. If you need to modify a cell which appears >>> inaccessible because of an overlaid graphic, there are a number of ways to >>> do this. >>> >>> o You can type the cell reference into the Name Box and then edit the >>> contents in the Input Line. >>> >>> o You can (temporarily?) suppress display of the graphic at Tools | >>> Options... | LibreOffice Calc | View | Objects | Objects/Graphics. >>> >>> o Most easily, you can send the graphic to the background using >>> right-click | Arrange > | To Background. If you do this, you may want to >>> bring it back to the front after you have completed the edit, but you will >>> not be able to select it by simply clicking on it precisely because it is >>> now in the background. One convenient way to select the graphic is to open >>> the Navigator (go to View | Navigator or press F5) and double-click the >>> name of the graphic. You can then use right-click | Arrange > | To >>> Foreground to reset the position. >>> >>> Of course, if you cannot see the graphic and are not missing anything, it >>> may be that you don't want it and can merely delete it. >>> >>> I trust this helps. >>> >>> Brian Barker >>> >>> >>> >>> -- >>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- >>> unsubscribe/ >>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >>> List archive: http://listarchives.libreoffice.org/global/users/ >>> All messages sent to this list will be publicly archived and cannot be >>> deleted >>> >>> -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
