Re: [libreoffice-users] Comments after document as text
Hi :) It might be good to post as a 'bug-report' but then one of the drop-downs allows you to set it as a feature request or wishlist item. http://wiki.documentfoundation.org/BugReport Regards from Tom :) --- On Fri, 4/5/12, Rainer M Krug r.m.k...@gmail.com wrote: snip / I found a solution: 1) Print to postscript file the comments only 2) open the postscript file with abiword (libreoffice is not working) and save it as e.g. doc There it is. I think it would be a good idea for these usage scenarios, to have the option to *export* the comments to a new .odt file for further processing. Cheers, Rainer - -- Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany) -- 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] Workarounds for multiple problems with the legacy Report Designer-Wizard under LO 3.5
After doing a bit more investigation recently, this is a summary of what I've found (so far) regarding the multiple problems with the legacy Report Designer-Wizard (RDW) under LO 3.5. For convenience and succinctness, I thought it might be worth SUMMARIZING the situation in this new message. It seems there are (at least) 3 different problems/bugs with the RDW under LO 3.5. SUMMARY OF PROBLEMS WITH THE REPORT-DESIGNER-WIZARD (UNDER LO 3.5) 1. All reports of course need to be based on an SQL query (whether pre-existing, or generated 'on-the-fly' by the RDW) 2. When building a Report using the LRD, there are 2 situations (specified in the first step of the RDW): a. Select a TABLE from your database b. Select a (pre-existing) QUERY from your database (referencing the TABLE above) 3. In the first case (2a above), using LO 3.5, the wizard DOES generate the appropriate query (with the fields and sorting the user has selected), and stores it in the hidden COMMAND control field. But NOTE, there is still a PROBLEM in the case where the Report needs to have GROUP HEADERS (i.e. GROUPED on one of the database fields). In this case, the auto-generated QUERY is incomplete, and the GROUP BY term is omitted. This can be fixed by simply editing the QUERY in the COMMAND control field and adding the GROUP BY term. This is effectively another BUG, in my opinion (the 'Repeated Headings Bug'). e.g. see here: http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3835807 4. In the second case (2b above), the wizard either does NOT generate the query (or does NOT copy it into the COMMAND control field) - leaving it BLANK. So it has to be entered 'manually'. This is the 'Blank COMMAND field' bug mentioned elsewhere. https://bugs.freedesktop.org/show_bug.cgi?id=47473 5. When I use the LRD in OpenOffice v.3.3 to generate the SAME report from the SAME database, the wizard correctly generates the SQL command, as shown in the hidden COMMAND control field, with the correct GROUPING term, and so the report runs properly in OO. (It also also runs properly in LO 3.5 once the hidden 'SORTING' control is added - that's the OTHER 'Sorting control' bug!). See here... http://nabble.documentfoundation.org/Legacy-Base-reports-won-t-open-in-LibreOffice-3-5-td3916293.html#a3917443 http://en.libreofficeforum.org/node/2589 http://nabble.documentfoundation.org/Report-Builder-td2762261.html#a2762591 6. OO also correctly copies the query code into the COMMAND control field in the SECOND case (2b) above, so there is no 'blank Command field' BUG in OO - see point 4 above. 7. There seems to be mounting evidence that these problems affect LO 3.5 user on all platforms. See the links above for more info. I'm not a programmer, and don't have any deep technical understanding of LO and BASE, but it looks to me that how the RDW works has been changed somewhere down the line in LO development, leading to these 'bugs' (which, from what other users have reported, don't seem to affect LO 3.3 - not sure about LO 3.4). I hope this summary helps people using the RDW create properly functioning reports until the problems are sorted down the track. Despite it's flaws, I find the Report Designer Wizard a very flexible and useful tool, and hope that it will continue to be supported by the LO development team. - Fred -- View this message in context: http://nabble.documentfoundation.org/Workarounds-for-multiple-problems-with-the-legacy-Report-Designer-Wizard-under-LO-3-5-tp3964175.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] Comments after document as text
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/05/12 16:49, Renaud (Ron) Olgiati wrote: On Friday 04 May 2012 10:12 my mailbox was graced by a message from Rainer M Krug who wrote: I am workiong on a review using LibreOffice, and it works very nice - especially the print comments at the end of the document is very usefull. Now editors want the authors to reply to the comments individually, so it would be nice if the comments, including the line numbers and the pages, could be simply copied out of the document into the response to the editor. My question: is it possible to get the comments, in the same format with line numbers as in print comments at the end of thew document, in a text file? any format (txt, odt, ...) would be fine. A possible work-around, which I have used to extract the text of the notes from an Impress presentation: - Print your dicument to file as a .pdf - Use pdftotext to extract the text to a .txt file. Thanks for the tip - yes, I am working on Linux, but the text is converted to pictures in the pdf - I am using the CUPS pdf printer. Can I use a different printer? Dont use the CUPS .pdf printer, use the LO Print print to file option, Ah - OK - I'll try ... If I select the print to file option I have only the postscript option, and then I have exactly the same problems. In addition: the Page numbers are omitted in the ps2txt step - strange but true. I can convert the resulting .ps file to a .odt or equivalent via abiword, as mentioned above. Thanks for your help, Rainer Cheers, Ron. - -- Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany) Centre of Excellence for Invasion Biology Stellenbosch University South Africa Tel : +33 - (0)9 53 10 27 44 Cell: +33 - (0)6 85 62 59 98 Fax : +33 - (0)9 58 10 27 44 Fax (D):+49 - (0)3 21 21 25 22 44 email: rai...@krugs.de Skype: RMkrug -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk+k7hIACgkQoYgNqgF2egqpBQCdFwn798xk47BaYczhapHzPWDf LJgAnAzGng44YKxf8xMCQ1On/U/KpI6a =Hqpk -END PGP SIGNATURE- -- 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] Using Copy only visible cells version 1.0.5 on subtotal summary causes Calc to exit
LibreOffice 3.5.3.2 Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 O/S Ubuntu 12.04 Computer: Dell Inspiron 1545 Processor: Intel® Core™2 Duo CPU T6400 @ 2.00GHz × 2 Memory: 3.9 GiB *Using Copy only visible cells version 1.0.5 to copy subtotal summary causes Calc to exit * To illustrate, I have uploaded temp.ods To reproduce: *1:* Sort the sheet contents using two sort criteria: first b http://nabble.documentfoundation.org/file/n3964486/temp.ods temp.ods y scrip (A to Z, ascending) and second by date (oldest to newest, ascending). *2:* In Data, Subtotals, group by scrip and calculate subtotals for B/S and Total using sum. *3:* Click on 2 at the top left corner to show a summary for each scrip. *4:* Click on cell E1, hold shift down and click on cell O775. (At this point I open a terminal and run top to monitor %CPU and then return to the Calc window.) *5:* Click on copy visible cells. Result: The area selected (E1 to O775) is highlighted but does not get enclosed by the /marching ants marquee/ associated with cells that are copied. The highlight then seems to extend itself (without any intervention by me) to the entire Calc screen (and presumably from A1 to AMJ1048576?). %CPU in top rises to 90% in a few seconds and Calc closes itself within ~ 10 sec of clicking on copy visible cells. The same thing happens with a smaller data set. In other words, if I sort the spreadsheet as above and then delete row 189 onwards to have a smaller data set, the same thing happens except that Calc takes even less time to exit. -- View this message in context: http://nabble.documentfoundation.org/Using-Copy-only-visible-cells-version-1-0-5-on-subtotal-summary-causes-Calc-to-exit-tp3964486.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] Using Copy only visible cells version 1.0.5 on subtotal summary causes Calc to exit
Hi, This extension was developed by Gustavo Pacheco, member of brazilian libreoffice community. I'll send this messagem for him. Best Eliane Domingos de Sousa Brazilian LibreOffice Community Em 05-05-2012 09:24, chimak111 escreveu: LibreOffice 3.5.3.2 Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 O/S Ubuntu 12.04 Computer: Dell Inspiron 1545 Processor: Intel® Core™2 Duo CPU T6400 @ 2.00GHz × 2 Memory: 3.9 GiB *Using Copy only visible cells version 1.0.5 to copy subtotal summary causes Calc to exit * To illustrate, I have uploaded temp.ods To reproduce: *1:* Sort the sheet contents using two sort criteria: first b http://nabble.documentfoundation.org/file/n3964486/temp.ods temp.ods y scrip (A to Z, ascending) and second by date (oldest to newest, ascending). *2:* In Data, Subtotals, group by scrip and calculate subtotals for B/S and Total using sum. *3:* Click on 2 at the top left corner to show a summary for each scrip. *4:* Click on cell E1, hold shift down and click on cell O775. (At this point I open a terminal and run top to monitor %CPU and then return to the Calc window.) *5:* Click on copy visible cells. Result: The area selected (E1 to O775) is highlighted but does not get enclosed by the /marching ants marquee/ associated with cells that are copied. The highlight then seems to extend itself (without any intervention by me) to the entire Calc screen (and presumably from A1 to AMJ1048576?). %CPU in top rises to90% in a few seconds and Calc closes itself within ~ 10 sec of clicking on copy visible cells. The same thing happens with a smaller data set. In other words, if I sort the spreadsheet as above and then delete row 189 onwards to have a smaller data set, the same thing happens except that Calc takes even less time to exit. -- View this message in context: http://nabble.documentfoundation.org/Using-Copy-only-visible-cells-version-1-0-5-on-subtotal-summary-causes-Calc-to-exit-tp3964486.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] Impress on mac g4 - graphics filter not found
I am trying to put together a picture presentation using Impress. Using a mac mini running Lion I am having no problem. As the presentation will be given elsewhere I want to use a G4 laptop running osx 10.4.11. Transfering the file fails to work as it fails to include all of the pictures. Any attempt to rebuild on the G4 fails as it says Graphics filter not found on most of the pictures, all jpeg. I can use some other pictures, as a test, but there seems to be no consistency. I am using LibreOffice 3.5.3.2 on the G4 and LibreOffice 3.5.0rc3 on the mac mini. If anyone can help I will be grateful, the presentation is for Monday evening. Dave Lawson dave.la...@btinternet.com davidslaw...@btinternet.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] Re: Using Copy only visible cells version 1.0.5 on subtotal summary causes Calc to exit
Am 05.05.2012 14:24, chimak111 wrote: LibreOffice 3.5.3.2 Build ID: 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 O/S Ubuntu 12.04 Computer: Dell Inspiron 1545 Processor: Intel® Core™2 Duo CPU T6400 @ 2.00GHz × 2 Memory: 3.9 GiB *Using Copy only visible cells version 1.0.5 to copy subtotal summary causes Calc to exit * Well this happens all the time when Basic mongers and macro recorders publish their home grown bullshit as office extensions. The most important parts (any error handling) has been removed as the following unused function indicates: 'Sub initStrLocale as String ' Dim PathSubstitutionService As Object ' PathSubstitutionService = createUnoService(com.sun.star.util.PathSubstitution) ' OOLangue = PathSubstitutionService.getSubstituteVariableValue($(langid)) ' Select Case OOLangue ' Case 1046 ' Brazilian Portuguese 'strMsg(0) = Esta função não pode ser utilizada com seleções múltiplas. 'strMsg(1) = LibreOffice ' Case 1033 ' English USA 'strMsg(0) = This function cannot be used with multiple selections. 'strMsg(1) = LibreOffice ' Case 2057 ' English GB 'strMsg(0) = This function cannot be used with multiple selections. 'strMsg(1) = LibreOffice ' Case 1036 ' French 'strMsg(0) = Cette fonction est incompatible avec la sélection multiple. 'strMsg(1) = LibreOffice ' Case 1034,3082 ' Spanish 'strMsg(0) = Esta función no se puede aplicar con selecciones múltiples. 'strMsg(1) = LibreOffice ' End Select 'End Sub -- 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] strange scrollbar behaviour
RESEND Hello, This is not really new, but I didn't take the time till now to report it. When I click somewhere on the scrollbar in a Writer document, the part of the text will jump up or down by about one window. So far so good. When I click in the last centimeter of the scrollbar, however, just above teh 3 icons (e.g. 'search further below' or '.. up', 'navigation'), the text will on the contrary go up line by line. Is this normal behaviour? Why? Thanks for your comments. This is LO 3.5.3 (NL version) on an iMac with Lion 10.7.3 I haven't looked for bug reports yet. -- Guy using LibO 3.5 3.5.1 on a iMac Intel DualCore Lion -- please reply only to users@global.libreoffice.org -- Dodoes can't afford to have headaches -- Guy using LibO 3.5.2 on a iMac Intel DualCore Lion -- please reply only to users@global.libreoffice.org -- Dodoes can't afford to have headaches -- 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: Unable to start my newly installed LibreOffice v3.5.2 programs.
FYI thanks to Tom Davies' e-mailed suggestions (I thought we were still conversing on the public mailing list and replied to the wrong thread should be in my original one]): 1. Uninstalling Java did not fix the problem. Installing u32 did not help which is not a surprise. 2. Portable LibreOffice v3.4.5 and v3.5.2 without installed LO did crashed too. HOWEVER, portable v3.3.4 worked. I believe this is close to OpenOffice v3.3.0 I had installed and working before I tried LO. Were there major changes after v3.3.(0/4) or something for LO? 3. I reported my issue to as a bug at https://www.libreoffice.org/bugzilla/show_bug.cgi?id=49499 ... Hopefully, someone (a developer) else can help (no replies/updates so far). :( -- Quote of the Week: Bother, said Winnie the Pooh, as the ants devoured him. /\___/\ Ant(Dude) @ http://antfarm.ma.cx (Personal Web Site) / /\ /\ \ Ant's Quality Foraged Links: http://aqfl.net | |o o| | E-mail: phi...@earthlink.net/a...@zimage.com \ _ / If crediting, then please kindly use Ant nickname ( ) and AQFL URL/link. -- 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] basic makro DBase connection
Hallo, Is it possible, to connect to an DBase file like test.dbf without prior registration using makros? I tried: ... oDataSource=oDataBaseContext.getByName(file:///test.dbf) ... giving the error message: ... no approriate SDBC driver found. What is my mistake/misconception? Walther -- 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: Unable to start my newly installed LibreOffice v3.5.2 programs.
On 5/5/2012 12:10 PM, Ant wrote: FYI thanks to Tom Davies' e-mailed suggestions (I thought we were still conversing on the public mailing list and replied to the wrong thread should be in my original one]): 1. Uninstalling Java did not fix the problem. Installing u32 did not help which is not a surprise. 2. Portable LibreOffice v3.4.5 and v3.5.2 without installed LO did crashed too. HOWEVER, portable v3.3.4 worked. I believe this is close to OpenOffice v3.3.0 I had installed and working before I tried LO. Were there major changes after v3.3.(0/4) or something for LO? 3. I reported my issue to as a bug at https://www.libreoffice.org/bugzilla/show_bug.cgi?id=49499 ... Hopefully, someone (a developer) else can help (no replies/updates so far). :( Follow your bug report. They are asking for information. -- David -- 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: Unable to start my newly installed LibreOffice v3.5.2 programs.
3. I reported my issue to as a bug at https://www.libreoffice.org/bugzilla/show_bug.cgi?id=49499 ... Hopefully, someone (a developer) else can help (no replies/updates so far). :( Follow your bug report. They are asking for information. I already gave that requested information out in my original bug report (read the whole thing? :P). I just ran CCleaner to remove HDD and registry left overs. No fix. :( -- 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] strange scrollbar behaviour
On Sat, 2012-05-05 at 17:59 +0200, Guy Voets wrote: RESEND Hello, This is not really new, but I didn't take the time till now to report it. When I click somewhere on the scrollbar in a Writer document, the part of the text will jump up or down by about one window. So far so good. When I click in the last centimeter of the scrollbar, however, just above teh 3 icons (e.g. 'search further below' or '.. up', 'navigation'), the text will on the contrary go up line by line. Is this normal behaviour? Why? Thanks for your comments. This is LO 3.5.3 (NL version) on an iMac with Lion 10.7.3 I haven't looked for bug reports yet. -- Guy It is not really strange behavior: it is the expected behavior. Perhaps the problem is a small change in the scrollbar. It use to have an arrow at each end of it (vertical or horizontal) to move the text up or down one line. Now, an additional up arrow has been added near the bottom of the vertical scrollbar. This permits a person to quickly go up or down a line without having to move the cursor more than a few centimeters. --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] Re: Unable to start my newly installed LibreOffice v3.5.2 programs.
On 5/5/2012 1:56 PM, Ant wrote: 3. I reported my issue to as a bug at https://www.libreoffice.org/bugzilla/show_bug.cgi?id=49499 ... Hopefully, someone (a developer) else can help (no replies/updates so far). :( Follow your bug report. They are asking for information. I already gave that requested information out in my original bug report (read the whole thing? :P). I just ran CCleaner to remove HDD and registry left overs. No fix. :( Yes I did. And it rambles on just like your messages do here. This list, IIUC, is a 'how do I do this' type of help list populated mostly with fellow users. From the other posts it is fairly obvious that ho one else has, or has had, this problem. The LO Bugzilla is the place to get help with problems like you describe. Where the developers hang out. My suggestion? Follow the bug and do what the developers ask you to do *if* you are really looking for a solution. Or don't. Your choice. -- David -- 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