Re: [libreoffice-users] Base, connect to map/grid ?
MySQL comes with mapping capabilities, I believe. There is, or used to be, a large section in its manual about how that works. I don't know how it works because I've never taken the time to read those sections, but it might give you an idea on how to implement something. Regards Mark -- 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] LO 4.4 is supposed to import Pagemaker files? How?
I was all excited by the recent announcement that LO can open a number of older Mac file formats and Pagemaker files. I am running the Mac 64 bit version of LO 4.4. (OSX 10.9.5) So I wanted to finally convert a number of older Pagemaker 6.5 files to something useable. I searched the docs and searched this list to find instructions of converting these files. All I can find is that you should import the Pagemaker files. There is no import command that I can find. Where is this? I tried to open the Pagemaker 6.5 files directly but get General Error. General Input / Output error. So how are you supposed to open Pagemaker files? Please not that I'm on digest. If you wouldn't mind cc'ing me directly when / if you reply to the list. Thanks in advance, B. -- 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: LO 4.4 is supposed to import Pagemaker files? How?
On Thu, 14 May 2015 18:21:18 +0200 Andreas Säger ville...@t-online.de wrote: Hello Andreas, Am 14.05.2015 um 16:09 schrieb bunk3m: I tried to open the Pagemaker 6.5 files directly but get General Error. General Input / Output error. [cut] Open such file with LibreOffice exactly like you would open any other file with any other program. Unless I've misunderstood what bunk3m wrote, that resulted in a General I/O error. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent I guess I shouldn't have strangled her to death Ugly - The Stranglers -- 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: LO 4.4 is supposed to import Pagemaker files? How?
Am 14.05.2015 um 19:18 schrieb Brad Rogers: Unless I've misunderstood what bunk3m wrote, that resulted in a General I/O error. Ooops. Then LibreOffice can not open that file because the file is not a pagemaker file, a corrupted pagemaker file or an unsupported pagemaker file. Try http://www.zamzar.com or find some machine with pagemaker up and running and let it export your files to whatever suitable. -- 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: LO 4.4 is supposed to import Pagemaker files? How?
Am 14.05.2015 um 16:09 schrieb bunk3m: I was all excited by the recent announcement that LO can open a number of older Mac file formats and Pagemaker files. I am running the Mac 64 bit version of LO 4.4. (OSX 10.9.5) So I wanted to finally convert a number of older Pagemaker 6.5 files to something useable. I searched the docs and searched this list to find instructions of converting these files. All I can find is that you should import the Pagemaker files. There is no import command that I can find. Where is this? I tried to open the Pagemaker 6.5 files directly but get General Error. General Input / Output error. So how are you supposed to open Pagemaker files? Please not that I'm on digest. If you wouldn't mind cc'ing me directly when / if you reply to the list. Thanks in advance, B. Open such file with LibreOffice exactly like you would open any other file with any other program. -- 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] Can't change font color in LO 4.[4].3 (Linux)
At 11:19 15/05/2015 +0800, Min Hsien wrote: I found I can not change font color in LO 4.[4].3 under Linux. The procedure is: (1) Open Writer or Calc. (2) Type some words in Writer or Calc. (3) Select the words and change the color of words. (4) Writer still not change it. Do you perhaps inadvertently have a tick in the option at Tools | Options... | LibreOffice | Accessibility | Options for high-contrast appearance | Use automatic font colour for screen display? If so, the text will remain in a high-contrast colour - black if the background is light - in the normal editing display, but will nevertheless be marked as the chosen colour and will still print or export as PDF correctly. If you also have Use system colours for page previews ticked, Page Preview will also be affected; otherwise Page Preview will show the correct colour. 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
Re: [libreoffice-users] how to make formulas permanently case sensitive?
At 20:32 12/05/2015 +0200, Honly Wonly wrote: Am 12.05.2015 um 19:53 schrieb Brian Barker: At 12:45 12/05/2015 +0200, Honly Wonly wrote: I need, of course, formulas to be case sensitive. This can be set in the options for calc. The option is not saved permanently and every time I open a spreadsheet, I need to set the option again. I'm surprised by that. If you mean the options at Tools | Options... | LibreOffice Calc | Calculate | Case sensitive, doesn't this apply per user and thus stick not only between documents but between LibreOffice sessions? No, this option is not remembered. I've done some research, and the setting is stored in registrymodifications.xcu in the profile. So yes: it *will* be saved per user, not per document or per system, and will stick across LibreOffice sessions. (But perhaps not, as I suggested, if you have a corrupt profile.) How can I save this option permanently so I don't need to set it over and over again? If it doesn't stick - and if this option is, as I imagine, saved in the user profile - you might want to wonder if your user profile has become corrupt. If you close LibreOffice and delete or rename the profile, LibreOffice will create a new, clean one next time you start it. If you then set the option again, does it now stick? I have seen this on different computers, with both the Linux and the [Windows] version of LO. If you use different systems, the setting would need to be made in your profile separately on each, of course. At 12:55 12/05/2015 +0200, Honly Wonly wrote: To clarify: I need the string comparisons of IF() to be case sensitive: 'if(a1 = x; ...)' is, of course, different from 'if(a1 = X; ...)'. Why would anyone make them not case sensitive unless explicitly specified, ... I suspect those who prefer the other option would ask the opposite question! Things are usually case sensitive, unless you specify otherwise. It is what I expect. I'm sorry you missed my point. I understood what you wanted. Anyone reading your enquiry will have understood what you wanted. My point was that others might prefer the existing arrangement. I think others should be given consideration. If you are looking for references to dogs, you might want to find Dogs are friendly pets as well as My dog's got no nose. I don't like dogs ... Did you imagine I was writing for your benefit alone? There are plenty of dog-lovers on the list. ... and how do I specify case sensitiveness per formula? If the option is, as I suspect, per user, your spreadsheet will go wrong if you need to change the option for another document, if a different user handles it on the same computer, or if you exchange it with someone using a different computer. I haven't tried with different users. Actually, it appears you have. You say you have experience of this matter on different operating systems. Even though you are the same person on each, you will be separate users and have separate profiles on the different systems. It is precisely because you may want to move documents in this way that it is far better to control what happens in your formulae and not to rely on option settings. So you are quite right to identify that building the requirement into your formulae and not relying on options is the reliable way to go. And it's quite easy: the EXACT() function comes to your aid. Instead of using =IF(A1=X;...) use =IF(EXACT(A1;X);...) This will match X but not x irrespective of the option setting. Thank you, maybe that works; I'll try it tomorrow. Oh, it does work for others. I'm not sure how your use if it downgrades this to maybe. 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] Can't change font color in LO 4.3.3 (Linux)
Hi~ I found I can not change font color in LO 4.3.3 under Linux. The procedure is: (1) Open Writer or Calc. (2) Type some words in Writer or Calc. (3) Select the words and chage the color of words. (4) Writer still not chage it. Anybody has the same problem under Linux? 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
Re: [libreoffice-users] Can't change font color in LO 4.4.3 (Linux)
Sorry! The problem was in version 4.4.3, but not 4.3.3! Let me modify the title to 4.4.3 2015-05-15 11:19 GMT+08:00 minhsien0330 minhsien0...@gmail.com: Hi~ I found I can not change font color in LO 4.3.3 under Linux. The procedure is: (1) Open Writer or Calc. (2) Type some words in Writer or Calc. (3) Select the words and chage the color of words. (4) Writer still not chage it. Anybody has the same problem under Linux? 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
Re: [libreoffice-users] Can't change font color in LO 4.3.3 (Linux)
No problem with 4.4.2.2 on Fedora, not back leveling to test. Are you using the standard version or a distribution specific version? On 05/14/2015 11:19 PM, minhsien0330 wrote: Hi~ I found I can not change font color in LO 4.3.3 under Linux. The procedure is: (1) Open Writer or Calc. (2) Type some words in Writer or Calc. (3) Select the words and chage the color of words. (4) Writer still not chage it. Anybody has the same problem under Linux? Thanks -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] Can't change font color in LO 4.4.3 (Linux)
Sorry, I should modify the title, because this problem occurs in version 4.4.3, but not 4.3.3. And I downloaded 4.4.3 from http://www.libreoffice.org/ My OS is Debian. Have you tested in 4.4.3 ? Thanks~ 2015-05-15 11:30 GMT+08:00 Andrew Douglas Pitonyak and...@pitonyak.org: No problem with 4.4.2.2 on Fedora, not back leveling to test. Are you using the standard version or a distribution specific version? On 05/14/2015 11:19 PM, minhsien0330 wrote: Hi~ I found I can not change font color in LO 4.3.3 under Linux. The procedure is: (1) Open Writer or Calc. (2) Type some words in Writer or Calc. (3) Select the words and chage the color of words. (4) Writer still not chage it. Anybody has the same problem under Linux? Thanks -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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