[libreoffice-users] Dear libreoffice
Hello, my name is Colin Lichtwark. I am a postgraduate student at Swinburne University in Melbourne Australia. I am trying to use ubuntu as much as possible but the issue I have is with libre office note having an effective citation manager interface especially with mendeley. I feel this is a huge impedance to the popular adoption of ubuntu.Is the work being done in this area with your software development?. Yours Sincerely, Colin Lichtwark -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Dear libreoffice
Original Message From: Colin James Lichtwark coli...@gmail.com To: users@global.libreoffice.org users@global.libreoffice.org Date: Thu, 8 May 2014 07:26:38 +1000 Hello, my name is Colin Lichtwark. I am a postgraduate student at Swinburne University in Melbourne Australia. I am trying to use ubuntu as much as possible but the issue I have is with libre office note having an effective citation manager interface especially with mendeley. I feel this is a huge impedance to the popular adoption of ubuntu.Is the work being done in this area with your software development?. Yours Sincerely, Colin Lichtwark Hi Colin, I think you are looking at this the wrong way round. Mendeley already has an Ubuntu plugin to interface LibreOffice. It seems they initially had some problems with this plug-in, but according to this thread http://support.mendeley.com/customer/portal/questions/1384344-mendeley-plugin-for-libreoffice-4-1-4- it now works as advertised. I may be wrong, because I am not a Mendeley user (my personal preference is Zotero) but from what I read the plug-in appears to be part of the Mendeley Desktop package, or at least available from the Mendeley Tools - Install LibreOffice/OpenOffice Plugin, see: http://www.mendeley.com/features/reference-manager/ Hope this helps. Regards Dave -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Dear libreoffice
Colin, Thanks for posting! LibreOffice is a community of volunteer users designers and developers. With some corporate sponsorship of all facets. Point is, that you are more than welcome to volunteer the effort to improve the product, but no one is going to do so for you simply at your behest. In fact a release build of the 4.2 branch offers reliable cross referencing and footnotes, and with current development builds (pre-4.3.0) citation and parenthetical notation has been further cleaned up. Additionally the Zotero project (Center for History and New Media (CHNM) at George Mason University) already offers a fully functional extension for LibreOffice that meets technical and academic users requirements on Ubuntu and all other OSs running LibreOffice. The Mendeley project (now owned by Elsevier publishing) offers comparable functions including a citation plugin supporting Word, LibreOffice and BibTex. If you have specific issues of incompatibility, you can contribute by writing up and submitting complete bug reports and submitting to the appropriate project. Regards, Stuart Foote LibreOffice QA volunteer The University of Texas at San Antonio -- View this message in context: http://nabble.documentfoundation.org/Dear-libreoffice-tp4107984p4108001.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Automating creation of PDF from Calc
Hi all I have a requirement to generate PDF's from specific set sheets contained in one Calc document, the document has 85 individual sheets. I've generated a macro to do this, having first recorded the steps using the macro recorder. Though the steps to record the macro worked perfectly as only the individual selection, i.e, all the cells on a specific sheet, was generated as a PDF. If I then run the macro with the same selection it always creates a PDF of the entire document - all 85 sheets instead of just the selection! Here's the recorded macro, note the selection $A$1:$G$35 sub exporttopdf rem -- rem define variables dim document as object dim dispatcher as object rem -- rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService(com.sun.star.frame.DispatchHelper) rem -- dim args1(0) as new com.sun.star.beans.PropertyValue args1(0).Name = ToPoint args1(0).Value = $A$1:$G$35 dispatcher.executeDispatch(document, .uno:GoToCell, , 0, args1()) rem -- dim args2(2) as new com.sun.star.beans.PropertyValue args2(0).Name = URL args2(0).Value = file:///home/alex/example.pdf args2(1).Name = FilterName args2(1).Value = calc_pdf_Export args2(2).Name = FilterData args2(2).Value = Array( _ Array(UseLosslessCompression,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(Quality,0,90,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ReduceImageResolution,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(MaxImageResolution,0,300,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(UseTaggedPDF,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(SelectPdfVersion,0,0,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ExportNotes,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ViewPDFAfterExport,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ExportBookmarks,0,true,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(OpenBookmarkLevels,0,-1,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(UseTransitionEffects,0,true,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(IsSkipEmptyPages,0,true,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(IsAddStream,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(FormsType,0,0,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ExportFormFields,0,true,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(AllowDuplicateFieldNames,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(HideViewerToolbar,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(HideViewerMenubar,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(HideViewerWindowControls,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ResizeWindowToInitialPage,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(CenterWindow,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(OpenInFullScreenMode,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(DisplayPDFDocumentTitle,0,true,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(InitialView,0,0,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(Magnification,0,0,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(Zoom,0,100,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(PageLayout,0,0,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(FirstPageOnLeft,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(InitialPage,0,1,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(Printing,0,2,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(Changes,0,4,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(EnableCopyingOfContent,0,true,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(EnableTextAccessForAccessibilityTools,0,true,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ExportLinksRelativeFsys,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(PDFViewSelection,0,0,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ConvertOOoTargetToPDFTarget,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(ExportBookmarksToPDFDestination,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(SignPDF,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(_OkButtonString,0,,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(Watermark,0,,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(EncryptFile,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(PreparedPasswords,0,,com.sun.star.beans.PropertyState.DIRECT_VALUE), _ Array(RestrictPermissions,0,false,com.sun.star.beans.PropertyState.DIRECT_VALUE), _
[libreoffice-users] Draw PDF Files
Greetings To The Libre Office World! We are running Libre Office 4.2 under Linux Mint 14. Draw states that it is capable of opening PDF files. This functionality is a bit sketchy. Either the document will not display at all in draw, or it displays with all of the fonts, and page layouts askew. Is this a known issue, or just unique to us? -- *Brian Colucci* *Information Technology Manager* MedWork_Logo_CMYK.jpg *MedWork Occupational Health Care* *1435 Cincinnati Street* *Suite 100* *Dayton, Ohio 45417 * Direct Line: (937)-449-0898 Fax: (937)-449-0881 E-Mail: bacolu...@medworkohio.com mailto:bacolu...@medworkohio.com Web Site: www.medworkohio.com http://www.medworkohio.com/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Draw PDF Files
2014-05-08 16:02 GMT+02:00 Brian A. Colucci bacolu...@medworkohio.com: We are running Libre Office 4.2 under Linux Mint 14. Draw states that it is capable of opening PDF files. This functionality is a bit sketchy. Either the document will not display at all in draw, or it displays with all of the fonts, and page layouts askew. Is this a known issue, or just unique to us? I have yet to see a PDF that is not displayed in Draw, so that might be a specific issue you have. However, here's my experience with it so far: PDF in Draw have always felt more like a hack than anything. It doesn't seem to handle embedded fonts, and for fonts available on the system, the rendering is different, including different spacing between letters. Images and various graphics elements tend to get out well, but from time to time you'll come across a graphic that's on the wrong side of a page. This behavior have been relatively consistent between LO version since PDF opening was introduced, and to be fair the very nature of a PDF, especially how the format is laid out internally, makes opening them for edition quite a challenge. This tool is still useful for some use cases, tough, and I've used it some times, mainly to extract graphics without losing quality. But it's not a PDF editor, at least not yet (obstacles can certainly be overcome, but that's not what I'd call a priority in an Office edition suite. my 2cts of course). -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Draw PDF Files
On 05/08/2014 10:10 AM, Cley Faye wrote: 2014-05-08 16:02 GMT+02:00 Brian A. Colucci bacolu...@medworkohio.com: We are running Libre Office 4.2 under Linux Mint 14. Draw states that it is capable of opening PDF files. This functionality is a bit sketchy. Either the document will not display at all in draw, or it displays with all of the fonts, and page layouts askew. Is this a known issue, or just unique to us? I have yet to see a PDF that is not displayed in Draw, so that might be a specific issue you have. However, here's my experience with it so far: PDF in Draw have always felt more like a hack than anything. It doesn't seem to handle embedded fonts, and for fonts available on the system, the rendering is different, including different spacing between letters. Images and various graphics elements tend to get out well, but from time to time you'll come across a graphic that's on the wrong side of a page. This behavior have been relatively consistent between LO version since PDF opening was introduced, and to be fair the very nature of a PDF, especially how the format is laid out internally, makes opening them for edition quite a challenge. This tool is still useful for some use cases, tough, and I've used it some times, mainly to extract graphics without losing quality. But it's not a PDF editor, at least not yet (obstacles can certainly be overcome, but that's not what I'd call a priority in an Office edition suite. my 2cts of course). YES, It may be the PDF file itself. For me, with Linux Mint 16/MATE, Some PDF files display just like the PDF reader shows them. Yet, other files have issued with the alignment. I do not use Draw much, but every time I open a PDF file in draw, to make an image of the page or part of the page, it just seems that some PDF file work while others do not. I even have a PDF file that views properly in the PDF reader but will not print out properly. I had to open the PDF document in Draw to print out the needed pages. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Automating creation of PDF from Calc
At 14:23 08/05/2014 +0100, Alex McMurchy wrote: I have a requirement to generate PDF's from specific set sheets contained in one Calc document, the document has 85 individual sheets. You could set print ranges (Format | Print Ranges) on all the relevant sheets - which could cover either entire sheets or ranges, even multiple ranges, within them - and then either use File | Export as PDF... (or the Export Directly as PDF button in the Standard toolbar) or print to a virtual PDF printer (free versions are available). Or have I misunderstood the detail of your requirement? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Dear libreoffice
Use Zotero On 5/7/14, 1:26 PM, Colin James Lichtwark wrote: Hello, my name is Colin Lichtwark. I am a postgraduate student at Swinburne University in Melbourne Australia. I am trying to use ubuntu as much as possible but the issue I have is with libre office note having an effective citation manager interface especially with mendeley. I feel this is a huge impedance to the popular adoption of ubuntu.Is the work being done in this area with your software development?. Yours Sincerely, Colin Lichtwark -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Export Notes from Impress
Hi: I've searched through help and couldn't find any mention of this, but I would like to export only the Notes from a presentation I have in Impress; this is to aid in writing a more extensive script. What I would like is to have a document (no specific type, but a Writer document (odt) or a plain text document (.txt) would be ideal. The contents would simply be a paragraph or section for each Slide, perhaps formatted as Slide Number: text ... text et cetera. Is there any way to accomplish this? Also, is there any way to import notes (other than block copying each one) from an external document into the Impress presentation (similar to how one would import an outline, although in this case, the slides would already exist)? Thanks for any hints. -- View this message in context: http://nabble.documentfoundation.org/Export-Notes-from-Impress-tp4108045.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Need help with Base
I don't have a clue how to connect to a specific schema within a PostgreSQL database though, LO only seems to be able to connect the default schema. Perhaps this might help: (chapter 5.7) http://www.postgresql.org/docs/9.3/static/ddl-schemas.html The point is not how to create a schema from within PgAdmin. I know how to work with PostgreSQL, I've been using it for years. The point is how to connect LO to a given, existing schema in a PostgreSQL database. Of course I can set a redirection to one target schema within PostgreSQL, but that would make it impossible to connect to a different schema within the same database. Sincerely, Wolfgang -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Need help with Base
Le 08/05/14 19:01, Wolfgang Keller a écrit : Hi Wolfgang, The point is how to connect LO to a given, existing schema in a PostgreSQL database. I take it that schema=myschema doesn't work as a key/value pair ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Need help with Base
I made a spreadsheet with a data-table in Excel2010 and opened it at home with LibreOffice3.5.7.2 I don't know much about spreadsheets, but notice some differences: - The data-table in Excel would keep the column headers visible on top when scrolling down (without setting the header row blocked manually) - The pivot table I made in Excel misses some data - The data table doesn't have the coloured rows (alternating colour-no colour) anymore Is this expected behaviour, or should I have imported it in some special way in LibreOffice? Ludo -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Excel import
Apologies; I noticed I didn't change the subject in my previous mail a minute ago On Thu, May 8, 2014 at 8:29 PM, Ludo Beckers lazy...@gmail.com wrote: I made a spreadsheet with a data-table in Excel2010 and opened it at home with LibreOffice3.5.7.2 I don't know much about spreadsheets, but notice some differences: - The data-table in Excel would keep the column headers visible on top when scrolling down (without setting the header row blocked manually) - The pivot table I made in Excel misses some data - The data table doesn't have the coloured rows (alternating colour-no colour) anymore Is this expected behaviour, or should I have imported it in some special way in LibreOffice? Ludo -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Export Notes from Impress
The only way I know to do either is to go slide by slide ... slow but true; I too will be looking forward to hearing if these whiz-kids with their shortcuts have a quicker method. From: CVAlkan fobe...@enteract.com Date: Thu, May 8, 2014 at 11:22 AM Subject: [libreoffice-users] Export Notes from Impress To: users@global.libreoffice.org Hi: I've searched through help and couldn't find any mention of this, but I would like to export only the Notes from a presentation I have in Impress; this is to aid in writing a more extensive script. What I would like is to have a document (no specific type, but a Writer document (odt) or a plain text document (.txt) would be ideal. The contents would simply be a paragraph or section for each Slide, perhaps formatted as Slide Number: text ... text et cetera. Is there any way to accomplish this? Also, is there any way to import notes (other than block copying each one) from an external document into the Impress presentation (similar to how one would import an outline, although in this case, the slides would already exist)? Thanks for any hints. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Word input field not recognize by Libreoffice
I can work on word input field using openoffice via reflection, but I can't do the same with libreoffice, whenever I open a word document containing those text fields they become simple text!Thanks -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Need help with Base
Hi :) Sorry about my replies to this idea of using macros! i don't use nor understand macros at all. From what people have been saying to me off-list it sounds like they are much more efficient than i had assumed. Plus it sounds like there is some scope for building a whole proper app that way. It sounds well worth exploring! :) Anyway, many apols and regards from Tom :) On 7 May 2014 10:17, Tom Davies tomc...@gmail.com wrote: Hi :) Macros are code running on a desktop machine right? So don't they take up cpu cycles? If the macro code is then running stuff through Sql code then it's going to take more Cpu cycles than just running Sql alone. So in terms of network traffic they might not count for much but in terms of end-user experience it might be critical on low-spec machines. As for visualisation of data SQL statements built-up through the Base gui can show the resultant data neatly in a table that looks like a spreadsheet. I don't think macros can do that. A proper programmer might be able to visualise data more easily without the distraction of something being right in front of her/his eyes and thus obscuring abstractions and specific cases at extreme ends of the possible data but most of us need to see something 'concrete' before we can begin to start on that sort of visualisation. On the other hand if macro language is easier to understand and code for then that might well be the best route for surest victory right now. Perhaps look into using a gui to build Sql statements after you have first got something running using macros. Release early and release often. The macro version would be the 1.1 and the non-macro would be the 2.0 with advantages such as being faster. People could buy into either one without having to worry about incompatibility issues when trying to communicate with people using the other. Also learning the LO macro language means you can write macros to do other things and unlike with MS macros don't have to worry much about those macros becoming out-dated by the next release of LO or AOO or AndrOO or whatever. Regards from Tom :) On 7 May 2014 08:20, Fernand Vanrie s...@pmgroup.be wrote: On 6/05/2014 22:35, Girvin Herr wrote: Tom Milica, No! No! No! I am not offering to do the work. I apologize if I somehow implied that. I have zero experience writing LO macros of any sort. I was just suggesting to avoid macros wherever possible. Recreating data entry forms and reports when there is a need to migrate to another client (front end) is enough of a problem without having to re-write macros too. I use the Base query editor as Tom suggests, which is a nice GUI shell around the SQL, to create my table data relationships, aliases and sorts. It is very similar to what Access 1.1 had to define similar relationships. It works great. If you want to see the underlying SQL, it can switch modes to show the SQL and even test run it to see the resultant output in table form. I was just suggesting to look at using a query or two rather than macros, wherever possible. Another aspect of this is that a query should run the actions, such as a sort, on the database server (back-end) and should run faster than a macro running in Base. Using a proper SQL server + Macro's + dialogs (no forms) but using the dialog controls to visualise the data is not the easyist way but opens a never ending route. I am curious: Does the Base macro engine run in Java? Has anyone tested this probable speed difference? not the macro's make a difference , you just use a macro visualise the data and to pass the SQL statements to the server who change , update or delivers the data. Only the connection with your server and the data volumes influence the speed. Girvin On 05/06/2014 03:52 AM, Tom Davies wrote: Hi :) Can you post some of the old macros as plain text and give a rough idea of what each does. SQL is usually easier because you get a nice gui to do a lot of the work in a nice pointclick way. Some of the algebraic formulae might be much the same or perhaps a little less convoluted. Plus Sql is more generic and less dependant on specific product and versions. On the other hand the LibreOffice/OpenOffice macro language is also much less version-specific than MS macros. I'm not certain that Girvin is offering to do the work for free. Knowing him he probably is but it might be better if there was a potential for payment for work done, unless exchange-rates make that unworkable (as often happens). Regards from Tom :) On 6 May 2014 07:45, milica miljkovic.milica...@gmail.com wrote: Dear Girvin, I have that base that we use in our workshop like warehouse management,(select product, type amount that needs to be added/removed from warehouse and macro does it) and also base needs to create work orders based on calculation (for every product, how many half products there is to be made)
Re: [libreoffice-users] Automating creation of PDF from Calc
Hi Brian I want to do it via a macro. Out of the 85 sheets in the document I would want to create PDFs for 24 of them. I would soon get bored or make mistakes if I generated each manually. Really what I'm looking for is to see if anyone can point me in the direction of the documentation for the API properties for exporting to PDFs. Thanks Alex On Thursday 08 May 2014 15:43:43 Brian Barker wrote: At 14:23 08/05/2014 +0100, Alex McMurchy wrote: I have a requirement to generate PDF's from specific set sheets contained in one Calc document, the document has 85 individual sheets. You could set print ranges (Format | Print Ranges) on all the relevant sheets - which could cover either entire sheets or ranges, even multiple ranges, within them - and then either use File | Export as PDF... (or the Export Directly as PDF button in the Standard toolbar) or print to a virtual PDF printer (free versions are available). Or have I misunderstood the detail of your requirement? I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Word input field not recognize by Libreoffice
Word input field not recognize by Libreoffice I can work on word input field using openoffice via reflection, but I can't do the same with libreoffice, whenever I open a word document containing those text fields they become simple text!Thanks -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: crash - crash - crash - crash. !@#$#@!
On 05/04/2014 04:34 AM, Tom Davies wrote: Hi Tom :) Good answers to Urmas there. Considerate, understanding and light-hearted. Nicely done! :) Did I miss something? Who/what is Urmas? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: crash - crash - crash - crash. !@#$#@!
@NoOp Full threads in context are available on the Nabble service: http://nabble.documentfoundation.org/Users-f1639498.html From: NoOp gl...@sbcglobal.net Sent: Thursday, May 08, 2014 9:15 PM To: users@global.libreoffice.org Subject: [libreoffice-users] Re: crash - crash - crash - crash. !@#$#@! On 05/04/2014 04:34 AM, Tom Davies wrote: Hi Tom :) Good answers to Urmas there. Considerate, understanding and light-hearted. Nicely done! :) Did I miss something? Who/what is Urmas? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Export Notes from Impress
At 09:22 08/05/2014 -0700, Frank CVAlkan Oberle wrote: I've searched through help and couldn't find any mention of this, but I would like to export only the Notes from a presentation I have in Impress; this is to aid in writing a more extensive script. What I would like is to have a document (no specific type, but a Writer document (odt) or a plain text document (.txt) would be ideal. The contents would simply be a paragraph or section for each Slide, perhaps formatted as Slide Number: text ... text et cetera. Is there any way to accomplish this? Here's a possible workaround: o Install a virtual PDF printer. o Print the presentation to the virtual PDF printer, selecting Notes under Print content | Content in the Print dialogue. o Open the PDF in your favourite viewer and save the text as a plain text document. o Edit out any text from the slides themselves (which may initially be a useful guide to which slides the notes belong to). It should be fairly straightforward to do this. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Automating creation of PDF from Calc
At 19:56 08/05/2014 +0100, Alex Kempshall wrote: On Thursday 08 May 2014 15:43:43 Brian Barker wrote: At 14:23 08/05/2014 +0100, Alex McMurchy wrote: I have a requirement to generate PDF's from specific set sheets contained in one Calc document, the document has 85 individual sheets. You could set print ranges (Format | Print Ranges) on all the relevant sheets - which could cover either entire sheets or ranges, even multiple ranges, within them - and then either use File | Export as PDF... (or the Export Directly as PDF button in the Standard toolbar) or print to a virtual PDF printer (free versions are available). I want to do it via a macro. So you have the same problem as the Alex McMurchy who made the original enquiry? I'd hoped you had a problem and were looking for a solution - whatever it might be. Out of the 85 sheets in the document I would want to create PDFs for 24 of them. I would soon get bored or make mistakes if I generated each manually. I don't want to argue, but I didn't see anything in your macro that referred to the separate sheets, so you appear to have to run the macro manually on each sheet in any case. But chacun à son goût. Good luck! Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: crash - crash - crash - crash. !@#$#@!
On 05/08/2014 07:28 PM, V Stuart Foote vstuart.fo...@utsa.edu wrote: @NoOp Full threads in context are available on the Nabble service: http://nabble.documentfoundation.org/Users-f1639498.html Thanks, I can read full threads. I had filtered Urmas some time back. However, my question was more directed towards Tom Davies who jumped into the same subthread following Tom Cloyd's response to me. From: NoOp gl...@sbcglobal.net Sent: Thursday, May 08, 2014 9:15 PM To: users@global.libreoffice.org Subject: [libreoffice-users] Re: crash - crash - crash - crash. !@#$#@! On 05/04/2014 04:34 AM, Tom Davies wrote: Hi Tom :) Good answers to Urmas there. Considerate, understanding and light-hearted. Nicely done! :) Did I miss something? Who/what is Urmas? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted