Re: [libreoffice-users] Question about Calc and hiding rows
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 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. Well, I have an update on this issue. You were 100% correct about an image covering the cells. Apparently, my dad used a copy/paste function to update the spreadsheet and pasted data as a bitmap. So, I was able to guide him through simply deleting the image and his data is editable as expected. THANK YOU! :) Peace... Tom -- /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
Re: [libreoffice-users] Question about Calc and hiding rows
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 that the sky is blue unless it's sunset or when there's a lot of cloud-cover) are completely unheard of by someone else who might have their own 'obvious' way of doing things. It can be really frustrating trying to figure out what 'obvious' thing the person has missed or what thing they have done and not bothered to explain. So, good work! Nicely handled! Congrats and regards from Tom :) On 16 August 2014 17:39, Tom Williams tomd...@comcast.net wrote: 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 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. Well, I have an update on this issue. You were 100% correct about an image covering the cells. Apparently, my dad used a copy/paste function to update the spreadsheet and pasted data as a bitmap. So, I was able to guide him through simply deleting the image and his data is editable as expected. THANK YOU! :) Peace... Tom -- /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 -- 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
Re: [libreoffice-users] Question about Calc and hiding rows
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 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 Thanks for the information and sorry for the delayed response. I'll give this a try and will report back my findings! :) Peace... Tom -- /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
Re: [libreoffice-users] Question about Calc and hiding rows
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 my dad does to hide the rows in question. :) Peace... The Other 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
Re: [libreoffice-users] Question about Calc and hiding rows
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
Re: [libreoffice-users] Question about Calc and hiding rows
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 -- 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
Re: [libreoffice-users] Question about Calc and hiding rows
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 ! If you really want to only use ones at the very beginning of a branch's cycle then the 4.3.0 might be a better bet anyway. Personally i would suggest going to the 4.2.6 to get all the updates without having to deal with new features that might have caused new problems. Regards from 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 -- 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
Re: [libreoffice-users] Question about Calc and hiding rows
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 ... 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 -- 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
Re: [libreoffice-users] Question about Calc and hiding rows
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 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. 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. Er, the questioner well knows how to hide cells (in the normal way); his problem is not being able to edit them when he shows them again. Or do you believe Calc is magically converting cell contents to images? 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
Re: [libreoffice-users] Question about Calc and hiding rows
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 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. 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 Again, do you think the questioner is trying to hide cells? No, he can do that; he's having difficulty editing cell contents after the hidden cells are shown again. 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
Re: [libreoffice-users] Question about Calc and hiding rows
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 Brian Barker wrote: 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 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. 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. Er, the questioner well knows how to hide cells (in the normal way); his problem is not being able to edit them when he shows them again. Or do you believe Calc is magically converting cell contents to images? 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
Re: [libreoffice-users] Question about Calc and hiding rows
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 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 Brian Barker wrote: 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 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. 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. Er, the questioner well knows how to hide cells (in the normal way); his problem is not being able to edit them when he shows them again. Or do you believe Calc is magically converting cell contents to images? 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 -- 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
[libreoffice-users] Question about Calc and hiding rows
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. Any ideas on what could be going on? He first encountered this with OpenOffice 4.1.0 and continues to see it with OpenOffice 4.0.1. Thanks! Peace... Tom -- /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
Re: [libreoffice-users] Question about Calc and hiding rows
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
