[libreoffice-users] SQL-Operators in LO 4.3.3.1-Base
Hello, I notice that the filter-operators = (less than) and = (greater than) are missing in the latest version of Base. Is this intentional? Regards H. Stoellinger -- 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] SQL-Operators in LO 4.3.3.1-Base
Hi :) !!! I think file a bug-report about it asap! Is there a work-around such as using and then = as separate keystrokes instead of clicking on the single button when making a formula? If not then it's probably worth marking the bug-report as extremely urgent or something like that. Regards from Tom :) On 12 August 2014 08:45, Rainermusik (Office) off...@rainermusik.at wrote: Hello, I notice that the filter-operators = (less than) and = (greater than) are missing in the latest version of Base. Is this intentional? Regards H. Stoellinger -- 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 :) +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
[libreoffice-users] UNSUBSCRIBE
-- 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] shortcut keys for LibreOffice under Linux
2014-08-12 4:55 GMT+02:00 Thomas ny...@hb.tp1.jp: Then I do have the choice between learning all the different shortcuts, or else switching to Ubuntu (this unity thing, which I do not like at all). Unity and XFCE are not the only desktop environments. If you have issues with one, and dislike the other, you can try KDE, which have no issues interfering with common keyboard shortcuts, and is also extensively configurable in case you find an obscure combination that conflict with libreoffice. -- Cley Faye http://cleyfaye.net -- 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] shortcut keys for LibreOffice under Linux
On 10 August 2014 21:13, Thomas ny...@hb.tp1.jp wrote: Yes, you are right! Under Xubuntu using XCFE the shortcut keys are different from the usual Ubuntu. I did not know and realize that. Bad form, IMO. But I suppose the developers of XCFE have their reasons. ??? But I'm glad the puzzle was resolved. Then I do have the choice between learning all the different shortcuts, or else switching to Ubuntu (this unity thing, which I do not like at all). I gave Unity a try — for nearly a year and just couldn't get used to it, but that was just me. I kept Ubuntu and switched to Cinnamon and then completely switched to Mint-Cinnamon. Does the LibreOffice community any opinion on this difference in shortcut keys between different OS (here Linux flavors)? I am just curious. IMNSHO, a Bad Idea. I think there should be consistency across platforms. For the most part, I think there is ... heck, even Ctrl+Z and Ctrl+Y function under Mint-Cinnamon as they do in Windows rather than the more standard ('nix) of Ctrl+Z and Shift+Ctrl+Z. -- T. R. Valentine A rich heart may be under a poor coat. -- 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] shortcut keys for LibreOffice under Linux
Linux Mint, is another nice choice for those looking for a classic Ubuntu feel. *Brian Colucci* *Information Technology Manager* MedWork_Logo_CMYK.jpg *MedWork Occupational Health Care* *1435 Cincinnati Street* *Suite 100* *Dayton, Ohio 45417* On 08/12/2014 08:51 AM, Cley Faye wrote: 2014-08-12 4:55 GMT+02:00 Thomas ny...@hb.tp1.jp: Then I do have the choice between learning all the different shortcuts, or else switching to Ubuntu (this unity thing, which I do not like at all). Unity and XFCE are not the only desktop environments. If you have issues with one, and dislike the other, you can try KDE, which have no issues interfering with common keyboard shortcuts, and is also extensively configurable in case you find an obscure combination that conflict with libreoffice. -- 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] shortcut keys for LibreOffice under Linux
Hi :) Weirdly under Unity both Ctrl shift z and Ctrl y both redo I've been using Unity for a couple of years. I didn't like it at first but it's made huge improvements. It feels like Gnome is going backwards and MateCinamon are getting heavier. KDE is awesome imo. Mint seems nice but it too seems to be getting heavier. Still all those DE's look nice in it and it seems quite usable. It's really nice that it's a well supported off-shoot of Ubuntu. If you are already familiar with Debian/Ubuntu family then Mint is a good one because everything will be VERY familiar whichever DE you choose. Regards from Tom :) On 12 August 2014 15:47, Brian A. Colucci bacolu...@medworkohio.com wrote: Linux Mint, is another nice choice for those looking for a classic Ubuntu feel. *Brian Colucci* *Information Technology Manager* MedWork_Logo_CMYK.jpg *MedWork Occupational Health Care* *1435 Cincinnati Street* *Suite 100* *Dayton, Ohio 45417* On 08/12/2014 08:51 AM, Cley Faye wrote: 2014-08-12 4:55 GMT+02:00 Thomas ny...@hb.tp1.jp: Then I do have the choice between learning all the different shortcuts, or else switching to Ubuntu (this unity thing, which I do not like at all). Unity and XFCE are not the only desktop environments. If you have issues with one, and dislike the other, you can try KDE, which have no issues interfering with common keyboard shortcuts, and is also extensively configurable in case you find an obscure combination that conflict with libreoffice. -- 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 :) +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] Re: Question about Calc and hiding rows
If the document has been going back and forth between LibreOffice and Apache OpenOffice (or old OpenOffice.org) it is quite possible that it was corrupted at some stage (I have a document where this happened...) If your father has been using OpenOffice only, can he pinpoint a version where it worked/works correctly? Does he have older copies of the document (it might have become corrupted at same point in the past...) In any case, the easiest way to try earlier versions of LibreOffice and OpenOffice (assuming he is using Windows) is to get Portable versions http://sourceforge.net/projects/winpenpack/files/X-LibreOffice/releases/ http://sourceforge.net/projects/winpenpack/files/X-ApacheOpenOffice/releases/ http://sourceforge.net/projects/winpenpack/files/X-OpenOffice.org/releases/ Hope this helps... -- View this message in context: http://nabble.documentfoundation.org/Question-about-Calc-and-hiding-rows-tp4118694p4118754.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: Question about Calc and hiding rows
Hi :) Ahhh, so the hidden columns/rows might well be the only ones corrupted? That would make it less annoying! Regards from Tom :) On 12 August 2014 16:44, Pedro pedl...@gmail.com wrote: If the document has been going back and forth between LibreOffice and Apache OpenOffice (or old OpenOffice.org) it is quite possible that it was corrupted at some stage (I have a document where this happened...) If your father has been using OpenOffice only, can he pinpoint a version where it worked/works correctly? Does he have older copies of the document (it might have become corrupted at same point in the past...) In any case, the easiest way to try earlier versions of LibreOffice and OpenOffice (assuming he is using Windows) is to get Portable versions http://sourceforge.net/projects/winpenpack/files/X-LibreOffice/releases/ http://sourceforge.net/projects/winpenpack/files/X-ApacheOpenOffice/releases/ http://sourceforge.net/projects/winpenpack/files/X-OpenOffice.org/releases/ Hope this helps... -- View this message in context: http://nabble.documentfoundation.org/Question-about-Calc-and-hiding-rows-tp4118694p4118754.html Sent from the Users mailing list archive at Nabble.com. -- 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] UNSUBSCRIBE
On 12-8-2014 12:56, Gabriele Azzaro wrote: To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org -- 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] Currently Using Spreadsheet for Personal Project - Thinking About Database
Paul wrote: So I was interested, and did a little more digging. I figured I would share the info. On Sun, 10 Aug 2014 22:48:43 +0100 Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: I don't know to be honest, not having a lot of experience in database design. I've only ever really used MySQL, which does support enums, but maybe that's just a MySQL feature. Seems like it is a MySQL specific feature, although PostgreSQL seems to support it. Ah, so definitely best avoided if portability is a concern! And probably advisable to avoid even if portability isn't an immediate concern. To me, the set of possible status values just seems more like part of the database schema design than data entry - you wouldn't generally add or remove status options (and the application may assign special meaning to certain statuses, so it may be critical that a specific set of values is defined). Then again, in some applications being able to introduce new statuses at any time could be an advantage. Yeah, being able to change these values later is one of the main reasons to use a separate table. Clients almost *always* end up adding or removing some of these. The database work I've done has been for either myself or small voluntary organisations I'm involved in, so I've never really had to deal with that. Where the set of values could obviously be expanded (e.g. to indicate colour of something) I'd certainly do that with a table containing the options. My main use for enums has been to indicate things like male/female gender, allowing null if I need to allow for an unknown value (point taken - someone might would want to expand that list of options...) Also, when you have specific functionality tied to some of these statuses, it's always a good idea to add a flag field for it, and make your code check if the flag is on, rather than if the status name matches a specific value, so that if the client ends up deciding (as they invariably will) that actually a second status must also do that thing that they assured you only the one status would ever do, then you simply turn that flag on for the second status, rather than having to change your code base and hunt for all instances of checking for the status by name. One of the places I have used enums was for that kind of a flag, where there were three options for how the application could handle a record. Essentially an event booking database where each participant was assigned to one of about 10 groups, and each group needed to be handled by the application in one of three different ways (displaying different sets of options), so I had a group type enum (with three possible values) on the groups table indicating to the application how participants in that group should be handled. Looking back, I actually did end up writing code into the application to decode that group type into a set of flags indicating which parts of the GUI should be displayed and which options should be offered - with the intention of porting that into a database table. I just never got round to doing that before the event was over. So it seems I'm violently agreeing with you! Also, then you can localize your status names if you ever want to make your program support other languages. Something else I haven't had to worry about, but if I did I'd have done the localisation in the application - the enum values (as I use them anyway) are not generally displayed as-is to the user anyway, they're just convenient names to use in the database. Using localised status names in the database table surely hinders localising the application - if you wanted to connect both English and French front-end applications to the same back-end database, wouldn't they both get the same status names to display, rather than the names appropriate for the application language? Or would the status table in that case contain strings in one language (or perhaps even generic keywords) for which the application would look up translations in it's own localisation table? The page here gives some benefits and pitfalls, but I don't see any of the benefits as not being provided by the separate status table solution: https://www.udemy.com/blog/mysql-enum/ This page also gives a few more reasons why you shouldn't use them, and prefers reference tables, which I called status tables: http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/ Some interesting points there, thanks. While most of those reasons may not apply to this project, the two that do for me are: 1) The statuses are data, and shouldn't be stored as structure. This is a conceptual thing, but it's best to start out thinking the right way. In this particular case with statuses, I could go either way and do see your point. I might even go with having date started and date finished fields and determining whether a book is unread, in progress or completed from those. More generally, I'd certainly use a
[libreoffice-users] Error
blockquote {padding-left: 1ex; margin: 0px 0px 0px 0.8ex; border-left: #cc 1px solid;} p {margin: 0px;padding: 0px;} Check =2^53 it shows 9007199254740990 -- 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] Re: Base questions
Wolfgang Keller wrote: This is one way Base is more powerful than Access. That's the whole point. By not focusing on promoting Base as *the* generic client-side FOSS tool for access to client-server RDBMs, they're missing a *HUGE* opportunity. And since Rekall has vanished (despite being GPL), there's not much in terms of database tools (that don't require programming) in the FOSS world. Kexi isn't available anywhere else than on Linux and it's missing critical functionality (e.g. support for composite keys). Hi Wolfgang and all, I am Kexi maintainer. Nice to meet you and it will be exciting to deliver the missing functionality that's critical to you. Please don't hesitate to it discuss further - on the forums: https://forum.kde.org/kexi - or within the mailing list https://mail.kde.org/mailman/listinfo/kexi. As for the native Windows and Mac versions, they are in development now with a deadline in Q2 2015. The delay is related to the fact that we're heading to a highly modern Qt 5 version that enables a version for mobile devices. Thanks! -- regards / pozdrawiam, Jaroslaw Staniek Kexi Calligra KDE | http://calligra.org/kexi | http://kde.org Qt for Tizen | http://qt-project.org/wiki/Tizen Qt Certified Specialist | http://www.linkedin.com/in/jstaniek -- 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] Currently Using Spreadsheet for Personal Project - Thinking About Database
Hi Mark, On Tue, 12 Aug 2014 22:37:18 +0100 Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: [snip] Also, then you can localize your status names if you ever want to make your program support other languages. Something else I haven't had to worry about, but if I did I'd have done the localisation in the application - the enum values (as I use them anyway) are not generally displayed as-is to the user anyway, they're just convenient names to use in the database. Using localised status names in the database table surely hinders localising the application - if you wanted to connect both English and French front-end applications to the same back-end database, wouldn't they both get the same status names to display, rather than the names appropriate for the application language? Or would the status table in that case contain strings in one language (or perhaps even generic keywords) for which the application would look up translations in it's own localisation table? Normally, localization is done by having a plain text file with all the application strings in it, and this file is simply copied and each string translated for each different language. Then at run time the application knows which locale it is in, and looks in the appropriate file for all the translated application strings. But they can just as easily be stored in the database, though. (Sorry, I know you probably know that, just including it all for anybody reading that isn't as familiar with this stuff.) Now, I've never actually dealt with localization myself, so I'm guessing a little, and not sure what might be considered best practice out in the wild. But obviously you wouldn't want to add a new field to each table for each language, although you might if you were only dealing with a small, restricted set of languages. But generally you want that sort of stuff stored as data, not as structure, because it's easier to add rows than it is to add fields. So I'm guessing one solution would be to add a language code field to the lookup table, and make a composite primary key of that and the ID. Then you can enter one row for each status for each language. But generally I think composite keys are considered bad. Although maybe not, but I don't like them, at least. So another approach is to link on something other than the primary key. One thing we often did with lookup tables was have a short code and a description for each, so for purposes of the application you would use the code, but you could display the description to the user. And use whichever one fit better for printing. So you could use the short code as the foreign key from whatever table references the status table, instead of the ID. Then the status table could still have a single primary key field of the ID, and just a unique constraint on the short code and language fields. Again, one entry for each short code and language pair, with the translated description. The disadvantage of this is not having the primary key of the lookup table as the foreign key of the referencing table. For me once you have a database, there are other questions, like what are you storing in the database (user entries as opposed to programmer entered things like statuses)? Do those need to be translated? If they do, then you've got a whole different set of problems, but assuming they don't, then you only have to translate the scaffolding stuff. I'd want to keep the translation of database stuff in the database. At least then it's easier to update if you ever do need to make changes. Just add a status, and add all the translations for it. Otherwise, if it's an enum, and then the translations are in the frontend, you need to not only update the database structure to add an enum, you also need to update all the frontends to have the new translation (even if that doesn't actually require a recompile). [snip] -- 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] Error
At 22:46 12/08/2014 +0200, Skiper Skippers wrote: Error Check =2^53 it shows 9007199254740990 This is not an error! You are using a finite computing machine - one in which each number in a cell is stored in a memory location of finite length. So there is always a limit to how large an integer can be stored and to how great a precision a floating-point value can be stored. Your computer is probably using double-precision binary floating-point format, in which numbers are stored in eight-byte (sixty-four-bit) words. This allows around fifty-three significant binary digits, the rest being taken up by the sign and exponent. This level of precision corresponds to between fifteen and sixteen significant decimal digits, so integers can be stored precisely only up to this length of number, above which values can be stored, but only to around fifteen significant digits. 2^53 is one followed by fifty-three zeroes, of course - so is just too long to be stored accurately. You are very unlikely to need numbers of this magnitude as final results, and if you come across this problem, you can usually find a simple way to reorganise your calculation to avoid the problem. Note that the (biased) exponent is stored in an eleven-bit field, so a separate problem occurs if you try to calculate with numbers above about 2^1023. For a fuller explanation, see http://en.wikipedia.org/wiki/Double-precision_floating-point_format . 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
[libreoffice-users] Re: Error
skiper skippers wrote blockquote {padding-left: 1ex; margin: 0px 0px 0px 0.8ex; border-left: #cc 1px solid;} p {margin: 0px;padding: 0px;} Check =2^53 it shows 9007199254740990 FYI MS Excel returns the same value. If you need accuracy then use Gnumeric or R For those who can't spot the error, the result should be 9007199254740992 :) -- View this message in context: http://nabble.documentfoundation.org/Error-tp4118786p4118796.html Sent from the Users mailing list archive at Nabble.com. -- 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