Le 02/04/2014 06:54, Sqwuiddy a écrit :
Whoa !! Too many questions in one post.
Part of our company has moved completely to LibreOffice and removed
Microsoft Office from their computers. I have tried programming mail merge
templates on my computer, and then having them open it on theirs, and the
I hope that the migrated templates are in ODF format (ott), or else you
are heading for trouble...
documents will not merge. The first error we encountered was that the IF
statements that I built didn’t function at all. I simply wanted to make an
“X” appear when a field contained a certain value. These were if statements
that would function on my computer. The second error was that… well, none of
IF statements should work, at least within ODF documents, as far as I know.
the merge fields merged. When I re-inserted them they worked fine, but they
wouldn’t pull from the database even after re-registering it. My question
here is, does Word give Libre Writer a leg up if both programs are on one
computer? Is that why when I moved a document I’d programmed and tested to
No, Word does not help Writer in any way here to my knowledge. More
likely it comes down to the fact that your template when transferred
must contain the same paths to the data source (which you don't mention
in detail). From the rest of your post, it appears that you are merging
from an Excel sheet ? For the mailmerge to work reproducibly, your ODF
document must reference the Excel sheet as a datasource in the same way
as on your own machine, and if the datasource is registered with LO, it
is written into the user configuration.
Nested IF Statements:
Is this possible? I have tried a variety of things and I’ve done a good deal
of research, and I’ve hit a wall. We cannot move forward if we do not have
No idea, as I've never tried this.
IF Statements resulting in a Mail Merge Field:
So far I have only been able to make conditional mail merge fields
hide/appear using hidden sections. This is not a practical technique for us,
as our documents are built almost entirely on conditionally revealed values.
I have researched this as much as I could, it seems I cannot create a
conditional statement that results in a mail merge field, but I wanted to
My understanding was that hidden sections was the route to choose in
order to obtain what you want. It might be possible to obtain something
similar via User variables, which are stored in the document, but the
number of these that you can define are limited (4 or 6 or something so
small as to be practically useless ?).
There are other techniques available that do not rely on the UI to do
this, including setting variables within the document as any given
character, and then using a scripting framework to control replacement
of those variables with the values you want and have a user driven
interface, but most of these are command line solutions (Python, Java,
We regularly use a formatting switch on our mail merge fields in Word 2010
called “DollarText.” This takes a number from an Excel spreadsheet and
spells it out, like below:
Cell Value: $1,231.67
Formatted: One thousand, two hundred and thirty one dollars and sixty seven
We have other switches that we need to use as well, but those don’t seem
available in the list of additional formats. Is there a workaround for this,
or am I missing something? I have to admit, I don’t fully understand how to
build custom formats (I haven’t found much documentation on them at all).
You would probably require a macro to convert a number to spelled-out
text, there used to be one around in the shape of an extension that
could do this, but I haven't checked recently. As for user defined
formats, these tend to be limited to fairly simple string formats,
otherwise you're going to have to devise a macro to do it for you.
FormCheckBoxes from Word do not translate in Writer. Meaning, I can open
Word 97-2003 documents containing these functional check boxes with Libre
Writer but they do not print. Is there a setting somewhere that I need to
switch or perhaps a better alternative? I have tried retemplating these
documents in Libre using Writer’s FormCheckBoxes but they are impossible for
me to place on a table. Wingdings are also not an option.
Non-printing of Word checkboxes is/was a known bug. Don't know if that
has been fixed, or if a fix is even in the works. I have always found
that using Writer checkbox controls is fraught with dissatisfaction
because they are too small, do not scale well, and do not allow you to
choose the tick mark character.
We build forms that go to court, so they have to be laid out in tables
exactly as the court requires. Most of the time we build these forms on
tables in Word. When opened in Libre Writer, the tables break, cells expand,
and other such things occur. I spent 4 hours last week trying to rebuild one
Tables and nested table import from Word are still problematic, due to
incomplete (or buggy) filter implementation and differences in the specs
of each product which define how tables should be handled.
for a firm that doesn’t have access to Microsoft Office and had no luck.
After I finally finished my rebuilding, I saved the document as a Writer
document to prevent further issue with compatibility, and to my absolute
dismay I discovered that it turned all of the mail merge fields into text. I
You seem to be expecting perfect transition from a heavily MS-Office
centric document usage to LibreOffice without having to reconsider how
the various objects in these documents are managed by the corresponding
software - as you have found out, this simply doesn't happen.
We have already built hundreds of mail merge templates in Word. In order to
continue to function through the conversion from Word to Writer, we need to
be able to merge these and not rebuild them all immediately. However,
simple, very simple, documents have been crashing Writer like we were in a
derby and on fire. This isn’t just with one, but a great majority of our
templates. Is this common? They are Word 97-2003 documents I am opening in
Libre Writer 4.0.
I would recommend switching to a more recent version of LibreOffice than
4.0, which was decidedly buggy (not that there aren't any with 4.1.5.x
or 4.2.x.x, but the doc and docx filters have been improved since 4.0).
Note that Word 2003 format was an incomplete transitional OOXML for
which it is very hard to provide adequate import/export filters, because
it supported both old and new MS specific document objects, and even
then did so incompletely. You should not expect MS 2003 xml formats to
be imported correctly. You might fare better with Word 97 only formats
when importing, but even these (see table problems) will not be perfect.
Also, below are some fun, plain-text formulas I built in Word that we use on
every day templates, just to give you an idea of the level of complexity I’m
Can these be recreated in Libre Writer without learning to code in Pearl and
Frankly, they could be coded in LO Basic, and yes, that means, having to
learn it - its structure and objects are not the same as MS VBA.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy