[libreoffice-users] RE: Bespoke background images
Hi Tom, I eventually found the answer by trawling through the Help pages. This was one of those rare instances where LibreOffice isn't as intuitive as it could be. Setting a background image for an object allows new images to be imported. Setting a background image for a whole page doesn't let you import. A bit of an anomaly I feel. Cheers, Charlie. Date: Thu, 19 Jan 2012 08:32:52 -0800 From: ml-node+s969070n367281...@n3.nabble.com To: charlie_m...@msn.com Subject: Re: Bespoke background images Hi :) Were you able to get this working? Do you need more help with this issue? Is the wiki good enough or does it need a bit of work? Regards from Tom :) If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Bespoke-background-images-tp3665807p3672819.html To unsubscribe from Bespoke background images, click here. NAML -- View this message in context: http://nabble.documentfoundation.org/Bespoke-background-images-tp3665807p3680556.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] I need help creating a database for a website
What are the steps that I need to do with OpenOffice to do the following on my website http://www.wirkathome.com/ I have some training lessons that have companies that I work with. When someone signs up with the different companies, they are given their own link. I want them to be able to give the lessons to others, and want to make it easy for them. I want to give them an html address, tha 1. I want to create an order form where someone could place a website address in it. 2. I then want to have that website address placed in my text document using a field. 3. There will be a lot of different companies that they can join. I want my links to remain the same in any of the companies they do not want to join. 4. I then want to give them a copy of my website that will change my links to their links 5. I want them to be able to give that copy to their down-line.. How can I accomplish this using OpenOffice. Thank You, John Harrison -- 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: some text not printing
George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon What happens if you copy/paste one of the offending paragraphs into a new and otherwise empty Writer document and then print that? Does that give you any clues? Are the offending paragraphs the result of tracked changes (Reviews) which have been suppressed/rejected? See the Help under changesreview function - at least that's where it is in OpenOffice; I don't have LO on this system. -- Harold Fuchs London, England -- 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: some text not printing
George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon Another thought, from OOo's Help: begin quote = To Hide Text From Printing Any Writer text frame can be set to a mode which allows viewing the text on screen, but hides the text from printing. Select the text frame (you see the eight handles). Choose Format - Frame/Object - Options. In the Properties area, unmark the Print check box and click OK. === end quote = -- Harold Fuchs London, England -- 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: Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer
On Sun, 22 Jan 2012 15:38:21 -0500, webmaster for Kracked Press Productions wrote: Kompozer ... I use it to, and no where do I know will it allow me to set it as the default package for displaying HTM/HTML files. Here in Mandriva KDE land: System Settings|File Associations|Text|Html|Add -- /\/\aurice -- 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] base - join same table multiple times
I have the following: tablea - id - name tableb - id - type - total - tablea_id In tableb there can be multiple records for a record in tablea. Like to get to this: tablea.id, tablea.name, tableb1.total1 (if type = 1), tableb2.total2 (if type = 2) I tried to setup a view where I link tableb twice to tablea, but I can't figure out how to define things with regards to the relation. In SQL it would be something along these lines: SELECT DISTINCT `table1`.`name`, `tableb1`.`total`, `tableb2`.`total` FROM `tablea` LEFT OUTER JOIN `tableb` as `tableb1` ON `tablea`.`id` = `tableb1`.`tablea_id` AND `tableb1`.`type` = 1 LEFT OUTER JOIN `tableb` as `tableb2` ON `tablea`.`id` = `tableb2`.`tablea_id` AND `tableb2`.`type` = 1 Is this possible with base in LibrOffice 3.3.2, but could upgrade if a newer version provides this functionality. Thanks in advance for any tips. Werner -- 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] some text not printing
On 01/23/2012 02:30 AM, George E Noon wrote: Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon Two thoughts: I think LO has some feature that lets you see hidden features, like carriage returns, new paragraph indicators, etc. I haven't used the feature, but I believe it's there--like in WordPerfect. If so, turn it on, and look for something strange around the paragraphs that don't print. Second: If you have any printed copy (from back when it worked) scan it in and use OCR to translate it back to text. Then--you'll have to proof-read it, of course--enter it into some word processor and print it from there. Clumsy, but much better than typeing the whole thing over. --doug -- 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] Excel macros and functions
I have a rather complex Excel 2003 spreadsheet which extensively uses some built function and macros. Can Calc translate and run them? Nathan -- 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] Re: Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer
? On January 23, 2012 5:29:48 AM PST, Maurice Batey wrote: On Sun, 22 Jan 2012 15:38:21 -0500, webmaster for Kracked Press Productions wrote: Kompozer ... I use it to, and no where do I know will it allow me to set it as the default package for displaying HTM/HTML files. Here in Mandriva KDE land: System Settings|File Associations|Text|Html|Add -- /\/\aurice -- 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] Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer
On Sun, 22 Jan 2012 12:48:09 +, I wrote: Still awaiting news of what other LO users on Mandriva report. One fellow Mandriva user reports: Decided to logout and then re-login using every other window manager available with Mandriva 2010.2. The only time that the LO Open/Save option appears is when I load Gnome! So LO is taking real-time steps to avoid showing the option when detecting use of certain desktops (e.g. KDE) in certain distributions (e.g. Debian, Mandriva). Perhaps it has had problems with it in those areas in the past, so now omits it rather than defaulting it to 'off'. -- /\/\aurice -- 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: Re: Re: How to migrate OpenOfficec Writer settings into LinbreOffice Writer
On Mon, 23 Jan 2012 06:56:36 -0800, Fridolin Gansheimer wrote: ? You previously asked the question I quoted, and I described the options used with Mandriva KDE to achieve your wish w.r.t. Kompozer HTML files (in case you had similar options available). -- /\/\aurice -- 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] Disappearing headers in .doc files
I have been using LibreOffice since it became the default office suite in Ubuntu and OpenOffice for years before that. I write fairly highly formatted documents, like resumes, which are frequently saved for co-editing in .doc formats. Current version in use is 3.4.4 in Ubuntu 11.10 Until very recently, I could create a header in the following way * Go to Insert, Header and select Default * Go anywhere on the first page and select the page style First Page. This turned off the default header on the first page. * Complete the header on P2. * Save as Microsoft Word 97/2000/XP etc. This method no longer works. The Default header style does not place a header on the first page (that's OK with me). The header on P2 and following appears fine but when I save and re-open the document it not longer is visible. Is this a bug or am I missing something? I have attached a sanitized resume as an example -- 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] some text not printing
Hi, Posted last night while quite tired annoyed -- neglected to include info on my set-up; I am using Ubuntu 11.10 Oneiric, LO 3.4.4, have an Epson Stylus-C120 printer - my computer is built on an Asus P5K-V motherboard with Intel Core 2 duo CPU E6550 @ 2.33GHz × 2. Not sure what other info would be helpful, but if someone could tell me which terminal commands to give, I can respond with the output of it. I really have no idea of what has caused this problem, as the file had always printed out just fine previously. Thank you, George On 01/23/2012 02:30 AM, George E Noon wrote: Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon -- 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] Excel macros and functions
2012/1/23 Nathan Gutman nzgut...@sbcglobal.net: I have a rather complex Excel 2003 spreadsheet which extensively uses some built function and macros. Can Calc translate and run them? Nathan Probably not. -- 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] base - join same table multiple times
On 01/23/2012 08:26 AM, Werner F. Bruhin wrote: I have the following: tablea - id - name tableb - id - type - total - tablea_id In tableb there can be multiple records for a record in tablea. Like to get to this: tablea.id, tablea.name, tableb1.total1 (if type = 1), tableb2.total2 (if type = 2) I tried to setup a view where I link tableb twice to tablea, but I can't figure out how to define things with regards to the relation. In SQL it would be something along these lines: SELECT DISTINCT `table1`.`name`, `tableb1`.`total`, `tableb2`.`total` FROM `tablea` LEFT OUTER JOIN `tableb` as `tableb1` ON `tablea`.`id` = `tableb1`.`tablea_id` AND `tableb1`.`type` = 1 LEFT OUTER JOIN `tableb` as `tableb2` ON `tablea`.`id` = `tableb2`.`tablea_id` AND `tableb2`.`type` = 1 Is this possible with base in LibrOffice 3.3.2, but could upgrade if a newer version provides this functionality. Thanks in advance for any tips. Werner I'm no guru, and I just thought about it in my head. So it will definitely not work... SELECT tablea.id, tablea.name, (SELECT total FROM tableb WHERE type = 1 LIMIT 1) AS `Type1 Total`, (SELECT total FROM tableb WHERE type = 2 LIMIT 1) AS `Type2 Total` FROM tablea, tableb WHERE tablea.id = tableb.tablea_id; cK -- 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: How to migrate OpenOfficec Writer settings into LinbreOffice Writer
On 01/23/2012 07:52 AM, Maurice Batey wrote: On Sun, 22 Jan 2012 12:48:09 +, I wrote: Still awaiting news of what other LO users on Mandriva report. One fellow Mandriva user reports: Decided to logout and then re-login using every other window manager available with Mandriva 2010.2. The only time that the LO Open/Save option appears is when I load Gnome! So LO is taking real-time steps to avoid showing the option when detecting use of certain desktops (e.g. KDE) in certain distributions (e.g. Debian, Mandriva). I already confirmed when I wrote: I just switched to a KDE session (different user, but same LO install), and sure enough: no 'Open/Save 'Use LO dialogs''. Perhaps it has had problems with it in those areas in the past, so now omits it rather than defaulting it to 'off'. -- 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] Re: some text not printing
Harold, Thanks for your reply. When I copied pasted the page in question, the result was unchanged; all was visible on-screen, but the 2 last paragraphs did not print. In those 2 paragraphs, I am unable to find any setting which would account for their 'going invisible'... As to the Help changesreview function -- that does not seem to have any join to what my problem is, in fact it only refers to spreadsheets. I see that you are in London -- not that that, or where my dad's family comes from has a thing to do with anything, but I'll toss it in anyway; my dad's father was from the village of Arnold in Nottinghamshire UK came to the USA on the Lucitania (sister ship to the ill-fated Lusitania), on its last voyage across the Atlantic before WWI. I had an Uncle Harry Noone, from Notts, who was a Crown Chauffeur [I may have the term wrong, but he drove for the Government], had been Master of two different Masonic Lodges there, and spent his final days as a resident of the Masonic Home in York Any way, thanks for your attempts to help - small world seemingly smaller, daily if we are not helping one another, thing would really look bleak. George On 01/23/2012 04:51 AM, Harold Fuchs wrote: George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon What happens if you copy/paste one of the offending paragraphs into a new and otherwise empty Writer document and then print that? Does that give you any clues? Are the offending paragraphs the result of tracked changes (Reviews) which have been suppressed/rejected? See the Help under changesreview function - at least that's where it is in OpenOffice; I don't have LO on this system. -- 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] Re: some text not printing
Harold, Yes, I have checked this out - but the only way I am able to select text does not result in the eight handles you refer to, but to the whole block of text selected, that is enclosed in a light blue shaded 'box' the Format - Frame/Object - Option is grayed-out [not selectable]. So, I'd say it is not the path to follow. thanks very much for your efforts. George On 01/23/2012 06:15 AM, Harold Fuchs wrote: George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon Another thought, from OOo's Help: begin quote = To Hide Text From Printing Any Writer text frame can be set to a mode which allows viewing the text on screen, but hides the text from printing. Select the text frame (you see the eight handles). Choose Format - Frame/Object - Options. In the Properties area, unmark the Print check box and click OK. === end quote = -- 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] Re: some text not printing
George, This may not be at all helpful, as I am by no means an LO expert, but I have a couple ideas... 1. Have you tried saving it to a PDF file? I was once getting strange printing behavior when I used LO with the Linux Libertine font, but if I saved it to a PDF file first, my output showed up properly. 2. Also, when I get strange behavior in a formatted document, as a last resort, I'll save it as a straight text (.txt) file with all formatting stripped. I can then test it to see if it will print properly. If so, I can then rebuild the formatting. It's a pain, yes, but it's better than retyping the whole document. (But, as a caution, saving as a .txt file will also strip your footnotes) Virgil (not from London, but Ohio) -Original Message- From: George E Noon Sent: Monday, January 23, 2012 1:25 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: some text not printing Harold, Thanks for your reply. When I copied pasted the page in question, the result was unchanged; all was visible on-screen, but the 2 last paragraphs did not print. In those 2 paragraphs, I am unable to find any setting which would account for their 'going invisible'... As to the Help changesreview function -- that does not seem to have any join to what my problem is, in fact it only refers to spreadsheets. I see that you are in London -- not that that, or where my dad's family comes from has a thing to do with anything, but I'll toss it in anyway; my dad's father was from the village of Arnold in Nottinghamshire UK came to the USA on the Lucitania (sister ship to the ill-fated Lusitania), on its last voyage across the Atlantic before WWI. I had an Uncle Harry Noone, from Notts, who was a Crown Chauffeur [I may have the term wrong, but he drove for the Government], had been Master of two different Masonic Lodges there, and spent his final days as a resident of the Masonic Home in York Any way, thanks for your attempts to help - small world seemingly smaller, daily if we are not helping one another, thing would really look bleak. George On 01/23/2012 04:51 AM, Harold Fuchs wrote: George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon What happens if you copy/paste one of the offending paragraphs into a new and otherwise empty Writer document and then print that? Does that give you any clues? Are the offending paragraphs the result of tracked changes (Reviews) which have been suppressed/rejected? See the Help under changesreview function - at least that's where it is in OpenOffice; I don't have LO on this system. -- 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] Re: base - join same table multiple times
Le 23/01/12 14:26, Werner F. Bruhin a écrit : Hi Werner, How about using CASE WHEN() http://hsqldb.org/doc/guide/ch09.html#expression-section CASEWHEN(exp,v1,v2) if exp is true, v1 is returned, else v2) - use CASE WHEN instead Alex -- 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] Re: some text not printing
What part doesn't print? If it's always at the end, check the print setting to make sure it's set to print all pages. If that does not seem to be the problem, have you rebooted? I would not expect this to change much, but it might. Did you try exporting it in various formats, then reimporting it? If you've had it for several years, it's probably more likely in *.doc than any other format. Have you tried exporting it as RTF and OpenOffice format plus text? Do you still get the problem exporting it as text, reimporting then printing it? If you still get the problem, you must have some funny control characters that get exported with the text. There are tools to scan for characters that are NOT vanilla ascii, but I'm not familiar with them. Once you can get the text to print as you want, you need to restore formatting and anything else in the original file. I'd delete all the text that does not print plus a bit more, verify that everything retained prints, then add back the text deleted from the *.txt version. If that does not work, then I'd work from the *.txt version and add all the formatting, etc., a part at a time, saving intermediate files until you get what you want. Binary search techniques could speed this work, potentially: If you have one version that has the problem and another version that doesn't, then identify the differences and systematically try a version roughly half way between one that works and one that doesn't until you fix the problem. Hope this helps. Spencer On 1/23/2012 10:25 AM, George E Noon wrote: Harold, Thanks for your reply. When I copied pasted the page in question, the result was unchanged; all was visible on-screen, but the 2 last paragraphs did not print. In those 2 paragraphs, I am unable to find any setting which would account for their 'going invisible'... As to the Help changesreview function -- that does not seem to have any join to what my problem is, in fact it only refers to spreadsheets. I see that you are in London -- not that that, or where my dad's family comes from has a thing to do with anything, but I'll toss it in anyway; my dad's father was from the village of Arnold in Nottinghamshire UK came to the USA on the Lucitania (sister ship to the ill-fated Lusitania), on its last voyage across the Atlantic before WWI. I had an Uncle Harry Noone, from Notts, who was a Crown Chauffeur [I may have the term wrong, but he drove for the Government], had been Master of two different Masonic Lodges there, and spent his final days as a resident of the Masonic Home in York Any way, thanks for your attempts to help - small world seemingly smaller, daily if we are not helping one another, thing would really look bleak. George On 01/23/2012 04:51 AM, Harold Fuchs wrote: George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon What happens if you copy/paste one of the offending paragraphs into a new and otherwise empty Writer document and then print that? Does that give you any clues? Are the offending paragraphs the result of tracked changes (Reviews) which have been suppressed/rejected? See the Help under changesreview function - at least that's where it is in OpenOffice; I don't have LO on this system. -- Spencer Graves, PE, PhD President and Chief Technology Officer Structure Inspection and Monitoring, Inc. 751 Emerson Ct. San José, CA 95126 ph: 408-655-4567 web: www.structuremonitoring.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] base - join same table multiple times
On Mon, 2012-01-23 at 13:14 -0500, Calvin Kim wrote: On 01/23/2012 08:26 AM, Werner F. Bruhin wrote: I have the following: tablea - id - name tableb - id - type - total - tablea_id In tableb there can be multiple records for a record in tablea. Like to get to this: tablea.id, tablea.name, tableb1.total1 (if type = 1), tableb2.total2 (if type = 2) I tried to setup a view where I link tableb twice to tablea, but I can't figure out how to define things with regards to the relation. In SQL it would be something along these lines: SELECT DISTINCT `table1`.`name`, `tableb1`.`total`, `tableb2`.`total` FROM `tablea` LEFT OUTER JOIN `tableb` as `tableb1` ON `tablea`.`id` = `tableb1`.`tablea_id` AND `tableb1`.`type` = 1 LEFT OUTER JOIN `tableb` as `tableb2` ON `tablea`.`id` = `tableb2`.`tablea_id` AND `tableb2`.`type` = 1 Is this possible with base in LibrOffice 3.3.2, but could upgrade if a newer version provides this functionality. Thanks in advance for any tips. Werner I'm no guru, and I just thought about it in my head. So it will definitely not work... SELECT tablea.id, tablea.name, (SELECT total FROM tableb WHERE type = 1 LIMIT 1) AS `Type1 Total`, (SELECT total FROM tableb WHERE type = 2 LIMIT 1) AS `Type2 Total` FROM tablea, tableb WHERE tablea.id = tableb.tablea_id; cK My thinking is that you do not have enough fields in tableb. What you should have is tableb - id - type - total - tablea1_id foreign key - tablea2_id foreign key You will have two relationships: tablea.id = tableb.tablea1_id where type = 1 tablea.id = tableb.tablea2_id where type = 2 A form for this would have tablea as the main form and tableb as the sub form. Records in the sub form will fall into one of two categories for a given value of the field Name: type =1 or type =2 but not both. I'm also thinking that a query using both tables could be used. I'm not sure how you would want to sort the query. You might want to sort first by the field type (ascending) and second by the field Name (ascending). This would first give you all the data for when type =1. Within this sort, you would have an alphabetical sorting for values of the Name field. --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] some text not printing
Doug, I used to use WordPerfect [first the Novel product, and then the Corel, after they'd obtained it], so I am aware of the type of feature you are referring to, though I cannot find it in LO, at all. As to your second suggestion, I own two scanners, but neither will do anything at all connected to my Ubuntu Gnu/Linux Box (I guess I'm just lucky that way) need a good list somewhere - like the open printing list that indicates which are excellent, good, fair, and useless in the scanner world. Seems these two I have are - so far as Linux is concerned, just good as door-stops. Thank you so much for your helpful comments. George On 01/23/2012 09:54 AM, doug wrote: On 01/23/2012 02:30 AM, George E Noon wrote: Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon Two thoughts: I think LO has some feature that lets you see hidden features, like carriage returns, new paragraph indicators, etc. I haven't used the feature, but I believe it's there--like in WordPerfect. If so, turn it on, and look for something strange around the paragraphs that don't print. Second: If you have any printed copy (from back when it worked) scan it in and use OCR to translate it back to text. Then--you'll have to proof-read it, of course--enter it into some word processor and print it from there. Clumsy, but much better than typeing the whole thing over. --doug -- 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] Re: some text not printing
Thank you, Virgil; I'll give those suggestions a try ( luckily, as the document in question is a Fraternal body's By-Laws, there are no foot-notes). I'll be ery happy if either of them works -- though, of course, I'd be happiest to actually understand what caused the problem, to begin with. But, then i do realize that we all too seldom get what we want, especially when it would actually be good for us. George On 01/23/2012 01:43 PM, Virgil Arrington wrote: George, This may not be at all helpful, as I am by no means an LO expert, but I have a couple ideas... 1. Have you tried saving it to a PDF file? I was once getting strange printing behavior when I used LO with the Linux Libertine font, but if I saved it to a PDF file first, my output showed up properly. 2. Also, when I get strange behavior in a formatted document, as a last resort, I'll save it as a straight text (.txt) file with all formatting stripped. I can then test it to see if it will print properly. If so, I can then rebuild the formatting. It's a pain, yes, but it's better than retyping the whole document. (But, as a caution, saving as a .txt file will also strip your footnotes) Virgil (not from London, but Ohio) -Original Message- From: George E Noon Sent: Monday, January 23, 2012 1:25 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: some text not printing Harold, Thanks for your reply. When I copied pasted the page in question, the result was unchanged; all was visible on-screen, but the 2 last paragraphs did not print. In those 2 paragraphs, I am unable to find any setting which would account for their 'going invisible'... As to the Help changesreview function -- that does not seem to have any join to what my problem is, in fact it only refers to spreadsheets. I see that you are in London -- not that that, or where my dad's family comes from has a thing to do with anything, but I'll toss it in anyway; my dad's father was from the village of Arnold in Nottinghamshire UK came to the USA on the Lucitania (sister ship to the ill-fated Lusitania), on its last voyage across the Atlantic before WWI. I had an Uncle Harry Noone, from Notts, who was a Crown Chauffeur [I may have the term wrong, but he drove for the Government], had been Master of two different Masonic Lodges there, and spent his final days as a resident of the Masonic Home in York Any way, thanks for your attempts to help - small world seemingly smaller, daily if we are not helping one another, thing would really look bleak. George On 01/23/2012 04:51 AM, Harold Fuchs wrote: George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no formatting or other setting difference between the text which prints that which does not, except that one does the other does not print. I really do not wish to have to completely re-enter the entire document, all over again ( hope that whatever caused the non-print problem does not occur again, anyway). Does any one have any thoughts as to a possible cause -- I will investigate all angles I'm able to do. Thanks for your assistance. George E Noon What happens if you copy/paste one of the offending paragraphs into a new and otherwise empty Writer document and then print that? Does that give you any clues? Are the offending paragraphs the result of tracked changes (Reviews) which have been suppressed/rejected? See the Help under changesreview function - at least that's where it is in OpenOffice; I don't have LO on this system. -- 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: How to migrate OpenOfficec Writer settings into LinbreOffice Writer
On Mon, 23 Jan 2012 10:25:20 -0800, NoOp wrote: already confirmed Our postings seemed to have crosssed on the wires... -- /\/\aurice -- 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: base - join same table multiple times
Hi Dan and Calvin, First of all thanks for the quick response. Based on what suggested I came up with the following which at least got me to the point of valid SQL for base. Using the actual table names, so tablea becomes Wine and tableb becomes Degustation and I needed another one MarketPrice. Couldn't get Limit to work, would love to know how one would use it. As Degustation table only has a single DeguID per WineID I got what I needed, but in the MarketPrice table I am cheating with the avg(), would really like to get latest/highest based on MarketPrices.PurchaseDate. Could this be done by adding an Order_By clause and Limit or ...??? Anyhow this is pretty clause to what I needed and I probably can live with it. Thanks again Werner SELECT Wine.Year, Wine.Name, Wine.Appellation, Wine.Region, Wine.Country, Wine.Variety, Wine.Color, Wine.Alcohol, Wine.Producer, (SELECT D_1.Total FROM Degustation as D_1 WHERE D_1.DeguID = 1 and D_1.WineID = Wine.WineID) AS `Degu1 Total`, (SELECT D_2.Total FROM Degustation as D_2 WHERE D_2.DeguID = 2 and D_2.WineID = Wine.WineID) AS `Degu2 Total`, (SELECT D_3.Total FROM Degustation as D_3 WHERE D_3.DeguID = 3 and D_3.WineID = Wine.WineID) AS `Degu3 Total`, (SELECT D_4.Total FROM Degustation as D_4 WHERE D_4.DeguID = 4 and D_4.WineID = Wine.WineID) AS `Degu4 Total`, (SELECT D_5.Total FROM Degustation as D_5 WHERE D_5.DeguID = 5 and D_5.WineID = Wine.WineID) AS `Degu5 Total`, (SELECT D_6.Total FROM Degustation as D_6 WHERE D_6.DeguID = 6 and D_6.WineID = Wine.WineID) AS `Degu6 Total`, (SELECT MAX(MP.MarketPrice) FROM MarketPrices as MP WHERE MP.WineID = Wine.WineID) AS `Price` FROM Wine, Degustation as DALL WHERE Wine.WineID = DALL.WineID * Unknown - detected * English * English javascript:void(0); -- 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] Re: some text not printing
Spencer, The document in question is a set of the By-Laws of an Odd Fellow Lodge that I happen to have been Secretary of for 19 years, now. I've had it since January, 2002, when as Lodge Secretary, I was named Clerk of the Committee tasked with 'revising updating the Lodge's By-Laws. I originally had it as a WordPerfect document ( I had a Star Office document version when I came upon and tried that for a while) - I changed over to Ubuntu Linux (Breezy) in 2006 proceeded to migrate all my document folder contents to it they've been in Ubuntu program files ever since. Odd, but i was not that fond of Star Office - but when i got to using Ubuntu, i took right to OOo, which came out of Star Office, as I understand it. Switched to Libre Office a bout a year ago 7 this is really the first problem I've had with it. The parts that don't print are all full paragraphs --- but I can not find any reason for their not printing in either printer settings nor in any LO settings that I have been able to find. No, i haven't rebooted -- if I were still running MS Windows, that would have been my first choice - but so far that has never been a necessity with Linux, thankfully. I will give it a try - though, if only to eliminate it as something needed. I have most of my documents in standard open document format [whatever LO defaults to, at the time] - I do make MS Word compatible ' .doc' copies, though - so if I need to e-mail to others i don't get a whiney reply back that your document was unreadable. I guess it would also be a good idea to convert to PDF, as well -- that might be a solution, or, at least a problem revealer. Thank you for your suggestions I'll be trying them out perhaps I'll be inspired to search further to see if I've 'gained' some strange setting somewhere or other... George On 01/23/2012 01:48 PM, Spencer Graves wrote: What part doesn't print? If it's always at the end, check the print setting to make sure it's set to print all pages. If that does not seem to be the problem, have you rebooted? I would not expect this to change much, but it might. Did you try exporting it in various formats, then reimporting it? If you've had it for several years, it's probably more likely in *.doc than any other format. Have you tried exporting it as RTF and OpenOffice format plus text? Do you still get the problem exporting it as text, reimporting then printing it? If you still get the problem, you must have some funny control characters that get exported with the text. There are tools to scan for characters that are NOT vanilla ascii, but I'm not familiar with them. Once you can get the text to print as you want, you need to restore formatting and anything else in the original file. I'd delete all the text that does not print plus a bit more, verify that everything retained prints, then add back the text deleted from the *.txt version. If that does not work, then I'd work from the *.txt version and add all the formatting, etc., a part at a time, saving intermediate files until you get what you want. Binary search techniques could speed this work, potentially: If you have one version that has the problem and another version that doesn't, then identify the differences and systematically try a version roughly half way between one that works and one that doesn't until you fix the problem. Hope this helps. Spencer On 1/23/2012 10:25 AM, George E Noon wrote: Harold, Thanks for your reply. When I copied pasted the page in question, the result was unchanged; all was visible on-screen, but the 2 last paragraphs did not print. In those 2 paragraphs, I am unable to find any setting which would account for their 'going invisible'... As to the Help changesreview function -- that does not seem to have any join to what my problem is, in fact it only refers to spreadsheets. I see that you are in London -- not that that, or where my dad's family comes from has a thing to do with anything, but I'll toss it in anyway; my dad's father was from the village of Arnold in Nottinghamshire UK came to the USA on the Lucitania (sister ship to the ill-fated Lusitania), on its last voyage across the Atlantic before WWI. I had an Uncle Harry Noone, from Notts, who was a Crown Chauffeur [I may have the term wrong, but he drove for the Government], had been Master of two different Masonic Lodges there, and spent his final days as a resident of the Masonic Home in York Any way, thanks for your attempts to help - small world seemingly smaller, daily if we are not helping one another, thing would really look bleak. George On 01/23/2012 04:51 AM, Harold Fuchs wrote: George E Noon ge.n...@verizon.net wrote in message news:4f1d0ca7.90...@verizon.net... Hello, Seems I've found a new especially annoying problem. A document I've had on disk for
Re: [libreoffice-users] some text not printing
Hello George, George E Noon wrote (23-01-12 08:30) A document I've had on disk for several years have printed without problems before, has now come to the point where some paragraphs do not print at all - although they appear on-screen OK I can find no [...] - Any chance to share (part of) such a document with us (via website or so)? Cheers, -- - Cor - http://nl.libreoffice.org -- 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] some text not printing
George E Noon wrote (23-01-12 19:59) Doug, I used to use WordPerfect [first the Novel product, and then the Corel, after they'd obtained it], so I am aware of the type of feature you are referring to, though I cannot find it in LO, at all. Format Character Text effects ... hidden. And Tools Options Writer Print hidden text -- - Cor - http://nl.libreoffice.org -- 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] Re: some text not printing
An idea based on my experience with this type of long-lived document. Look for a corruption in the file format. Look for an older version of it (from your archive / backup systems) that might print correctly. True, this idea comes from experience with M$ products. But the formats are not so much different. A long document that receives hundreds of small changes over a period of 1 or 2 years is likely to acquire a format corruption. One such sign is a difference between the file size as reported by LibreOffice and the file size as reported by disk file manager in OS. -- David S. Crampton On Mon, 23 Jan 2012 11:40:41 -0800, George E Noon ge.n...@verizon.net wrote: Spencer, The document in question is a set of the By-Laws of an Odd Fellow Lodge that I happen to have been Secretary of for 19 years, now. I've had it since January, 2002, when as Lodge Secretary, I was named Clerk of the Committee tasked with 'revising updating the Lodge's By-Laws. I originally had it as a WordPerfect document ( I had a Star Office document version when I came upon and tried that for a while) - I changed over to Ubuntu Linux (Breezy) in 2006 proceeded to migrate all my document folder contents to it they've been in Ubuntu program files ever since. Odd, but i was not that fond of Star Office - but when i got to using Ubuntu, i took right to OOo, which came out of Star Office, as I understand it. Switched to Libre Office a bout a year ago 7 this is really the first problem I've had with it. The parts that don't print are all full paragraphs --- but I can not find any reason for their not printing in either printer settings nor in any LO settings that I have been able to find. No, i haven't rebooted -- if I were still running MS Windows, that would have been my first choice - but so far that has never been a necessity with Linux, thankfully. I will give it a try - though, if only to eliminate it as something needed. I have most of my documents in standard open document format [whatever LO defaults to, at the time] - I do make MS Word compatible ' .doc' copies, though - so if I need to e-mail to others i don't get a whiney reply back that your document was unreadable. I guess it would also be a good idea to convert to PDF, as well -- that might be a solution, or, at least a problem revealer. Thank you for your suggestions I'll be trying them out perhaps I'll be inspired to search further to see if I've 'gained' some strange setting somewhere or other... George On 01/23/2012 01:48 PM, Spencer Graves wrote: What part doesn't print? If it's always at the end, check the print setting to make sure it's set to print all pages. If that does not seem to be the problem, have you rebooted? I would not expect this to change much, but it might. Did you try exporting it in various formats, then reimporting it? If you've had it for several years, it's probably more likely in *.doc than any other format. Have you tried exporting it as RTF and OpenOffice format plus text? Do you still get the problem exporting it as text, reimporting then printing it? If you still get the problem, you must have some funny control characters that get exported with the text. There are tools to scan for characters that are NOT vanilla ascii, but I'm not familiar with them. Once you can get the text to print as you want, you need to restore formatting and anything else in the original file. I'd delete all the text that does not print plus a bit more, verify that everything retained prints, then add back the text deleted from the *.txt version. If that does not work, then I'd work from the *.txt version and add all the formatting, etc., a part at a time, saving intermediate files until you get what you want. Binary search techniques could speed this work, potentially: If you have one version that has the problem and another version that doesn't, then identify the differences and systematically try a version roughly half way between one that works and one that doesn't until you fix the problem. Hope this helps. Spencer On 1/23/2012 10:25 AM, George E Noon wrote: Harold, Thanks for your reply. When I copied pasted the page in question, the result was unchanged; all was visible on-screen, but the 2 last paragraphs did not print. In those 2 paragraphs, I am unable to find any setting which would account for their 'going invisible'... As to the Help changesreview function -- that does not seem to have any join to what my problem is, in fact it only refers to spreadsheets. I see that you are in London -- not that that, or where my dad's family comes from has a thing to do with anything, but I'll toss it in anyway; my dad's father was from the village of Arnold in Nottinghamshire UK came to the USA on the Lucitania
Re: [libreoffice-users] Re: base - join same table multiple times
On 01/23/2012 02:31 PM, Werner F. Bruhin wrote: Hi Dan and Calvin, First of all thanks for the quick response. Based on what suggested I came up with the following which at least got me to the point of valid SQL for base. Using the actual table names, so tablea becomes Wine and tableb becomes Degustation and I needed another one MarketPrice. Couldn't get Limit to work, would love to know how one would use it. As Degustation table only has a single DeguID per WineID I got what I needed, but in the MarketPrice table I am cheating with the avg(), would really like to get latest/highest based on MarketPrices.PurchaseDate. Could this be done by adding an Order_By clause and Limit or ...??? Anyhow this is pretty clause to what I needed and I probably can live with it. Thanks again Werner SELECT Wine.Year, Wine.Name, Wine.Appellation, Wine.Region, Wine.Country, Wine.Variety, Wine.Color, Wine.Alcohol, Wine.Producer, (SELECT D_1.Total FROM Degustation as D_1 WHERE D_1.DeguID = 1 and D_1.WineID = Wine.WineID) AS `Degu1 Total`, (SELECT D_2.Total FROM Degustation as D_2 WHERE D_2.DeguID = 2 and D_2.WineID = Wine.WineID) AS `Degu2 Total`, (SELECT D_3.Total FROM Degustation as D_3 WHERE D_3.DeguID = 3 and D_3.WineID = Wine.WineID) AS `Degu3 Total`, (SELECT D_4.Total FROM Degustation as D_4 WHERE D_4.DeguID = 4 and D_4.WineID = Wine.WineID) AS `Degu4 Total`, (SELECT D_5.Total FROM Degustation as D_5 WHERE D_5.DeguID = 5 and D_5.WineID = Wine.WineID) AS `Degu5 Total`, (SELECT D_6.Total FROM Degustation as D_6 WHERE D_6.DeguID = 6 and D_6.WineID = Wine.WineID) AS `Degu6 Total`, (SELECT MAX(MP.MarketPrice) FROM MarketPrices as MP WHERE MP.WineID = Wine.WineID) AS `Price` FROM Wine, Degustation as DALL WHERE Wine.WineID = DALL.WineID Subquery must return only one result, otherwise whole thing will not work. Reorder the result of MarketPrice query by either latest or highest and limit it. Try LIMIT 0, 1 in your subquery. It means starting from 1st result(0), display 1 result only. cK -- 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] Question about Calc and Annotations
Hi Cor! I'm using Calc to manage documents from job where each row correspond to a document and has information like dates, values, names, etc., and one historic description that some times takes very long. I made a test inserting historic as annotation and the result looks very good, except the slow down/freezing aspect that do not occurs in MS Office 2010. Actually I inserted the historic as normal string, that is a little difficult to search as I need to press F2 in the selected cell (after using normal search) to see what is written. By the way, that multiline inputbar implemented in LO3.5beta would solve this problem but I cannot use beta version at work (however I don't know why we still using LO3.3 there). :-/ ;-) Regards Alex Mitsio Sato On Sat, Jan 21, 2012 at 8:36 PM, Cor Nouws oo...@nouenoff.nl wrote: Hi Alex, Cor Nouws wrote (19-01-12 23:19) I think some of the devs will be very happy with your trial / posts. I had a short chat with Markus. It's not exactly something they currently work on. On the other hand, they have a recent very positive experience with someone who helped to get great performance improvement in another area: http://kohei.us/2011/11/30/**performance-improvement-in-**opening-ods/http://kohei.us/2011/11/30/performance-improvement-in-opening-ods/ You may get the hint: i you are in need for 18000 annotations and are using macros for creating things like that, it might be a possible step... How does that sound ? Maybe it looks way to complicated. But reading the blog, I know that there was great support for Laurent too. Cheers, -- - Cor - http://nl.libreoffice.org -- 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 -- 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: Need simple find replace macro
Andrew: The first one seems to work perfect. I didn't try the second one. Thanks for everything. I spent many weeks racking my brain over this. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3683281.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] Excel macros and functions
On 01/23/2012 11:38 AM, Johnny Rosenberg wrote: 2012/1/23 Nathan Gutmannzgut...@sbcglobal.net: I have a rather complex Excel 2003 spreadsheet which extensively uses some built function and macros. Can Calc translate and run them? Nathan Probably not. ... because the internal object model is different. The basic language is the same. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] Re: Need simple find replace macro
The first one calls the second one. I did not change the names, but I did change the second one slightly. On 01/23/2012 05:54 PM, paulwhitehurst wrote: Andrew: The first one seems to work perfect. I didn't try the second one. Thanks for everything. I spent many weeks racking my brain over this. Paul -- View this message in context: http://nabble.documentfoundation.org/Need-simple-find-replace-macro-tp3672651p3683281.html Sent from the Users mailing list archive at Nabble.com. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- 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] Add pdf as page in document
Your best bet would be to convert your newsletter to a PDF first. Then, insert the form into the PDF using PDF authoring software like Adobe Acrobat. That's what I would do. - Jeff Prater On Fri, Jan 20, 2012 at 12:53 PM, upscope upsc...@nwi.net wrote: Is there a way to put a pdf form into a page of a newletter? I know you can create one, but this form was sent to me to be included in the newsletter so people can fill it in and then print it for mailing. From writer: CODE: --- file--open and selected the document and file type as .pdf. /CODE: - It opens the pdf in draw instead of the select document page in writer. I know I save it as an image and insert it but then the users will not beable to use it. Thanks for any ideas. -- Russ LibreOffice 3.4.5 OOO340m1 (Build:502) [from L.O website] openSUSE 12.1(Linux 3.1.0-1.2-desktop x86_64)|KDE Platform Version 4.7.4 (4.7.4) Release 11|Intel core2duo 2.5 MHZ, |8GB DDR3| GeForce 8400GS (NVIDIA-Linux-290.10-13.1.x86_64) -- 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
Re: [libreoffice-users] Add pdf as page in document
On Monday, January 23, 2012 09:32:29 PM Jeff Prater wrote: Your best bet would be to convert your newsletter to a PDF first. Then, insert the form into the PDF using PDF authoring software like Adobe Acrobat. That's what I would do. This will not work. First I use Linux, Second I cannot afford Adobe Acrobat which to the best of my knowledge does not have a Linux version. I can create pdf's from LibreOffice and Scribus. I have not had time to try this in Scribus, it is supposed to import pdf's, but latest update gives error on trying to open pdf. Need to report bug. Thanks for your reply anyway. In order to get bulletin out I just recreated the whole document as a pdf form in LibreOffice and then save whol bulletin as pdf. Alot of extra work. - Jeff Prater On Fri, Jan 20, 2012 at 12:53 PM, upscope upsc...@nwi.net wrote: Is there a way to put a pdf form into a page of a newletter? I know you can create one, but this form was sent to me to be included in the newsletter so people can fill it in and then print it for mailing. From writer: CODE: --- file--open and selected the document and file type as .pdf. /CODE: - It opens the pdf in draw instead of the select document page in writer. I know I save it as an image and insert it but then the users will not beable to use it. Thanks for any ideas. -- Russ LibreOffice 3.4.5 OOO340m1 (Build:502) [from L.O website] openSUSE 12.1(Linux 3.1.0-1.2-desktop x86_64)|KDE Platform Version 4.7.4 (4.7.4) Release 11|Intel core2duo 2.5 MHZ, |8GB DDR3| GeForce 8400GS (NVIDIA-Linux-290.10-13.1.x86_64) -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscri be/ 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 -- Russ -- 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] Printer always selects PDF instead of Postscript
Twice I tried to send this to the new list, and both times it bounced. I give up on the new list. OK, old list now working either. Trying a third new list. Libreoffice 3.4.4 on Fedora 16, x86_64. Printer: Laserjet 4M+ (Postscript Level 2) I used OOo for many years and never had this problem until I switched to Libreoffice. Whenever I print to this printer I must remember to go into Properties Options Device and change the print type from PDF to Postscript. If I do not the text will fail to be kerned according to the font metrics; that is, a proportional font will be spaced as though it was a monospace font. All other applications print fine. There is no setting for this in the driver, which uses a PPD file. I looked everywhere for a setting to set it to use Postscript as the default, but I can't find it. It is extra work to have to change this setting all the time. And usually I forget to change the setting and have to print the page again after I realize that I forgot. This is very annoying, and it wastes paper, toner and electricity. I really hope someone can tell me how to change the default behavior, else I will have to remove Libreoffice and reinstall OOo. -- 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] some text not printing
Cor, I checked both the cited spots; the first, with the non-printing text selected -- hidden is _not_ checked the second, 'hidden text' and 'text placeholder' are _not_ checked - the other options under 'contents' are but do not appear to be anything to cause this problem. George On 01/23/2012 02:45 PM, Cor Nouws wrote: George E Noon wrote (23-01-12 19:59) Doug, I used to use WordPerfect [first the Novel product, and then the Corel, after they'd obtained it], so I am aware of the type of feature you are referring to, though I cannot find it in LO, at all. Format Character Text effects ... hidden. And Tools Options Writer Print hidden text -- 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] Re: some text not printing
David, Thank you! You just may have hit upon something. I have an older (continually updated Ubuntu on another HDD, its copy of the same file is slightly larger --- the one with non-printing bits is a 367.5kb file the older one is 371.1kb the difference is only 3.6 kb - but that could just be where the 'wrinkle' is hidden... Now, well - more likely in the morning after I've slept some, ill have to smitch to the other Ubuntu install try printing from that file. Really hope that is the cure. Thanks! George On 01/23/2012 02:54 PM, David S. Crampton wrote: An idea based on my experience with this type of long-lived document. Look for a corruption in the file format. Look for an older version of it (from your archive / backup systems) that might print correctly. True, this idea comes from experience with M$ products. But the formats are not so much different. A long document that receives hundreds of small changes over a period of 1 or 2 years is likely to acquire a format corruption. One such sign is a difference between the file size as reported by LibreOffice and the file size as reported by disk file manager in OS. -- 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