[libreoffice-users] Re: Inserting DRAW file as linked OLE in WRITER file?
Hi Dale, First of all I do not want to copy/paste from DRAW to WRITER. Because I use same picture in many documents. I want to insert picture to the document as linked. In this case when I change the main picture file than all documents can change... This is very good for me... One change (work) and many results... :) According to my demand the best solution is inserting all pictures as hard link in DRAW file and make all changes/arrows in DRAW file. And inserting this file as hard linked to WRITER... In this case you may double-click to DRAW OLE and open the source file. Than you may change, adding arrow, shapes and return to main WRITER file... The biggest problem in this situation is, when I do this than size of the OLE container is changing. I can not fix the size of OLE and visible region of the resource OLE file!... -- Regards, Mucip:) 20-03-2014 01:21, Dale Rebgetz [via Document Foundation Mail Archive] yazmış: Hi Mucip, Is there a good reason for using OLE objects? I have used such for putting tables (Writer) in Draw documents, simply because Writer has much better table handling than Draw, but position control was a bit hit-and-miss. When you add the arrows to the picture, where is the arrow being placed? If you are using the Writer drawing tools to place the arrow, then it is a different object to the picture, so they will behave as different objects. If however you select the OLE object, then use its drawing tools to add the arrows, the arrows will be part of the OLE object. Then, repositioning the OLE object reposition the picture and arrows as one. If you want to resize the picture and arrows as one object, the only way I know to achieve this is to arrange both together in the Draw document, select both, and Group them - which converts them to a single entity. My work flow for similar tasks is as follows: Drawings created with Writer/Draw: always create in Draw (better tools), group all elements, then copy into Writer. If editing is required, copy drawing into Draw, ungroup, edit, regroup, copy back. This might sound inefficient, but for a complex drawing the overhead is negligible and the productivity is far greater than trying to do the edit in Writer. Note that editing the text of Draw text elements can be done in Writer, and without ungrouping the object. Pictures with overlayed drawing elements (e.g. arrows): If the result will NOT require resizing: Create a frame in Writer, add the picture to the frame, add the graphics to the frame. If the graphics are complex, I first create them in Draw, then add as one object into the frame. The frame should ideally not contain other text. i.e. it should have just the one paragraph marker. By default the objects added to the frame are linked to the nearest paragraph marker. With just the one paragraph marker, the objects are easy to position within the frame, and their relative position does not move as the frame moves. i.e. they move as one object. If the result WILL require resizing, then I would arrange them in Draw, group, then copy to Writer. I hope this helps. Dale. On 19/03/2014 8:56 am, Mucip wrote: Hi, I am writing manual book of machine. I've got many pictures. I import this picture one by one to DRAW file and I put arrow sign or text box on some points of the pictures. I import this DRAW file as linked OLE object. But I can not center the picture in OLE container/frame? When I adjust it once than it may change later?! I can not fix the main picture region of the DRAW object in OLE container/frame?... In MS Office you can add picture in the word file and you can add arrows in the picture. Than all this object became like one solid. When you resize the picture than arrows indicating same point of the picture... But in WRİTER when you resize the picture than you arrow shapes not resizing?! This is really big lack according to MS unfortunately?! Regards, Mucip:) -- View this message in context: http://nabble.documentfoundation.org/Inserting-DRAW-file-as-linked-OLE-in-WRITER-file-tp4102082.html Sent from the Users mailing list archive at Nabble.com. Email from setec.com.au does not necessarily represent the official policy of SETEC Pty Ltd. See http://www.setec.com.au/emaildisclaimer20060629.html for details. -- To unsubscribe e-mail to: [hidden email] /user/SendEmail.jtp?type=nodenode=4102236i=0 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 If you reply to this email, your message will be added to the discussion below:
[libreoffice-users] Re: Inserting DRAW file as linked OLE in WRITER file?
Hi Owen, Thanks. I will check the page... -- Regards, Mucip:) 20-03-2014 03:14, Owen Genat [via Document Foundation Mail Archive] yazmış: You will need to rescale the ODG prior to inserting it as an OLE object into the Writer document. There are some limits on how large the Draw canvas can be before it is rescaled when imported via OLE. Refer my explanation http://ask.libreoffice.org/en/question/2/size-of-odg-inserted-via-ole-in-odt/?answer=24459#post-id-24459 on AskLO. Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/Inserting-DRAW-file-as-linked-OLE-in-WRITER-file-tp4102082p4102265.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] Re: How to put Basic IDE code completion to work
Hi Fernand, On Wed, Mar 19, 2014 at 09:23:40PM +0100, Fernand Vanrie s...@pmgroup.be wrote: hallo Miklos thanks but only and ( are auto clossing dot operator is not functioning at all (maybe a keyboard problem ?) tab do nothing sub and Function not closing do i something wrong ? I haven't tried this code completion feature myself, that's why I added Gergo to CC. Let's hope he'll have an answer soon. :-) Miklos -- 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: LO compatibility
On 3/16/2014 12:24 PM, Jim Seymour jseym...@linxnet.com wrote: I don't think the OP's original question silly. I think he or she wanted to know if LibréOffice's support for MS Office formats was compatible with those of MS Office's. A reasonable question, in my view. If the question was is it 100% compatible, then yes, it is a very silly *and* unreasonable question - since even the different versions of Microsoft Office are not 100% compatible, and in my opinion, this is purely intentional to try to keep as many of their (microsofts) customers on the upgrade train as possible. -- 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: Turning spreadsheet data into legible report?
Thanks everyone for the feedback. As I learn more about spreadsheets, I thought merging all the years together into a single sheet and filtering data so that the wordprocessor would only see a subset of it would solve the issue... but it's not such a great idea since some students will attend more than one year, so they'll end up having more than one document in their name :-/ I guess it's an illustration that using a spreasheet as poorman's database only works for basic, one-dimensional needs. -- View this message in context: http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102293.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] Re: Turning spreadsheet data into legible report?
Problem solved: Indeed, putting all the data into a single worksheet works OK. The only drawback is empty documents for kids who didn't attend a given year, but this could be avoided by adding some conditional loop in the Word mail merge document to avoid printing empty sections (eg. If Trimester1-2013 is empty, don't display list). Thanks all. -- View this message in context: http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102306.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] Mail merge with custom fields in LibreOffice 4.2
Alternatively, to save copying data into a common .ods file, you can keep one .odb file (e.g. mergesource.odb) but change which .ods file it points to. Open mergesource.odb, then Edit Database Properties, and change the path to spreadsheet document. Saves a bit of copying data around, but I can see that might not be so easy as an instruction if there are non-technical users of your merge document. Whatever works for you and your users is best ;o) Mark. Steve Edmonds wrote: And thanks to the discussion I think I have a much better understanding and can iron out the problems our users are having with the merge. We keep getting new lists to merge, all the same format. The secret to simplification is, once set up, to have an ods named mergesource.ods or something and then copy the new data in each time or save the new data as mergesource.ods. Then a new .odb file is not created each merge, and it is not necessary to exchange the database or re-link the fields. Steve -- 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] Clarification about ODF Extended
On 17/03/2014, Italo Vignoli italo.vign...@gmail.com wrote: Nothing happens when XML tags are ignored, to systems which are not supporting the ODF 1.2 Extended document format. This is the reason why we can suggest to use ODF 1.2 Extended as the preferred format, because backward compatibility is maintained. Thanks to the odf implementor notes web page, how can this claim be true when these LO features break odf validation? Somewhere in the wiki there is a list of the extended features, but please remember that we are speaking of a document format and not of software features. So, most of the new LibreOffice features do not impact the document format. If LO feature (most likely designed to provide some sort of compatibility with m$) prevent odf validation, the document format must be impacted. Or is this a false conclusion? -- 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] Clarification about ODF Extended
e-letter wrote: On 17/03/2014, Italo Vignoli italo.vign...@gmail.com wrote: Nothing happens when XML tags are ignored, to systems which are not supporting the ODF 1.2 Extended document format. This is the reason why we can suggest to use ODF 1.2 Extended as the preferred format, because backward compatibility is maintained. Thanks to the odf implementor notes web page, how can this claim be true when these LO features break odf validation? I haven't seen anything to say that the extensions prevent validation of ODF documents. The implementer notes you refer to say, under Extension namespaces, Elements and attributes that are not defined in an ODF specification yet... have to be written with an extension namespace, otherwise validators will complain about invalid elements or attributes. This suggests that the standard and validators allow for extensions to the format. Presumably extensions to the format would be ignored by applications not supporting that extension, but the rest of the document show as intended. e.g. with the extension for font embedding, applications supporting the extension would use the embedded fonts, while others would ignore the embedded fonts and use those on the system (as if the fonts were not embedded at all). Somewhere in the wiki there is a list of the extended features, but please remember that we are speaking of a document format and not of software features. So, most of the new LibreOffice features do not impact the document format. If LO feature (most likely designed to provide some sort of compatibility with m$) prevent odf validation, the document format must be impacted. Or is this a false conclusion? -- 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: Inserting DRAW file as linked OLE in WRITER file?
On 20/03/2014 7:32 pm, Mucip wrote: Hi Dale, First of all I do not want to copy/paste from DRAW to WRITER. Because I use same picture in many documents. I want to insert picture to the document as linked. In this case when I change the main picture file than all documents can change... This is very good for me... One change (work) and many results... :) According to my demand the best solution is inserting all pictures as hard link in DRAW file and make all changes/arrows in DRAW file. And inserting this file as hard linked to WRITER... In this case you may double-click to DRAW OLE and open the source file. Than you may change, adding arrow, shapes and return to main WRITER file... The biggest problem in this situation is, when I do this than size of the OLE container is changing. I can not fix the size of OLE and visible region of the resource OLE file!... Hmmm... I see you are no novice and you are making sound decisions. I have no experience or knowledge which can help you with your OLE problem. However Owen's investigations do look like they might be helpful. Email from setec.com.au does not necessarily represent the official policy of SETEC Pty Ltd. See http://www.setec.com.au/emaildisclaimer20060629.html for details. -- 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
