Re: [libreoffice-users] Connecting LO Base to an SQL DB [SOLVED]
On Tue, Nov 6, 2012 at 2:41 AM, Ian Whitfield whitfi...@telkomsa.netwrote: Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!) You have all added some pieces to the Jigsaw and I'm pleased to say.. *I now have Base working with a MySQL Database (at last!!)* As Girvin would say My Bad!! I had been looking for the file 'my.cfg' when it should have been 'my.cnf'. This was the last missing piece, once I found it and found the skip-networking line inside it and commented it out everything worked fine. So once again guys - thanks for sticking with me - awesome support and I do appreciate it!! Now the fun starts - I have already designed my Form yesterday but now need to puzzle out how to get all my data out of the old DB into the new SQL DB. And then re-write all my Queries and reports. Greatly appreciated - regards from South Africa IanW Pretoria RSA. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted You are welcome Ian , glad you were able to get it resolved. -- -- Masekela Walls Web Security Analyst | Senior Server Administrator Powserve.com / Gemini ISP Networks -- For unsubscribe instructions e-mail to: users+h...@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] locked in other OS
Hi :) When i save a file onto my company's network and then reopen it (still in Ubuntu) it all works fine. When my boss opens the file in Windows an error-message pops-up saying that he can only open a copy or in Read-Only mode. It's closed on my machine but his one claims it's still open. Then my boss changes the name, edits the document, saves and closes. Then when i open the new version of the document it tells me i can only open in Read Only (or a copy)! It does have a slight advantage in that it forces my boss to effectively make backups and i am gradually encouraging a standard versioning system other than filename-draft.doc filename-final.doc filename-FINAL.doc filename-revised.doc filename-final.doc in roughly random order and sometimes without the filename part so folders end up full of documents that could be about anything. Draft does not always come first and may even be the final and revised might be a revised draft or just be a draft. Hence frequent shouts of so which one am i supposed to open?. It's slow going but at least we seem to make occasional steps forwards. So, i am not sure i really want to fix the problem but it's one of the excuses some of my colleagues use to revert to inferior products instead of going with LO. Regards from Tom :) -- For unsubscribe instructions e-mail to: users+h...@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 to .doc with background image?
I made a 'template' in LO for an A3 leaflet with a background image (page style) on the first page. No margins, but with boxes with text, table and images on top of it. Everything works fine in LO, and also if exported as PDF. But when saved as .doc the entire background image is gone. Any ideas about what happens? Can't you use background images in Word? So far the client has to use the pdf ... -- Sendt med Operas revolusjonerende e-postprogram: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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] LO to .doc with background image?
On 11/07/2012 10:00 AM, Bjørn K Nilssen wrote: I made a 'template' in LO for an A3 leaflet with a background image (page style) on the first page. No margins, but with boxes with text, table and images on top of it. Everything works fine in LO, and also if exported as PDF. But when saved as .doc the entire background image is gone. Any ideas about what happens? Can't you use background images in Word? So far the client has to use the pdf ... The problem is the same as it always has been: a file created by one program does not always look the same when viewed in another program. This has been known to happen even in different versions of Word. PDF was designed to prevent this problem, so I doubt that it is a matter of the client has to use ... but rather is a good choice. Specifically, Word uses background images in different way than LibreOffice. As a test, I opened an .odt file using Abiword which is suppose to use ODF formats. It had some graphics that Abiword rendered as small thumbnails. It had a numbered list that covered several paragraphs. Abiword put them into a single paragraph while wrapping text. --Dan -- For unsubscribe instructions e-mail to: users+h...@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] has anyone tried LO on Windows 8?
On Thu, 01 Nov 2012 09:41:29 +0100, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: I know that Windows 8 just came out, and a lot of people are waiting for their new Win8 systems to be delivered. The real question is has anyone tried LibreOffice on a Win8 machine? It works just fine, just like it used to do. I don't use any touch screen though, hence the new Start screen works just like an enhanced start button. I'm quite happy with the move to W8 so far :) With their new touch-optimized OS, and all of their changes to the way you use and access the apps on it, I was wondering how LibreOffice is running on this radically new environment. I was reading a set of articles about Windows 8 and the pros and cons of upgrading your current OS to it. There was talk on how some software had to be changed to deal with the formally known as Metro environment. There were many different opinions about what was going to be needed to be done to make current packages work properly with the new environment. So, has anyone out there tried Windows 8 and LO with it? Desktop version and touch screen laptop-style system? -- Sendt med Operas revolusjonerende e-postprogram: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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] missing file in libreoffice 3.6.3
Hi :) Please can you try downloading again from https://www.libreoffice.org/download/ Well, navigate from there to the right language for you. This link is to the next page, the one that lets you select which Operating System you are using. https://www.libreoffice.org/download/?nodetect Are you able to try this again or have you already tried a few times or do you have a download limit? Please let us know how this goes this time or if you have any trouble. Regards from Tom :) From: abdullah Al-Ammari أبو العباس future_m...@hotmail.com To: users@global.libreoffice.org Sent: Tuesday, 6 November 2012, 23:00 Subject: [libreoffice-users] missing file in libreoffice 3.6.3 إذا كانت رسائلي مصدر إزعاج لك سأعتبر إقرارك بذلك هو لطفاً منك ولن تصلك أياً منها بعد ذلك وتأكد بأنني سوف أكون متفهما لاستيائك ومثمناً لصراحتك لان ذلك من ابسط حقوقك وأما إذا أعجبتك فآمل مسح كامل عنواني البريدي قبل إرسالها لمن تحب If my messages are a source of discomfort to you, I will consider your declaration as a kindness from your part, and you will never receive anything thereafter. But make sure that I will understand your opinion and value your frankness because it is your simplest rights! dear admin, thank you and thanks for libreoffice teams that developing this program.however, I download libreoffice 3.6.3 in my fedora 17 - x64 but I found one file is missing libreoffice3.3-redhat-menus-3.3-1.noarch.rpm I tried to run libreoffice without it but it doesn't work. I follow the instructor I found in you www.libreoffice.org sincerely Abdullah Al-AmmariStudent @ King Fahd University -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Conditional formatting
Conditional formatting I have a grid of cells selected (approx 48 X 120) these cells have Conditional formatting set on them Enter a letter in any of the cells (say 'r' for red) and that cell will formate to red - I have 4 different colours I can set this up no problem and it works ok But when I reopen the spreadsheet the formatting towards the bottom of the grid does not work - just shows the inputted letters If I look at formatting Conditional formatting manage the 'range' has changed Think this is a bug as its only started since upgrading to new version - I've reported it as a bug I have deleted my user profile and let it recreate but that didn't fix looks like I'll have to install the previous version Unless anyone has any ideas how to fix - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Conditional-formatting-tp4017324.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] locked in other OS
On 2012-11-08 00:57, Tom Davies wrote: Hi :) When i save a file onto my company's network and then reopen it (still in Ubuntu) it all works fine. When my boss opens the file in Windows an error-message pops-up saying that he can only open a copy or in Read-Only mode. It's closed on my machine but his one claims it's still open. Then my boss changes the name, edits the document, saves and closes. Then when i open the new version of the document it tells me i can only open in Read Only (or a copy)! It does have a slight advantage in that it forces my boss to effectively make backups and i am gradually encouraging a standard versioning system other than filename-draft.doc filename-final.doc filename-FINAL.doc filename-revised.doc filename-final.doc in roughly random order and sometimes without the filename part so folders end up full of documents that could be about anything. Draft does not always come first and may even be the final and revised might be a revised draft or just be a draft. Hence frequent shouts of so which one am i supposed to open?. It's slow going but at least we seem to make occasional steps forwards. So, i am not sure i really want to fix the problem but it's one of the excuses some of my colleagues use to revert to inferior products instead of going with LO. Regards from Tom :) Hi. Are lock files left behind in the folder with the files you edit. I noticed yesterday that after working on a file on the server the lock file remained after I closed the file I was editing. .~lock.shearBeamDescription.odt# Steve -- For unsubscribe instructions e-mail to: users+h...@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] LO to .doc with background image?
At 16:00 07/11/2012 +0100, Bjørn K Nilssen wrote: I made a 'template' in LO for an A3 leaflet with a background image (page style) on the first page. No margins, but with boxes with text, table and images on top of it. Everything works fine in LO, and also if exported as PDF. But when saved as .doc the entire background image is gone. Any ideas about what happens? Can't you use background images in Word? So far the client has to use the pdf ... How have you determined that the background image has disappeared? Have you (or has your client) opened the .doc file in genuine Microsoft Word or in the freeware (Windows only) Word viewer? Or have you just reopened the .doc file in LibreOffice and found the background absent there? I think there may be circumstances where the .doc file does retain the background but this is not converted correctly when reopened in LibreOffice. Note also that the Background tab of the Page Style dialogue (where you selected the background graphic) has a Link box. If you tick this, the graphic is linked and not embedded, and there may be problems when you transfer the file to another file system - e.g. your client's - where the original image file does not exist separately at the same absolute file path. Try unticking that box. (But I'm not sure that will make any difference.) I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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] LO to .doc with background image?
On Wed, 07 Nov 2012 16:29:21 +0100, Dan Lewis elderdanle...@gmail.com wrote: On 11/07/2012 10:00 AM, Bjørn K Nilssen wrote: I made a 'template' in LO for an A3 leaflet with a background image (page style) on the first page. No margins, but with boxes with text, table and images on top of it. Everything works fine in LO, and also if exported as PDF. But when saved as .doc the entire background image is gone. Any ideas about what happens? Can't you use background images in Word? So far the client has to use the pdf ... The problem is the same as it always has been: a file created by one program does not always look the same when viewed in another program. This has been known to happen even in different versions of Word. PDF was designed to prevent this problem, so I doubt that it is a matter of the client has to use ... but rather is a good choice. They actually have Acrobat XI (or whatever it is called, as they wasn't sure what they had..), but they don't know how to use it. The idea was that they should be able to reuse the front/back background images, logo etc on all their leaflets. Specifically, Word uses background images in different way than LibreOffice. As a test, I opened an .odt file using Abiword which is suppose to use ODF formats. It had some graphics that Abiword rendered as small thumbnails. It had a numbered list that covered several paragraphs. Abiword put them into a single paragraph while wrapping text. Earlier this week I used Word for the first time in many years, and I must say that I do not think it has evolved in a good way. No wonder that so few of the .doc files I receive are using styles instead of directly formatted text. I never was a Word fan (I loved Ami Pro before Lotus destroyed it) , but I think it was better earlier. -- Sendt med Operas revolusjonerende e-postprogram: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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] LO to .doc with background image?
I'm not at all a fan of this lists unusual Reply-To usage :( --- Forwarded message --- From: Bjørn K Nilssen b...@bknilssen.no To: Brian Barker b.m.bar...@btinternet.com Cc: Subject: Re: [libreoffice-users] LO to .doc with background image? Date: Wed, 07 Nov 2012 21:28:00 +0100 On Wed, 07 Nov 2012 20:02:19 +0100, Brian Barker b.m.bar...@btinternet.com wrote: At 16:00 07/11/2012 +0100, Bjørn K Nilssen wrote: I made a 'template' in LO for an A3 leaflet with a background image (page style) on the first page. No margins, but with boxes with text, table and images on top of it. Everything works fine in LO, and also if exported as PDF. But when saved as .doc the entire background image is gone. Any ideas about what happens? Can't you use background images in Word? So far the client has to use the pdf ... How have you determined that the background image has disappeared? Have you (or has your client) opened the .doc file in genuine Microsoft Word or in the freeware (Windows only) Word viewer? Or have you just reopened the .doc file in LibreOffice and found the background absent there? I think there may be circumstances where the .doc file does retain the background but this is not converted correctly when reopened in LibreOffice. The background is gone both when I open the .doc file in LO and when he opens it in Word. Which may indicate that it is a problem with the export? It is not a linked file. And all the other images export/import just fine from the .doc file. It is just the full-page-no-margins background image that disappears. I'll probably be writing on a machine with genuine Word next week, and then I could do some tests on a USB-stick to see if a background image added inside Word will import into LO. Note also that the Background tab of the Page Style dialogue (where you selected the background graphic) has a Link box. If you tick this, the graphic is linked and not embedded, and there may be problems when you transfer the file to another file system - e.g. your client's - where the original image file does not exist separately at the same absolute file path. Try unticking that box. (But I'm not sure that will make any difference.) I trust this helps. Brian Barker -- Sendt med Operas revolusjonerende e-postprogram: http://www.opera.com/mail/ -- For unsubscribe instructions e-mail to: users+h...@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] LO to .doc with background image?
W dniu 07.11.2012 16:00, Bjørn K Nilssen pisze: I made a 'template' in LO for an A3 leaflet with a background image (page style) on the first page. No margins, but with boxes with text, table and images on top of it. Everything works fine in LO, and also if exported as PDF. But when saved as .doc the entire background image is gone. Any ideas about what happens? Can't you use background images in Word? So far the client has to use the pdf ... There is still problem with export to doc - many times the GFX is lost, or style/font changed in part of text. The situation in weird because the Word from M$O 2010 can readwrite in both format and the document always looks the same. Mieszko -- For unsubscribe instructions e-mail to: users+h...@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] Conditional formatting
Le 07/11/2012 17:44, IGraham a écrit : Conditional formatting [...] W764 LibreOffice 3.6.2.2 You should upgrade to the current release which is 3.6.3. Several bug involving conditional formatting have been fixed in this release. Best regards. JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- For unsubscribe instructions e-mail to: users+h...@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: Conditional formatting
Thanks for the reply 'but' umm I forgot to change my sig/version - must in future remember to include such details I am using 3.6.3.2 and this is the version that has introduced the Conditional formatting bug - IGraham W764 LibreOffice 3.6.3.2 -- View this message in context: http://nabble.documentfoundation.org/Conditional-formatting-tp4017324p4017402.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] keep hidden files from being displayed in the open a file window
LO 3.6.2.2 on Xubuntu 12.10. when I dir to File-- open, I am presented with hundreds of hidden files (1st char is a period). How do I hide these. I searched help, and all of the tools--options area. -- For unsubscribe instructions e-mail to: users+h...@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] keep hidden files from being displayed in the open a file window
On 11/07/2012 04:50 PM, John R. Sowden wrote: LO 3.6.2.2 on Xubuntu 12.10. when I dir to File-- open, I am presented with hundreds of hidden files (1st char is a period). How do I hide these. I searched help, and all of the tools--options area. found the answer: while in the open a file directory, right-click on a file or directory, uncheck show hidden files John -- For unsubscribe instructions e-mail to: users+h...@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] bug report server is down
Hi,Just wanted to report a bug viahttps://www.libreoffice.org/get-help/bug/when I received message with more or less incomprehensible stuff except for Japanese. The Japanese message says that the server is stopped for maintenance reasons or the server has a performance problem etcIt would be good if this message would be readable in other languages. Below is a part of the screen shot but I don't know if this is to be seen in the user-mail. -- For unsubscribe instructions e-mail to: users+h...@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