Re: [libreoffice-users] shortcut keys for LibreOffice under Linux
(2014/08/14 12:39), Tim Lloyd wrote: I downloaded Mint 17 which is running LO 4.2.3.3. I looked in writer and calc where F5 and F11 were behaving as normal (navigator & styles and formatting). I have noted though that behaviour is not consistent across the distros you have tested which may point at Mint. I can't for the life of me think why though! I was one of the respondents to your post on linuxquestions. A suggestion...let's give it another day for responses to filter through there. If nothing useful comes out, how about asking the linuxquestions admin people to move the post to the mint forum? I think reps of the distro hang around at that forum so may be able to advise one way or the other. Cheers On 14/08/14 12:31, Thomas Blasejewicz wrote: (2014/08/14 10:55), Paul wrote: Hi Thomas, Paul I also thought about that already, although I have currently no idea how to change that keyboard behavior. BUT ... if that were true ..would / should LibreOffice not behave in the same way under Ubuntu (Unity desktop), Xubuntu (XFCE) and Mint (Cinnamon)? If I revall correctly (this is an old PC of my daugther), I borrowed it a few years back when I had to spend a week away from home. At that time the PC was running Windows Vista and I used LibreOffice in that environment, but do not remember any such behavior ... Thank you all! By now I figured out, that you have to combine EVERY function key with the Fn key. If you do so, it works. Have not yet tested all possible combinations. This is not perfect, but I will still with this, and not go back to Unity. -- 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
Le 14/08/2014 04:31, Thomas Blasejewicz a écrit : > I also thought about that already, although I have currently no idea how > to change that keyboard behavior. > BUT ... if that were true ..would / should LibreOffice not behave in the > same way under Ubuntu (Unity desktop), Xubuntu (XFCE) and Mint (Cinnamon)? > it depends. It's a hardware question and the interpretation of the F5 key for brightness management is up to a special driver which the maker provides, or not. On my Thinkpad and under Debian Wheezy, all special keys are working. When I tested earlier versions of otker distos this wasn't the case. > If I revall correctly (this is an old PC of my daugther), I borrowed it > a few years back when I had to spend a week away from home. > At that time the PC was running Windows Vista and I used LibreOffice in > that environment, but do not remember any such behavior ... > > Usually nowadays, laptops have a "Fn" labelled key (lower left part of the keyboard) that allows switching from Special functions keys (brightness, volume, etc.) to normal function keys. On my Thinkpad, the default behaviour is special functions keys. To get the normal function keys I'd have to press the + combination which I found annoying. Fortunately, this behaviour may be toggled in the Thinkpad BIOS, which I did. Now, pressing a function key alone gives me the normal function result and to get any of the extended functionalities I have to press the + combination. -- Jean-Francois Nifenecker, Bordeaux -- 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
I downloaded Mint 17 which is running LO 4.2.3.3. I looked in writer and calc where F5 and F11 were behaving as normal (navigator & styles and formatting). I have noted though that behaviour is not consistent across the distros you have tested which may point at Mint. I can't for the life of me think why though! I was one of the respondents to your post on linuxquestions. A suggestion...let's give it another day for responses to filter through there. If nothing useful comes out, how about asking the linuxquestions admin people to move the post to the mint forum? I think reps of the distro hang around at that forum so may be able to advise one way or the other. Cheers On 14/08/14 12:31, Thomas Blasejewicz wrote: (2014/08/14 10:55), Paul wrote: Hi Thomas, On Thu, 14 Aug 2014 10:00:15 +0900 Thomas Blasejewicz wrote: And the "customize" function DOES NOT work. I tried that already. For example, LibreOffice comes with a lot of presets. One is "Navigator", that is assigned to F5 under Windows and Ubuntu. Clicking on the ICON WILL call up the Navigator. But ... the key = F5 does not. It shows brightness adjustment on my Dell Inspiron 1545. I'm not sure, but this sounds like the laptop is not interpreting the key as an F5 keypress, but as the brightness control keypress. If that's right, this is not a problem with LibreOffice, more a case of the laptop not doing what you expect. I don't know the particular model, but I think it's fairly common for laptops to use some of the function keys to do stuff like that. Often you need to press a button to toggle the mode between function key mode and laptop function mode. Could the problem be something like this? Just a guess. Paul I also thought about that already, although I have currently no idea how to change that keyboard behavior. BUT ... if that were true ..would / should LibreOffice not behave in the same way under Ubuntu (Unity desktop), Xubuntu (XFCE) and Mint (Cinnamon)? If I revall correctly (this is an old PC of my daugther), I borrowed it a few years back when I had to spend a week away from home. At that time the PC was running Windows Vista and I used LibreOffice in that environment, but do not remember any such behavior ... -- 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/14 10:55), Paul wrote: Hi Thomas, On Thu, 14 Aug 2014 10:00:15 +0900 Thomas Blasejewicz wrote: And the "customize" function DOES NOT work. I tried that already. For example, LibreOffice comes with a lot of presets. One is "Navigator", that is assigned to F5 under Windows and Ubuntu. Clicking on the ICON WILL call up the Navigator. But ... the key = F5 does not. It shows brightness adjustment on my Dell Inspiron 1545. I'm not sure, but this sounds like the laptop is not interpreting the key as an F5 keypress, but as the brightness control keypress. If that's right, this is not a problem with LibreOffice, more a case of the laptop not doing what you expect. I don't know the particular model, but I think it's fairly common for laptops to use some of the function keys to do stuff like that. Often you need to press a button to toggle the mode between function key mode and laptop function mode. Could the problem be something like this? Just a guess. Paul I also thought about that already, although I have currently no idea how to change that keyboard behavior. BUT ... if that were true ..would / should LibreOffice not behave in the same way under Ubuntu (Unity desktop), Xubuntu (XFCE) and Mint (Cinnamon)? If I revall correctly (this is an old PC of my daugther), I borrowed it a few years back when I had to spend a week away from home. At that time the PC was running Windows Vista and I used LibreOffice in that environment, but do not remember any such behavior ... -- 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 Thomas, On Thu, 14 Aug 2014 10:00:15 +0900 Thomas Blasejewicz wrote: > And the "customize" function DOES NOT work. I tried that already. > For example, LibreOffice comes with a lot of presets. One is > "Navigator", that is assigned to F5 under Windows and Ubuntu. > Clicking on the ICON WILL call up the Navigator. > But ... the key = F5 does not. It shows brightness adjustment on my > Dell Inspiron 1545. I'm not sure, but this sounds like the laptop is not interpreting the key as an F5 keypress, but as the brightness control keypress. If that's right, this is not a problem with LibreOffice, more a case of the laptop not doing what you expect. I don't know the particular model, but I think it's fairly common for laptops to use some of the function keys to do stuff like that. Often you need to press a button to toggle the mode between function key mode and laptop function mode. Could the problem be something like this? Just a guess. Paul -- 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/14 10:20), Tim Lloyd wrote: Hi Thomas, You just ran with the version of LO which came with Mint? Sorry for all the questions, I just want to make sure it is the Mint spin (which I have got). Cheers I believe it is the newest: 4.2.4.2 -- 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 Thomas, I just installed Mint/Cinnamon as a VM under my Fedora desktop. I'll have a play around later. You just ran with the version of LO which came with Mint? Sorry for all the questions, I just want to make sure it is the Mint spin (which I have got). Cheers On 14/08/14 11:00, Thomas Blasejewicz wrote: (2014/08/13 23:26), Tom Davies wrote: Hi :) It's not clear which DE is being used in Mint. It is Mint 17 Cinnamon. (File) Tools / Customise - Keyboard tab, will let you look at all the I tried that ... And the "customize" function DOES NOT work. I tried that already. For example, LibreOffice comes with a lot of presets. One is "Navigator", that is assigned to F5 under Windows and Ubuntu. Clicking on the ICON WILL call up the Navigator. But ... the key = F5 does not. It shows brightness adjustment on my Dell Inspiron 1545. NExt I also tried: Delete the key assignment -> reassign to F5 "Navigator". No response. And that goes for all the other keys I tried too. Yet, I am using LibreOffice for work every day. Having thrown this kind of wrench into my engine is not really acceptable, although I like Mint much better than Ubuntu. keyboard shortcuts and change them. The ".config/libreoffice" hidden folder is where such things are saved. I do not know which config file stores the keyboard commands you use to use. I tried to find that file (even though I would not know what to do with it ...) -> the computer says there is not such file. Could there maybe a trick like copying such a configuration file from "somewhere" in Windows or Ubunto to somewhere in Mint?? -- 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/13 23:26), Tom Davies wrote: Hi :) It's not clear which DE is being used in Mint. It is Mint 17 Cinnamon. (File) Tools / Customise - Keyboard tab, will let you look at all the I tried that ... And the "customize" function DOES NOT work. I tried that already. For example, LibreOffice comes with a lot of presets. One is "Navigator", that is assigned to F5 under Windows and Ubuntu. Clicking on the ICON WILL call up the Navigator. But ... the key = F5 does not. It shows brightness adjustment on my Dell Inspiron 1545. NExt I also tried: Delete the key assignment -> reassign to F5 "Navigator". No response. And that goes for all the other keys I tried too. Yet, I am using LibreOffice for work every day. Having thrown this kind of wrench into my engine is not really acceptable, although I like Mint much better than Ubuntu. keyboard shortcuts and change them. The ".config/libreoffice" hidden folder is where such things are saved. I do not know which config file stores the keyboard commands you use to use. I tried to find that file (even though I would not know what to do with it ...) -> the computer says there is not such file. Could there maybe a trick like copying such a configuration file from "somewhere" in Windows or Ubunto to somewhere in Mint?? -- 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] Numbering/Outline levels in Writer
Well, I do it using a List style. Regards On Wed, Aug 13, 2014 at 4:07 PM, dave boland wrote: > Writer used to allow this from a slection in Outline > 1.0 Head 1 > 1.1 Head 2 > 1.2 Head 2 > 1.2.1 Head 3 > 2.0 Head 1 > > Can't find how to do it in 4.1.3.2 Any ideas? > > Dave, > -- > dave boland > dbola...@fastmail.fm > > -- > http://www.fastmail.fm - Same, same, but different... > > > -- > 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 > > -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- 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: Currently Using Spreadsheet for Personal Project - Thinking About Database
Hi :) There is a separate mailing list which might be able to offer suggestions. Our mailing list for international translators and co-ordinating between the different languages is l...@global.libreoffice.org (lower and upper-case don't matter = it's just to help human readers make more sense of it) Regards from Tom :) On 13 August 2014 07:09, Werner wrote: > Hi, > > On 8/13/2014 1:18, Paul wrote: > >> Hi Mark, >> > > ... > > >> 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. >> >> I18N (Internationalizing) for user interface labels is relatively easily > done in most languages, one way is to use gettext which is supported by a > lot of programming languages. > > Doing I18N for database tables is another story, a few years ago I looked > around for support of I18N support for database tables and at the time I > didn't find any, have you found one? The storing of the I18N data is > relatively easy, but how to access that from the application depending on > user login in and how to fall back to a base language in case a value is > not translated is not that easy (at least in my view:)). > > > Werner > > > > -- > 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] Error at the time of auto saving process.
Hi :) Errr, all i can suggest is to switch off the auto-save as it can be annoying anyway. However that does mean you'll have to remember to save often and frequently (but at times to suit yourself rather than suddenly stopping you doing things at awkward moments). Tools - Options - "Load/Save" - General Regards from Tom :) On 13 August 2014 14:56, Farhad Ahmad wrote: > Dear sir > > I was doing work on Libre office for page crop and contras like edit of a > PDF book made from scanned image, at the time of auto saving process the > software uses to stop working, it saved the file and after some page there > was just a small icon instead of the original page. Pls help me to get rid > of the problem. > > Regard > > Farhad Ahmad > CPS International > www.cpsglobal.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 > -- 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 :) We all get all the mails sent to the mailing list. So we all got all 3 replies. There is a bit of clumsiness about it but 3 mails to the list is one of the best ways of handling it. On some other mailing lists, particularly the weekly DW "Readers Comments" one, i have seen people send a single response and then have different parts such as @ Pedro, Thanks for the info @ Tom, my dad did the right thing rather than being too inventive @ Brian, thanks, will try that. Sorry for the delay @ all he was on AOO 4.0.1 until i upgraded him to LO 4.1.0 It kinda works quite well too but many on this mailing list are likely to be new or else have even more sophisticated methods. I quite like the simplicity of the above method. Regards from Tom :) On 13 August 2014 14:27, Tom Williams wrote: > On 08/12/2014 08:44 AM, Pedro 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...) > > Thanks for the info. Before I got involved, my dad used OpenOffice > exclusively.I had him install version 4.0.1 because that was the > version he had been previously running, before I upgraded to 4.1.0. :) > > Thanks! > > 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] Text Orientation
At 16:21 13/08/2014 -0400, Pikov Andropov wrote: I want to create a document of a layout of a bridge table. It should have the words, "NORTH", "EAST", "SOUTH" and "WEST" on the four edges, each facing outward. One way to do this is to use a text box: o Go to View | Toolbars > | Drawing, to display the Drawing toolbar at the foot of the window. o Click the Text icon ("T") and drag a rectangular box in the document. o Enter and style the required text. o Click the text box to select it - so that it shows the coloured border and the eight coloured handles. o Right-click the box and go to Position and Size... | Rotation | Rotation angle | Angle to set the orientation. o Copy and paste the result to form the other necessary boxes. Note that the copies will appear on top of the originals, so you will not see the result of the Paste until you drag them to a new position. 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] Text Orientation
I want to create a document of a layout of a bridge table. It should have the words, "NORTH", "EAST", "SOUTH" and "WEST" on the four edges, each facing outward. That is, when printed and placed in the center of a bridge table, each player will have one such word facing him. How do I do that? Thanks. -- 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] Numbering/Outline levels in Writer
Writer used to allow this from a slection in Outline 1.0 Head 1 1.1 Head 2 1.2 Head 2 1.2.1 Head 3 2.0 Head 1 Can't find how to do it in 4.1.3.2 Any ideas? Dave, -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Same, same, but different... -- 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: Currently Using Spreadsheet for Personal Project - Thinking About Database
Hi Werner, On Wed, 13 Aug 2014 08:09:31 +0200 Werner wrote: > Hi, > > On 8/13/2014 1:18, Paul wrote: > > Hi Mark, > > ... > > > > 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. > > > I18N (Internationalizing) for user interface labels is relatively > easily done in most languages, one way is to use gettext which is > supported by a lot of programming languages. > > Doing I18N for database tables is another story, a few years ago I > looked around for support of I18N support for database tables and at > the time I didn't find any, have you found one? The storing of the > I18N data is relatively easy, but how to access that from the > application depending on user login in and how to fall back to a base > language in case a value is not translated is not that easy (at least > in my view:)). I don't know of any frameworks for I18N in databases, although I'm not sure of the level of support in things like Django, CakePHP and other web frameworks. From what my brief research has shown, most of them do have some level of support. Possibly the best support I saw was in Propel, a PHP ORM. http://propelorm.org/blog/2011/01/11/propel-gets-i18n-behavior-and-why-it-matters.html Also, these articles discuss the actual database design and present different standard options: http://www.codeproject.com/Articles/8084/Creating-multilingual-websites-Part#databasedesign http://www.apphp.com/tutorials/index.php?page=multilanguage-database-design-in-mysql Storing the data with a good structure makes the queries only a little harder, usually one extra join, although that doesn't take into account fallback language. The Propel behaviour seems quite sensible to me. If you aren't going to use an ORM, I would suggest at least making a wrapper in your code to manipulate queries and add the extra join, so for the rest of the code you don't have to worry about that detail, and just do queries as normal. If you need a default language, I would probably keep the default language values in the original table, and just store translations in a translation table. Then you can have the wrapper detect if the current locale is the default language, and do nothing in those cases. If the locale is different, then get both the field from the original table and the translation, and have the wrapper pick up if the translation is blank, then substitute the default value, and write to whatever logging system you are using noting the incomplete translation. Just my thoughts. Googling brought up quite a few other links, mostly to StackOverflow, and the discussions gave more options and further reading. Paul -- 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] Dialog?
Using LibreOffice 3.5.7.2 on Ubuntu 12.04 if it makes any difference. I am designing a dialog that will be opened by a macro, accept some data and then place the data in the proper cells of a Calc sheet. The data will consist of text, numbers and dates. In the dialog design environment I see there are text fields, numeric fields and date fields available. Is there any advantage to using the various types of fields other than the date field will only accept date formats and the numeric field will only accept digits? Will using them possibly keep me from having to write conversion routines when putting date data in date formated cells or numeric data in numeric formated cells? Thanks, Jim -- 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 :) It's not clear which DE is being used in Mint. I'm guessing it's the "default one" but i'm not sure which that is. Mint seems to make it easy to choose which DE, so it might still be Xfce on Mint but my guess is it's more likely to be a Gnomeish one like Mate or Cinamon (or Gnome itself!). Regards from Tom :) On 13 August 2014 14:48, Tim---Kracked_P_P---webmaster < webmas...@krackedpress.com> wrote: > On 08/13/2014 08:24 AM, Thomas Blasejewicz wrote: > >> (2014/08/11 11:53), T. R. Valentine wrote: >> >>> On 10 August 2014 21:13, Thomas wrote: >>> Good morning AFAIK, F11 brings up the Styles menu on both Ubuntu & Mint. >>> No. I just made a clean install of Mint 17. >> Only Fn+F11 works >> All the other key commands are apparently the same as they are under XFCE >> From my first impression I would say, I like Mint better than XFCE. / >> >> BUT at the same time would love to be able to use all the shortcut >> keys I am used to. >> >> (File) Tools / Customise - Keyboard tab, will let you look at all the >>> keyboard shortcuts and change them. >>> >> Yes, I know. >> What I would like to know is: is there a way of installing/importing ALL >> the shortcut key settings together? >> Probably not. >> >> Thomas >> >> >> > The ".config/libreoffice" hidden folder is where such things are saved. > I do not know which config file stores the keyboard commands you use to > use. > > by-the-by > I cannot go from Mint 16 to 17 [MATE] due to printer dependency issues. 2 > of the Canon PIXMA inkjet printers I have will not install properly due to > needed dependencies that Mint 17 and/or Ubuntu 14.04 upgraded and the > printer install files will not use the "version 5 update" since they > "require" version 4 - which the number "4" is part of the dependency's name. > > > -- > 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] Error
Hi :) There are only 10 types of people in the world Those who think in binary, and those who don't (err and a bit of a grey area where logic gates might or might not have been triggered so i guess that makes 11 types of people) Sorry! I know it's not a good joke so it's great to have the opportunity to retell it! Thanks and regards from Tom :) On 13 August 2014 12:38, Keith Bates wrote: > Of course! I don't think binary! > > Keith > > On Wed, 13 Aug 2014 09:42:12 +0100 > Brian Barker wrote: > > > At 15:55 13/08/2014 +1000, Keith Bates wrote: > > >While I agree with most of your post, a slight typo or something > > >crept in here, where you confuse 10^53 with 2^53 > > > > > >>2^53 is one followed by fifty-three zeroes, of course - so is just > > >>too long to be stored accurately. > > > > I wasn't clear - but not in the way you thought! I meant that 2^53 is > > represented *in binary* (as it will be in the computer) as one > > followed by fifty-three zeroes, of course. So it's the value that is > > just too large to be stored accurately in double precision. (As so > > often happens, I spotted that omission just after I had sent the > > message!) > > > > Brian Barker > > > > > > > > -- > God bless you > Keith Bates > > Jesus is the Way, > the Truth and the Life. > Follow Him. > > -- > 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] Error at the time of auto saving process.
Dear sir I was doing work on Libre office for page crop and contras like edit of a PDF book made from scanned image, at the time of auto saving process the software uses to stop working, it saved the file and after some page there was just a small icon instead of the original page. Pls help me to get rid of the problem. Regard Farhad Ahmad CPS International www.cpsglobal.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] shortcut keys for LibreOffice under Linux
On 08/13/2014 08:24 AM, Thomas Blasejewicz wrote: (2014/08/11 11:53), T. R. Valentine wrote: On 10 August 2014 21:13, Thomas wrote: Good morning AFAIK, F11 brings up the Styles menu on both Ubuntu & Mint. No. I just made a clean install of Mint 17. Only Fn+F11 works All the other key commands are apparently the same as they are under XFCE From my first impression I would say, I like Mint better than XFCE. / BUT at the same time would love to be able to use all the shortcut keys I am used to. (File) Tools / Customise - Keyboard tab, will let you look at all the keyboard shortcuts and change them. Yes, I know. What I would like to know is: is there a way of installing/importing ALL the shortcut key settings together? Probably not. Thomas The ".config/libreoffice" hidden folder is where such things are saved. I do not know which config file stores the keyboard commands you use to use. by-the-by I cannot go from Mint 16 to 17 [MATE] due to printer dependency issues. 2 of the Canon PIXMA inkjet printers I have will not install properly due to needed dependencies that Mint 17 and/or Ubuntu 14.04 upgraded and the printer install files will not use the "version 5 update" since they "require" version 4 - which the number "4" is part of the dependency's name. -- 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 :) There might be but i don't know of it. It might be worth asking in the generic http://www.linuxquestions.org forum because that forum covers many different distros so people might have run into the issue before or might find it an interesting new challenge. Also i find it can be good to ask at DW http://distrowatch.com has a regular weekly article/magazine and under it has "Readers Comments". It's just 1 thread per week and starts with a new thread the next week. One advantage is it's the only place you don't have to register for. Just post a comment and see if people respond. Back when i was a regular they used to go way off-topic and a question such as yours pulls them back to something vaguely relevant for a bit, sometimes. Also might be worth asking in the Xfce or specific distro forums. The Mint forums might be good. As a gateway or introductory distro they are probably not so familiar with people "distro hopping" (except from Ubuntu). It's likely to be a refreshing change for them! :) if you start to get answers it'd be great if you can give us a link so we can learn a bit too. Regards from Tom :) On 13 August 2014 13:24, Thomas Blasejewicz wrote: > (2014/08/11 11:53), T. R. Valentine wrote: > >> On 10 August 2014 21:13, Thomas wrote: >> >>> Good morning >>> AFAIK, F11 brings up the Styles menu on both Ubuntu & Mint. >>> >> No. I just made a clean install of Mint 17. > Only Fn+F11 works > All the other key commands are apparently the same as they are under XFCE > From my first impression I would say, I like Mint better than XFCE. > BUT at the same time would love to be able to use all the shortcut > keys I am used to. > > (File) Tools / Customise - Keyboard tab, will let you look at all the >> keyboard shortcuts and change them. >> > Yes, I know. > What I would like to know is: is there a way of installing/importing ALL > the shortcut key settings together? > Probably not. > > Thomas > > > > -- > 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] Re: Question about Calc and hiding rows
On 08/12/2014 08:44 AM, Pedro 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...) Thanks for the info. Before I got involved, my dad used OpenOffice exclusively.I had him install version 4.0.1 because that was the version he had been previously running, before I upgraded to 4.1.0. :) Thanks! 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: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 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 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: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 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/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] shortcut keys for LibreOffice under Linux
(2014/08/11 11:53), T. R. Valentine wrote: On 10 August 2014 21:13, Thomas wrote: Good morning AFAIK, F11 brings up the Styles menu on both Ubuntu & Mint. No. I just made a clean install of Mint 17. Only Fn+F11 works All the other key commands are apparently the same as they are under XFCE From my first impression I would say, I like Mint better than XFCE. BUT at the same time would love to be able to use all the shortcut keys I am used to. (File) Tools / Customise - Keyboard tab, will let you look at all the keyboard shortcuts and change them. Yes, I know. What I would like to know is: is there a way of installing/importing ALL the shortcut key settings together? Probably not. Thomas -- 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: Converting Microsoft Access to Libre Base
On 8/13/2014 13:47, Tom Davies wrote: Hi :) Ahh, i take it that "View" is the new name for "Queries"? I don't think so, at least not in SQL terms. http://www.w3schools.com/sql/sql_view.asp http://en.wikipedia.org/wiki/SQL see Queries section Werner -- 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: Converting Microsoft Access to Libre Base
Hi :) Ahh, i take it that "View" is the new name for "Queries"? It is quite a good name for it. "Queries" had to be explained quite a bit although i thought it made more sense tbh. Open Source advocates and people who are helping organisations to move away from Microsoft lock-ins often give the surprising advice of keeping the MS systems in place! This helps the migration flow more smoothly because some of the lock-ins are difficult to escape. By keeping the old system available people find it easier to over-come some of the simpler hurdles without needing so much extensive and intensive retraining. Microsoft generally don't have a migration route for new products or newer versions of products. So people are forced into using the newer system. Open Source generally encourages migration instead of using the typical Microsoft route. They/we usually allow you to keep the older system alongside the newer one. So normal users can keep going back to using the older, more familiar tools when they really need to but tend to move to the newer system because it's better and does more. A few people need a bit of a push so it's a good idea to set a deadline. People often resent being forced into using the newer system. For some reason when the newer system is a Microsoft one it is often the user that gets the blame or is made to look or feel like a foolish fuddy-duddy. When the newer system is anything other than Microsoft people are generally encouraged to blame the software. So, in this case i would keep the existing Access database and existing copies of MS Office that are already installed. LibreOffice works well alongside MS Office. Sometimes, at an early stage of migration, some newer machines need the same version of MS Office to be installed but that fizzles out as more&more works more smoothly on LibreOffice/OpenOffice Regards from Tom :) On 13 August 2014 10:58, Alexander Thurgood wrote: > Le 13/08/2014 10:55, Peter Goggin a écrit : > > Hi Peter, > > > I cannot see how to transfer rhe MS Access to run uder LibreBase. I > > tried doing the conversion under XP by loading LibreOffice and then > > opening the Access data base using LibreBase. with the following results: > > All this does unfortunately, is link your ODB file to the MDB data source. > > > > > 1 All tables were successfully converted and retained their data. > > 2 All vies finished as being defined as tables. > > Yes, generally tables and views are converted to tables. > > > > 3 No forms were transferred. > > Forms, Queries and Reports have to be rebuilt. > > > > > > Is there an easy way to convert Access data bases to run under LibreBase? > > No, not without redoing much of the work that you did in Access to make > your db work for you in the way you wanted. > > > > > > Can I get the vies transferred as vies ? Do I need to extract the SQL > > for the vies and then recreate them in Libre Base. > > Export the View as SQL, and then create a new view in LibreOffice with > that SQL. > > > > > > If I cannot transfer the forms directly then I will need to recreate > > them. I have looked at how forms work in LibreBase butr I cannot find > > out how to create a menu form which allows the juser to select other > > menu forms or data entry forms. > > For that, you should try installing the Switchboard extension > (LibreOffice extensions website), to see if it meets your needs, or else > learn to manipulate UNO objects via one of the scripting languages that > LibreOffice supports. > > > > > > > Is there a reort system in Libre Base? > > Yes, it is called ReportBuilder, and is a Java-based subset of the > Pentaho reporting engine. You need a JVM/JRE in order to use it, and by > default on current Ubuntu installations, it is not installed (neither is > Base for that matter) with the default installation of LibreOffice. > > > Alex > > > -- > 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] Error
Of course! I don't think binary! Keith On Wed, 13 Aug 2014 09:42:12 +0100 Brian Barker wrote: > At 15:55 13/08/2014 +1000, Keith Bates wrote: > >While I agree with most of your post, a slight typo or something > >crept in here, where you confuse 10^53 with 2^53 > > > >>2^53 is one followed by fifty-three zeroes, of course - so is just > >>too long to be stored accurately. > > I wasn't clear - but not in the way you thought! I meant that 2^53 is > represented *in binary* (as it will be in the computer) as one > followed by fifty-three zeroes, of course. So it's the value that is > just too large to be stored accurately in double precision. (As so > often happens, I spotted that omission just after I had sent the > message!) > > Brian Barker > > -- God bless you Keith Bates Jesus is the Way, the Truth and the Life. Follow Him. -- 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: Converting Microsoft Access to Libre Base
Le 13/08/2014 10:55, Peter Goggin a écrit : Hi Peter, > I cannot see how to transfer rhe MS Access to run uder LibreBase. I > tried doing the conversion under XP by loading LibreOffice and then > opening the Access data base using LibreBase. with the following results: All this does unfortunately, is link your ODB file to the MDB data source. > > 1 All tables were successfully converted and retained their data. > 2 All vies finished as being defined as tables. Yes, generally tables and views are converted to tables. > 3 No forms were transferred. Forms, Queries and Reports have to be rebuilt. > > Is there an easy way to convert Access data bases to run under LibreBase? No, not without redoing much of the work that you did in Access to make your db work for you in the way you wanted. > > Can I get the vies transferred as vies ? Do I need to extract the SQL > for the vies and then recreate them in Libre Base. Export the View as SQL, and then create a new view in LibreOffice with that SQL. > > If I cannot transfer the forms directly then I will need to recreate > them. I have looked at how forms work in LibreBase butr I cannot find > out how to create a menu form which allows the juser to select other > menu forms or data entry forms. For that, you should try installing the Switchboard extension (LibreOffice extensions website), to see if it meets your needs, or else learn to manipulate UNO objects via one of the scripting languages that LibreOffice supports. > > Is there a reort system in Libre Base? Yes, it is called ReportBuilder, and is a Java-based subset of the Pentaho reporting engine. You need a JVM/JRE in order to use it, and by default on current Ubuntu installations, it is not installed (neither is Base for that matter) with the default installation of LibreOffice. Alex -- 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] Converting Microsoft Access to Libre Base
I have a MS access data base running under XP. For various reasons I am converting my ;laptops to run Ubuntu with LibreOffice. I have successfully transfered Thunderbird e-mail from XP to Ubuntu. I am able to transfer and read MS Word and Excel files to run under LibreOffice under Ubuntiu. I cannot see how to transfer rhe MS Access to run uder LibreBase. I tried doing the conversion under XP by loading LibreOffice and then opening the Access data base using LibreBase. with the following results: 1 All tables were successfully converted and retained their data. 2 All vies finished as being defined as tables. 3 No forms were transferred. Is there an easy way to convert Access data bases to run under LibreBase? Can I get the vies transferred as vies ? Do I need to extract the SQL for the vies and then recreate them in Libre Base. If I cannot transfer the forms directly then I will need to recreate them. I have looked at how forms work in LibreBase butr I cannot find out how to create a menu form which allows the juser to select other menu forms or data entry forms. Is there a reort system in Libre Base? Any help will be gratefully accepted Regards Peter Goggin --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.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] Error
At 15:55 13/08/2014 +1000, Keith Bates wrote: While I agree with most of your post, a slight typo or something crept in here, where you confuse 10^53 with 2^53 2^53 is one followed by fifty-three zeroes, of course - so is just too long to be stored accurately. I wasn't clear - but not in the way you thought! I meant that 2^53 is represented *in binary* (as it will be in the computer) as one followed by fifty-three zeroes, of course. So it's the value that is just too large to be stored accurately in double precision. (As so often happens, I spotted that omission just after I had sent the message!) 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