Re: [tdf-discuss] LO Base Enhancements
Wolfgang Keller schreef op 05/08/2014 12:05: +1 we use the native mysql connector and macro's + dialogs + writer+ calc for having a complet CRM and SRM platform with +100 users working in the office and at home (VPN connections) only using LO and a MySQL server. greetz Fernand I can´tjudge whether your idea is good or not. But I know that there are around the worldonly two or three developers for base. Pity because Base is (could be?) imho actually *the* killer component of LO. For everything else there are other free solutions. In fact I see the rest of LO (Calc and Writer) just as a reporting framework for Base. It is inhuman to demand major changes of these few people. We must be grateful that these eliminate the bugs. That would be an argument in favour of not re-inventing wheels and instead just ship drivers for client-server RDBMSs while concentrating on the client implementation. Sincerely, Wolfgang -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] macro compatibility between LO and AOO?
On 4/03/2013 8:27, M. Fioretti wrote: On Mon, Mar 04, 2013 08:16:25 AM +0100, Fernand Vanrie wrote: 99% percent , changes comes and will come from incompatiliteis in de API. for now this is OK, small changes from version to version, but nothing who not can been repaired or handled with the code( basic) itself I knew that. The sense of my question is, is there is a list of things to avoid beforehand, rather than wait that they break and fix the code? thats more a question for the developers list . libreoff...@lists.freedesktop.org and fore the aOO counterpart ooo-...@incubator.apache.org Thanks, Marco -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] macro compatibility between LO and AOO?
Op 04/03/2013 07:53, M. Fioretti schreef: (sorry if this comes in twice, my email server had problems earlier today)Reply-To: M. Fioretti mfiore...@nexaima.net Greetings, the subject says it all. I have already searched online, and am looking at the manual but apparently (maybe I used the wrong terms) it is not easy to find CURRENT information on macro compatibility between LO 4 and AOO 3.4.1: will all macros created in one tool also work in the other? 99% percent , changes comes and will come from incompatiliteis in de API. for now this is OK, small changes from version to version, but nothing who not can been repaired or handled with the code( basic) itself If not, why and when? What are the reasons/cases when a macro is not portable? are there any guidelines/best practices to write portable macros? Thanks in advance for any pointer! Marco http://mfioretti.com -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] using PDF as Graphic Format in 3.5
Hallo, Do not know if this is the good list ? It can not be a big problem to make PDF a acepted graphic format for LO. (PDF insert as a picture) These day's PDF is a overall standard even to stock pictures. Most Graphic apllications accept pictures in PDF format . In LO we can only show a PDF as a OLE object . - this OLE object have a wrong sised window - this is no longer posible in 3.5 Greetz Fernand -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] LibreOffice in press release about extensions
Christophe , Wat kind of extensions ? Greetz Fernand Hi, At K.U.Leuven we have been working on three extensions for LibreOffice and OpenOffice.org. One of them is new; two others will be updated this week. We are planning a press release about this and would like to know how LibreOffice and TDF would like to be mentioned in this. The current text is: LibreOffice (http://www.libreoffice.org/) is a free and open-source office suite developed by The Document Foundation as a fork of OpenOffice.org. The Document Foundation was formed in September 2010 and has released several new versions of LibreOffice since that time. New code in LibreOffice is developed under a double license: GNU Lesser General Public License Version 3 (LGPLv3) and the Mozilla Public License (MPL). (This text appears below two other paragraphs that describe/introduce OpenOffice.org and the ODF standard.) Best regards, Christophe -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Error in scripting framework
Cor , +1 greetz Fernand Hi Olivier, Olivier Hallot wrote (12-09-11 17:39) Couldn't we write just Oh dear, I am unable to find a macro you asked me to execute!? Would the following be acceptable: Error: the macro you are trying to execute (libName.modName.fnName) could not be found. Cheers, -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Poor Quality 3D charts
Maybe its simply a bug or a enhancement, but i hope somebody, who worked on the 3D charts is reading ? 2 D charts can been exported to PDF or even EPS . The shapes are Vector-based and can been used for high quality printing. 3 D charts however can not been used for PDF /A-1a export because of some transparency problems. A work around is exporting the charts as EPS files, but part of this 3D charts contains rasterised (72 dpi) ellements . The problem is that this rasterised 3D-effects at 72 dpi are fine for Screen reproduction but to low for High Quality Printing where we need at least 254 DPI. Can this been fixed or are we stuck with this 72 DPI ? Thanks for any explanation Fernand -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Fuzzy pictures on PDF export
Christian, Thanks for this tip, but we must been aware that transparency is still not possible when the document must been printed with machines using Postscript ( most professional printers) Greetz Fernand On Fri, Jul 29, 2011 at 8:53 AM, Fernand Vanries...@pmgroup.be wrote: Sometimes, the PDF converter make a picture at 96 dpi off the parts off the doc ( a frame, table or even the complete document) who contains elements who can not been converted to PDF. Transparency is the most likely cause for this . Then your text is in pixels at 96 dpi and looks crispy. Transparency is only a problem when you use the restricted PDF-A1 format, regular PDF supports transparency. So if the picture quality export setting using regular PDF-export doesn't solve the problem, then file a bug and attach a sample document with the image and a PDF produced by OOo and one by LO for comparison. ciao Christian -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Fuzzy pictures on PDF export
Matthew, Sometimes, the PDF converter make a picture at 96 dpi off the parts off the doc ( a frame, table or even the complete document) who contains elements who can not been converted to PDF. Transparency is the most likely cause for this . Then your text is in pixels at 96 dpi and looks crispy. Greetz Fernand I originally created my document using OpenOffice. During the riff raff IP wars, I converted to LibreOffice. My document is in ODT format and looks good with a little tweaking (and learning curve built-in). I also created all of my pictures (inserted into the document) in OpenOffice as XCF initially .. and inserted them into the doc as JPG. When using OpenOffice and following this procedures, my PDF export showed all text and pictures with crystal clarity. However, upon converting to LibreOffice, while my doc looks good as ODT, when I export ... all the text is crisp while the pictures are fuzzy comparatively. I suspect this is a user issue. I just don't know which use issue it is. Please advise/help. PS For grins, I've cut and pasted XCF into the ODT and exported to PDF with same result. Similarly, I converted XCF to GIF and JPG with same result. It is apparent I'm clueless. Cheers. Matthew -- View this message in context: http://nabble.documentfoundation.org/Fuzzy-pictures-on-PDF-export-tp3208779p3208779.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] ignore m$ legacy?
Andrew , Others I agree with the point of view of Andrew. Please make LO OPEN as maximum as possible different formats. I say open not SAVE as... We are a Editing House where our 30 fulltime journalists using OO (forced by us), the more than 100 freelancers recieved on regular base CD's for installing OO and also LO. They like the product because the use it for opening all sort of documents and ist FREE :-). But finaly only 20 % are sending there copy in OO-LO format and 80% still in MS format (all sort off versions). Thats the reality, because our Freelancers continuing using MS for their daily work simply because 99% off there clients are using MS. Greetz Fernand -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Sending Emails with API SOLVED
Thanks to a friend, who can read the code behind thinks, our problem to use LO and the API to send Emails is solved, without using the clibboard content. There is made use off the Mailmerge.py script who gives problems when sending non-ascii chararters like( éèàç tec...) but this script can easly been altered In origin there is a line textbody = textbody.encode('utf-8') add a extra line textbody = unicode( textbody, utf-8 ) textbody = textbody.encode('utf-8') and you can send also non-ascii characters. the code Sub Main oMailProvider = CreateUNOService(com.sun.star.mail.MailServiceProvider) oCont = CreateUNOListener(CurCont_,com.sun.star.uno.XCurrentContext) oAuth = CreateUNOListener(Authent_,com.sun.star.mail.XAuthenticator) oTrans = CreateUNOListener(Trans_,com.sun.star.datatransfer.XTransferable) oMailServiceObj = com.sun.star.mail.MailMessage oMail = oMailServiceObj.create( t...@email.com, f...@email.com, the subject, oTrans) xMailServer = oMailProvider.Create(com.sun.star.mail.SMTP) xMailServer.Connect(oCont,oAuth) xMailServer.SendMailMessage(oMail) xMailServer.Disconnect() End Sub Function Trans_getTransferData(f) As Any if f.MimeType = text/html then Trans_getTransferData = htmlbodypMy Mail!/p/body/html end if End Function Function Trans_getTransferDataFlavors() As Variant Dim f As New com.sun.star.datatransfer.DataFlavor f.MimeType = text/html Trans_getTransferDataFlavors = Array(f) End Function Function Trans_isDataFlavorSupported(f) As Boolean Trans_isDataFlavorSupported = (f.MimeType = text/html) End Function Function CurCont_GetValueByName(s) as Any Select Case s Case ServerName CurCont_GetValueByName = your.smtp.server.com Case Port CurCont_GetValueByName = 25 Case ConnectionType CurCont_GetValueByName = Insecure End Select End Function Function Authent_GetUserName() as Any Authent_GetUserName = your_smtp_user End Function Function Authent_GetPassword() Authent_GetPassword = your_smtp_password End Function -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Who does the maintenance Phyton Mailmerge script
I found that we can send Emails using Basic and the API using the Phyton Mailmerge stuff. There is a small problem to send Emails with non us-ascii characters. I solved the problem in the Python script, just wondering how do i pass this correction to the original script who is delivered by the native installion files I supose filling a issue ? Thanks, Fernand -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Who does the maintenance Phyton Mailmerge script
Simos, The repair in Mailmerge.py is quite simple at line 154 we have textbody = textbody.encode('utf-8') where the textbody contains non-ascii characters like (éèà etc...) so just insert textbody = unicode( textbody, utf-8 ) before line 154 and everyting works fine ! i make also the bug report with the correct mailmerge.py attacheted Thanks Fernand On Mon, Jun 27, 2011 at 1:45 PM, Fernand Vanries...@pmgroup.be wrote: I found that we can send Emails using Basic and the API using the Phyton Mailmerge stuff. There is a small problem to send Emails with non us-ascii characters. I solved the problem in the Python script, just wondering how do i pass this correction to the original script who is delivered by the native installion files I supose filling a issue ? Is this the file you were working on? http://cgit.freedesktop.org/libreoffice/libs-core/tree/scripting/source/pyprov/mailmerge.py If so, then the way to go for this is: 1. create a patch (diff file) which highlights the changes you did to the Python code. If you can put your final version of mailmerge.py online, I can help you create the appropriate patch. 2. file a bug report at https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice Select the the component 'LibreOffice'. 3. tell us here the URL of this bug report so that we can have a look. There are several encoding issues with the Python scripts, so it would be nice to find a way to fix them all in one go. Simos -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Who does the maintenance Phyton Mailmerge script
Simos, the bug report https://bugs.freedesktop.org/show_bug.cgi?id=38713 Simos, The repair in Mailmerge.py is quite simple at line 154 we have textbody = textbody.encode('utf-8') where the textbody contains non-ascii characters like (éèà etc...) so just insert textbody = unicode( textbody, utf-8 ) before line 154 and everyting works fine ! i make also the bug report with the correct mailmerge.py attacheted Thanks Fernand On Mon, Jun 27, 2011 at 1:45 PM, Fernand Vanries...@pmgroup.be wrote: I found that we can send Emails using Basic and the API using the Phyton Mailmerge stuff. There is a small problem to send Emails with non us-ascii characters. I solved the problem in the Python script, just wondering how do i pass this correction to the original script who is delivered by the native installion files I supose filling a issue ? Is this the file you were working on? http://cgit.freedesktop.org/libreoffice/libs-core/tree/scripting/source/pyprov/mailmerge.py If so, then the way to go for this is: 1. create a patch (diff file) which highlights the changes you did to the Python code. If you can put your final version of mailmerge.py online, I can help you create the appropriate patch. 2. file a bug report at https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice Select the the component 'LibreOffice'. 3. tell us here the URL of this bug report so that we can have a look. There are several encoding issues with the Python scripts, so it would be nice to find a way to fix them all in one go. Simos -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] When can we have a API to send Emails ?
Cor , I know all this tricks, but its still sending as attachments , i want a simple way to send a email with a message in the body Thanks Fernand Hi Fernand, Fernand Vanrie wrote (22-06-11 14:18) For some reasons the developpers off the OO-API has decided to not allow sending Emails using there API [...] Not sure if this has been mentioned already, and/or is of use for you, but since years I use an dispatch command for the task: executeDispatch(oDocFrame, .uno:SendMailDocAsMS, , 0, Array()) or executeDispatch(oDocFrame, .uno:SendMailDocAsPDF, , 0, Array()) Regards, Cor (sorry for being late with this) -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: When can we have a API to send Emails ?
Alex, Thanks for yoyr reply, but how do we acces this with the API ? Greetz Fernand Le 22/06/11 14:18, Fernand Vanrie a écrit : Hi Fernand, For some reasons the developpers off the OO-API has decided to not allow sending Emails using there API imho the mechanism is in place Well, one can already find : const rtl::OUString BODY(RTL_CONSTASCII_USTRINGPARAM(--body)); in smplmailclient.cxx But this doesn't seem to be used anywhere else. Alex -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] When can we have a API to send Emails ?
Andrew , I use this option for years, just a pitty we can not do this using our beloved API :-) and when making a extention not all users has the same client on there machine Greetz Fernand On 06/22/2011 08:18 AM, Fernand Vanrie wrote: For some reasons the developpers off the OO-API has decided to not allow sending Emails using there API I believe that all of these use the command line to send an email message using an existing client, which then limits the message that can be sent. Been a long time since I looked at this. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Sponsored Bug Repair ?
I hope Michael and other TDF-members are reading this. As we love to have a Email body when sending emails with the API, our compagny is willing to fund this kind of repair work. The interested makes a Enhancement request The TDF put a price on it The interested pays TDF in advance After TDF and interested is satisfied TDF pays the Developer our keeps the money for other projects Simple ? Fernand -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Two simple writer annoyances
Ian , No , we can not rotate a picture in LO , but LO is not our favorite application to handle our pictures and graphics. LO is build to produce documents, pictures are taken by camera and for correcting and rotating this pictures we can uses hundreds off different and specialised free and open) Applications. BTW: use the wrap and contours to let flow text around irregular shaped objects in LO Greetz Fernand On 29 April 2011 07:28, Krabina Bernhardkrab...@kdz.or.at wrote: Hi, I think there are two annoyances in writer that should not be that hard to fix. I hope someone can fix these: 1. Why can't writer have image descriptions ABOVE the image as well? It can do it with tables, but with images, image captions have to be below the image... 2. Why can't writer have the possibility to rotate an image... Over 20 years ago I used Impression Publisher and it could rotate graphics and IIRC flow text around irregular shaped objects. And that was on a computer with 2 meg of RAM, no hard drive and basically the same ARM processor as a modern day Smartphone but running at 30 MHz. It could be argued that few people need these or they are more appropriate to a DTP program? I use Inkscape and GIMP now for most image preparation, then import the final product into Writer if it needs to go into a WP. More often than not though it goes straight onto a web page. thanx and keep up the good work! regards, Berhard -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Bug or new feature
Steve, I filed 2 years ago a issue on OO for that. Indeed it blocks a lot of efforts made to make PDF happen, and the tool is still useless for many (professional) users. EPSvector is still the standard for all graphic applications. Like Micheal says, the code needs a bit more love :-) Greetz Fernand LO, also OO do not create pdf's correctly from documents containing EPS's. This occurs on 3.3.1 on Suse and OSX. The PDF is not created with the vector data of the EPS but the low resolution bitmap (if there is one) used for positioning. To create a correct PDF I must print to file (PS) and use PS2PDF. Is this a bug? steve -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
[tdf-discuss] PinterSettins are no longer persistent (windows)
Hallo Sinds 3.3 (windows) all PrinterSettings except the Printer Names are no longer persistent and not stored anywhere not in the profile, and not in the document. Within the printer settings we have the options who are not Printer specific and we have Settings who are bound to a specific printer. Both are all lost after reloading the document, We can use the Printer specific settings during but only when starting the printing itself the choosen settings are remenbered as lo,ng the document stays open. Setting the PageSizes using the API is also broken, please trie the included code with a printer who accept to changes the PaperSizes PLease can someone confirm this, so i can fill a issue Greetz Fernand REM * BASIC * Sub printdocument Dim Doc As Object doc = thiscomponent Dim PrinterProperties(0) As New com.sun.star.beans.PropertyValue Dim PaperSize As New com.sun.star.awt.Size PaperSize.Width = 2 ' corresponds to 20 cm PaperSize.Height = 2 ' corresponds to 20 cm 'PrinterProperties (0).Name= Name 'PrinterProperties (0).Value= Adobe PDF PrinterProperties (0).Name=PaperFormat PrinterProperties (0).Value= 8 'PrinterProperties (1).Name=PaperSize 'PrinterProperties (1).Value= PaperSize Doc.setPrinter(PrinterProperties()) 'xray Doc.getPrinter Doc.print(PrinterProperties()) Dim PrinterProps(1) As New com.sun.star.beans.PropertyValue PrinterProps(0).Name=wait PrinterProps(0).value=true PrinterProps(1).Name = IsBusy dim bIsBusy as boolean bIsBusy = True While bIsBusy 'dim aPrintConditions as object aPrintConditions = thiscomponent.getPrinter() dim i as integer For i = LBound( aPrintConditions ) To UBound( aPrintConditions ) If aPrintConditions(i).Name = IsBusy Then bIsBusy = aPrintConditions(i).Value EndIf Next Wait 10 wend DisplayPrinterProperties end sub Sub DisplayPrinterProperties Dim Props 'Array of com.sun.star.beans.PropertyValue Dim i% 'Index variable of type Integer Dim s$ 'Display string Dim v ' Dim sName$ ' On Error Resume Next Props = ThisComponent.getPrinter() For i = 0 To UBound(Props) sName = props(i).Name v = props(i).Value s = s sName = If sName = PaperOrientation Then REM com.sun.star.view.PaperOrientation.LANDSCAPE also supported s = s IIf(v=com.sun.star.view.PaperOrientation.PORTRAIT,_ Portrait, Landscape) = CStr(v) ElseIf sName = PaperFormat Then Select Case v Case com.sun.star.view.PaperFormat.A3 s = s A3 Case com.sun.star.view.PaperFormat.A4 s = s A4 Case com.sun.star.view.PaperFormat.A5 s = s A5 Case com.sun.star.view.PaperFormat.B4 s = s B4 Case com.sun.star.view.PaperFormat.B5 s = s B5 Case com.sun.star.view.PaperFormat.LETTER s = s LETTER Case com.sun.star.view.PaperFormat.LEGAL s = s LEGAL Case com.sun.star.view.PaperFormat.TABLOID s = s TABLOID Case com.sun.star.view.PaperFormat.USER s = s USER Case Else s = s Unknown value End Select s = s = CStr(v) ElseIf sName = PaperSize Then REM type is com.sun.star.awt.Size REM The size is in TWIPS and there are 1440 twips per inch s=s CDbl(v.Width)/1000 x CDbl(v.Height)/1000 (cm) Else s = s CStr(v) End If s = s CHR$(10) Next s= Sometimes the PrinterName is correct but never the wanted papersize of 20x20 cm CHR(10) s MsgBox s, 0, Printer Properties End Sub -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] Calc usability issue (autocorrect of small letter to capital letter)
On 8/03/2011 16:14, Kevin André wrote: Calc seems to autocorrect a small letter to a capital letter after a dot character. But a dot character does not always mean the end of a sentence; in this case it was used for an abbreviation. And sadly there is no way to undo a wrong autocorrection: pressing undo will revert the entire input of the cell. Please provide a way to undo the autocorrection, or make calc realise that when a user changes 'R' to 'r' in a cell it shouldn't make it an 'R' again :) That's really frustrating. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
[tdf-discuss]Print Intentions for LO documents
With no luck I tried in the past to convince the OO developers to include Print intentions in the there documents. We need to store some meta-data about where and how the document will been published, On screen, printed on a Laser Printer, Printed by en professional Printhouse etc This information is important to show the inserted graphics at the correct sizes. Now, LO and OO looks in the file header off the graphic file for the DPI who is stored by the Author off the Graphic (mostly the photographer). These is useless, we need to define the DPI (what kind of printing will be used) )in the document and then calculate the amount off pixels we need to publish the Graphic at the size who garanteed the best quality. I supose it is not to complicated to code this feather, i do not know if ODF support this wanted Print Intentions ? Thanks for any consideration Fernand -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] Re: EPS images in ODF documents
Magnus , Your document contains EPS images with a lowres preview. OO or LO shows only this preview.The poor quality is due to the lowres (72x72) pixels per inch. OO or LO can NOT show eps images. Ok, so far the bad news, if you want to see hig quality in your LO doc , then you need to transfer the pictures to the OO-draw-vector format and copy from there to your Writzer Doc. open your picture with Gview ( Opensource) Convert in Gview to EPS, save. Open the new saved EPS in OO-draw and copy the picture from draw into your Writer Document When now making a PDF you will see that some parts of your picture (text and notations) have a lower quality than the original EPS output. You can also following a other work flow, with no loss of quality. Start opening your orginal pictures in Gview, export a to a pixel format, who has better results in your Writer Doc. Insert this pixelformats as linked file in your writer doc. Befor printing, change your pixelformat_link to the original epsfile_link ( can ealy been done with a macro when using some naming conventions) Hope it helps a bit Fernand I have made two test files with the kind of EPS images I work with. I put the test together with OOo in the ODT document and then printed a PDF file of that document with CUPS-PDF; I hope I managed to upload and attach them here properly. With the files I want to show my problem and that is the poor quality of the EPS images in the ODT document. The resulting PDF file is on the contrary very good; it is e.g. better than if I had made the original document in DOC format in Microsoft Word. But the ODT file that I work with when writing my texts and books has such poor EPS illustrations that I cannot rely on them for quick controls of what they contain. Regards, Magnus http://nabble.documentfoundation.org/file/n2396161/EPS_Image_Test_1.odt EPS_Image_Test_1.odt http://nabble.documentfoundation.org/file/n2396161/EPS_Image_Test_1.pdf EPS_Image_Test_1.pdf -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] Re: EPS images in ODF documents
Magnus , No programmer skils needed here: - dowload GSview - open a EPS picture with GSview - Change the MEDIA Diplay settings to 500 dpi and use 24 bits/pixel - goto FILE and convert PS to EPS who ask for a new file name (the helpinfo explains the whole thing) - trie to import the new file in LO and check the difference in Previeuw quality when not OK then trie other Display settings Hope it helps Fernand Fernand: when the PDF is made with the Postscript output, then it's using the vector graphic parts of the picture not the preview! OK, I see; then I would simply like to request a better preview. I understand the file size of the ODT document goes up, but I would prefer that instead of the current situation. It would be interesting to find out how small an improvement in preview resolution would yield an enough good result for me. Are you a programmer, Fernand? May I ask you to look into this? -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] EPS images in ODF documents
Magnus , No difference between LO and OO sofar Using EPS is in fact not a problem, at condition you start from EPS with a build in lowres preview . EPS without preview is not shown' in a document but when printed (using a postscript printer) like PDF etc.. the Highres images will be in the PDF document for RGB and CMYK as well. When using the direct PDF output in LO or OO then the lowres images will been in the PDF document, what is still a issue for LO and OO PDF creation. Hope it helps as a workaround ? Fernand PS: Trye to convince your Publisher, Printer not to use EPS anymore, Postcript has had is best day's, using a RGB workflow with Hyres RGB-images ( Tif or jpg) in your Documents, is far more simpeler with same quality outcome. Hello! I write books containing a lot of EPS images. When I have tried to use OpenOffice I have not been satisfied with the rendition of the inserted EPS images. Is LibreOffice better than OpenOffice in this respect? Regards, Magnus Johansson -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] Fwd: [dev] An image editing extension for Open office writer
Nguyen , I tried to install your latest version(2) on Windows 3.3 RC8 it installed but no reaction when klicking on your toolbar From the video i saw a usefull extension, but :-) your exellent work do not help us to overcome a important Openoffice weakness: No way to define the print Intentions who means where and how will the document and the included pictures been printed. The most important Print Intention is the resolution needed for the the device where the document sould been printed. For screen we need 96 pixels par inch for Laserprinters 150 ppi for professional offset 254 ppi. I supose your tool get (just like OO) the resolution from the picture file header, what is not a good idea, the autor of a picture do not know on what device the picture sould been reproduced ! It is important to define the ppi when loading the picture in the document, so the tool can calculate the the minimum and maximum dimensions (in mm, inches...) off the picture. Hope its helps Fernand -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] Professional Printing from LiO
Prabath , Yes you can, at condition you use a RGB-workflow all the way (in preference the AdobeRGB colorspace). making highresolutions PDF's is no problem. The Final pdf-RGB to CMYK conversion can be done by your printer or you can use yourself a pdf conversion tool who handles this color transformations. Greetz Fernand Can LibreOffice writer use for professional offset printing? -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://listarchives.documentfoundation.org/www/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] PDF export in CMYK
Tibor thank you both for answers, I understand now the situation... My friend is historcian and he is not interested in learning any DTP technics – that is quite understandable. His first pdf exported from OO was flatly rejected as it was in RBG. It is fault or shortcoming of this publishing shop but he will not change it. Today, I found and tested pstill tool, it converts pdf to CMYK pdf, only colors (in included photos) are somehow shifted, or undersaturated. I had not investigated this issue yet, it might be something trivial … No not trivial, thats wath i mend with using correct colorspace, when the pictures in a LO doc are all the same colorspace, then tranforming to CMYK has a better change to produce better colors. This was some background, but I have following question: You wrote: „Important for this process is using the correct colorspace (sRGB or adobeRGB) is more important and there are we have no tools in LO !“ - are you trying to say, that OO/LibreOffice exports PDFs to wrong RGB type that can not be converted properly into CMYK pdf? If this would be the case it would be quite serious problem... I supose LO is not touching the colorspace precent in the original pictures, we slould have a tool (at least in draw) yo check the colorspace in a picture and to alter this all to the same space. Regards Tibor On Thu, 16 Dec 2010 09:08:38 +0100, Fernand Vanries...@pmgroup.be wrote: Tibor, A few years ago i would say yes a good idea that CMYK but deaser days RGB is a common workflow due to the online use of the same (rgb) documents. CMYK is printer business so they mostly prefer to do the transfer off a RGB-pdf into a CMYK-pdf. Important for this process is using the correct colorspace (sRGB or adobeRGB) is more important and there are we have no tools in LO ! Fernand Hi, Friend of mine had an issue with openoffice, He was asked to deliver pdf in CMYK colorspace. It is not possible by now AFAIK. But are there any plans or any work being done in this regard? I just wonder, it is not critical issue for me, nor for my friend. He used some Adobe product at the end... Regards -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://www.documentfoundation.org/lists/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] Re: PDF export in CMYK
Alex, Indeed using CMYK-eps can been done, but the pictures are not shown in LO or OOdocuments. They re-apear in the final PDF made by a Windows printer (not by the LO conversion) We used this technique for years, starting with low-res Pictures in the OO-docs, and then just before PDF making, we replace them with there EPS conterparts. This is nowdays over ruled by an RGB workflow where we use Highres RGB pictures (all in the same sRGB or AdobeRGB colorspace) then we makes RGB-pdf's and tranfers the RGB-pdf to a CMYK-pdf for professional CMYK printing. Fernand Le 17/12/10 09:16, Fernand Vanrie a écrit : Hi all, I seem to recall that neither OOo, nor LibO implement CMYK colourspace, but I also seem to recall having read somewhere that if you use EPS images that are already CMYK compliant, instead of JPG, then you might get a more acceptable PDF doc. Worth trying ? I don't remember exactly because even EPS management within OOo/LibO wasn't brilliant. The only other thing I can think of is Scribus... Alex -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://www.documentfoundation.org/lists/discuss/ *** All posts to this list are publicly archived for eternity ***
Re: [tdf-discuss] PDF export in CMYK
Tibor, A few years ago i would say yes a good idea that CMYK but deaser days RGB is a common workflow due to the online use of the same (rgb) documents. CMYK is printer business so they mostly prefer to do the transfer off a RGB-pdf into a CMYK-pdf. Important for this process is using the correct colorspace (sRGB or adobeRGB) is more important and there are we have no tools in LO ! Fernand Hi, Friend of mine had an issue with openoffice, He was asked to deliver pdf in CMYK colorspace. It is not possible by now AFAIK. But are there any plans or any work being done in this regard? I just wonder, it is not critical issue for me, nor for my friend. He used some Adobe product at the end... Regards -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.org Archive: http://www.documentfoundation.org/lists/discuss/ *** All posts to this list are publicly archived for eternity ***