[libreoffice-users] Re: --convert-to pdf doesn't recalculate calc functions before converting

[jlatmwl]

The solution to this was found by my coworker.  It was to set the
/OOXMLRecalcMode/ option in
/~/.config/libreoffice/4/user/registrymodifications.xcu/ to "1":




--
View this message in context: 
http://nabble.documentfoundation.org/convert-to-pdf-doesn-t-recalculate-calc-functions-before-converting-tp4218997p4219006.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] --convert-to pdf doesn't recalculate calc functions before converting

[jlatmwl]

We have a process for creating lab reports where a template *.ods file is
duplicated, values are inserted in the cells of the files via a Perl script
(OpenOffice:OODoc), there are a bunch of formulas in there which should act
on those values, and then the file is converted to a PDF like so:

libreoffice --headless --convert-to pdf filename.ods --outdir .

This has worked for years with LibreOffice 3.5 running on an OpenSUSE 11.3
server.  My task here is to migrate this process to a new CentOS 7.2.1511
server.  This distribution gave us "LibreOffice 5.0.6.2 00(Build:2)" which
isn't working the same way.  Using the same command does yield the same PDF,
but none of the functions are "recalculated".

To troubleshoot, I've taken the spreadsheet with the values inserted by the
script via the CentOS machine and opened it with the SuSE 3.5 GUI and all
the formulas are immediately calculated like they should be.  I've also
taken the same spreadsheet file, along with the one modified by the SuSE
box, and opened both in the 5.0 GUI, yet all the formulas remain
"uncalculated" unless I manually select every cell and recalculate it (F9)
even with the AutoCalculate setting enabled.  I've been working on this for
the last two days and my research has come up empty.  Is there a "hidden"
configuration setting I need to change somewhere or another command line
option I need to try?



--
View this message in context: 
http://nabble.documentfoundation.org/convert-to-pdf-doesn-t-recalculate-calc-functions-before-converting-tp4218997.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] Re: Can I embed ODB Database file in Writer document?

[Gabriele Ponzo]

I haven't tested yet the embedding mail merge, but it could somehow be the
solution...

It's a matter of knowing better the requirements and do some testing.

Il 25 lug 2017 12:57 PM, "Alexander Thurgood"  ha
scritto:

> Le 24/07/2017 à 17:18, Joshua Kramer a écrit :
>
> Hi Joshua,
>
>
> > Is it possible to either have a small (less than 50 records) database
> > in a Writer document, or embed an ODB database right in the document
> > (instead of having it be in an external file)?
> >
>
> No and no, respectively.
>
> From what I understand, it is now possible to have a mailmerge Writer
> document that contains the data referenced by the mailmerge stored
> within the Writer document. Whether or not this successfully transfers
> over to another machine is something I haven't tested.
>
>
>
>
> > I have a document that has two different views of the same data.
> > Right now I'm doing everything by hand, which is error-prone and
> > inefficient.
>
> In what sense are you talking about views ? Do you mean actual database
> views in the classical DBA sense, or do you mean some graphical
> representation of the data in a formatted Writer document ?
>
> > portable, i.e. if I want someone else to edit this file I can just
> > send one file containing both the writer document and the database.
> >
>
> So unless I have really misunderstood what it is you are attempting to
> achieve, you can already do this with just a single ODB file.
>
> The ODB file can contain a series of queries, views (in the DBA sense of
> the word), Writer forms displaying data either obtained from views or
> queries, and even reports. This file can be sent to other users who can
> then edit it to their heart's content.
>
>
> 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
>

-- 
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: Can I embed ODB Database file in Writer document?

[Alexander Thurgood]

Le 24/07/2017 à 17:18, Joshua Kramer a écrit :

Hi Joshua,


> Is it possible to either have a small (less than 50 records) database
> in a Writer document, or embed an ODB database right in the document
> (instead of having it be in an external file)?
> 

No and no, respectively.

From what I understand, it is now possible to have a mailmerge Writer
document that contains the data referenced by the mailmerge stored
within the Writer document. Whether or not this successfully transfers
over to another machine is something I haven't tested.




> I have a document that has two different views of the same data.
> Right now I'm doing everything by hand, which is error-prone and
> inefficient.  

In what sense are you talking about views ? Do you mean actual database
views in the classical DBA sense, or do you mean some graphical
representation of the data in a formatted Writer document ?

> portable, i.e. if I want someone else to edit this file I can just
> send one file containing both the writer document and the database.
> 

So unless I have really misunderstood what it is you are attempting to
achieve, you can already do this with just a single ODB file.

The ODB file can contain a series of queries, views (in the DBA sense of
the word), Writer forms displaying data either obtained from views or
queries, and even reports. This file can be sent to other users who can
then edit it to their heart's content.


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] Unwanted Alternative Image Names (Resolved)

[gordon cooper]

Eureka!!  Many Thanks Robert, that is the clue. The Alternative names 
appeared
because a draft .odt file was created by a copy and paste from an html 
file which
itself was a conversion from Lyx.  The problem is hopefully a "once 
only" but for the
archives and benefit of anyone who may meet this in the future, here is 
a summary.


1. Any text appearing in Libre Office Image 
Properties>Options>Alternative Name does
not appear on screen in a displayed .odt , but will be shown as a 
screen shot, and in a
printed copy, as an image caption in an html export from that .odt 
file.


2. Images inserted into a Libre Office .odt file will not usually create 
an Alternative name,
but if the .odt file has been created by copy and paste from an 
html source, the file
reference for any images in the html (not sure about tables) may be 
saved as an

Alternative name to then appear in an html export.

This situation is unlikely to occur in normal Libre Office usage.

Thanks again Robert,

Gordon.






On 25/07/17 13:11, Robert Funnell wrote:

Gordon -

Yes, I see that indeed my Alternative names are blank, which 
apparently is the default when a new image is inserted. How did you 
create your .odt files? Manually? Or by some sort of conversion from 
another format that defined the Alternative names?


- Robert


On Tue, 25 Jul 2017, gordon cooper wrote:




On 25/07/17 12:29, Robert Funnell wrote:

 Gordon -

 I just opened a .odt document with captioned images in LO 5.0, did
File >  Export and selected XHTML. (I don't see a separate HTML
 option.) When I view the resulting file in my Web browser, a lot of 
things
 aren't right but the images appear with their captions and no 
filenames.

 Am I not doing the same thing as you're doing?

 - Robert

 Robert,
 You are correct with the XHTML selection - the smaller 
print on that line indicates
  the selection is correct for html and xhtml.  If you 
secondary click on the image
  and select Properties>Options,  the popup shows (in my 
case) the name of the image
  and immediately  below, a line for Alternative name 
which is displaying the file name
  of the image. it is this filename that appears in the 
html exports. The fix is to go
  to each image Properties and delete whatever is showing 
in the Alternative name

   line.
Gordon.



 On Mon, 24 Jul 2017, gordon cooper wrote:

>  Hi Steve,
>Yes it is satisfactory, it is only the display of 
the >  image file names that is
>  a relatively small nuisance. I can get rid of them by editing 
properties >  for each
>  image, so asked to see if there was a setting that would remove 
them for >  the
>  whole file. Have also had to look at table properties to ensure 
that >  framing lines
>  appeared in the html.  HTML also has an advantage in that some 
software >  language
>  translation programmes, e.g. Googletranslate,  will preserve the 
>  formatting, even

>  if some of the phrasing and syntax needs correcting.
> >  Gordon.
> > >  On 25/07/17 11:29, Steve Edmonds wrote:
> >   Hi.
> >   Is the HTML format satisfactory in all other aspects for your 
needs.
> >   I had to correct the HTML in tables exported by writer so am 
now wary

> >   about using it for HTML export.
> >   steve
> > > >   On 25/07/17 08:20, gordon cooper wrote:
> > > > >   On 25/07/17 03:07, leleu wrote:
> > > >   Did you try to deliver these manuals as pdf ? /
> > > >   /
> > >   /Have been delivering in pdf and html for a couple of years, 
and > > using >   Lyx for//
> > >   //authoring/editing.  Open Doc. has been used for 
translations > > mainly >   because//
> > >   //it was preferred by the translators. Decided recently to 
use > >  LO for >  authoring//
> > >   //and delivery so that users can make copies in their 
preferred > >  format. >  For both//

> > >   //pdf and html have using LO's export function: //
> > >   //File>Export as PDF
> > >   or//
> > >   //File>Export>All formats>html//
> > >   //
> > >   //The unwanted alternative text only appears on the html 
exports./

> > > >   Gordon.
> > > > > > > >   How do the users copy to html? Using the LO menu 
"Save > >  as"? or > >  selectng, then "Edition>Copy" .?

> > > > > >   Je la 24/07/2017 16:48, anne-ology skribis :
> > > > >   From my experience,
> > > > >  I would say you've uncovered a 'bug' since 
the > >  name of > > > the image

> > > > >   should only appear if the image cannot for some reason.
> > > > > > > >   Here's hoping you can find a solution anon,
> > > > > > > > > > > > > >  From: gordon cooper > > 


> > > > >   Date: Sun, Jul 23, 2017 at 5:23 PM
> > > > >   Subject: [libreoffice-users] Unwanted Alternative Image 
Names

> > > > >   To: users@global.libreoffice.org
> > > > > > > > > > >   We are using Libre Office in the writing of 
> >  technical manuals

> > > > >   

Re: [libreoffice-users] Unwanted Alternative Image Names

[Regina Henschel]

Hi Gordon,

gordon cooper schrieb:

We are using Libre Office in the writing of technical manuals
where some users make html copies.

Finding that the file names of images are being displayed
beside or below the images in the html versions. Because
all images are given a caption, we do not want the file names too.

 I can remove them by going to each image Properties>Options
and deleting one at a time but this is time consuming when there are
many images - over 100 in one manual.  Is there a setting that can
automatically prevent the file names being displayed?

Have looked through the Help but found nothing, did I overlook it?


I guess you are using File > Export > XHTML. At least with that, I can 
reproduce the problem.


It looks like an error in the XHTML filter. Using an old version of the 
filter, I see both the caption text and the alternative text of the 
picture. Using a new version of the filter (here developer version LO 
6.0), I see only the alternative text of the picture and no caption text 
at all.


Please write a bug report for the problem.

It is possible to fix the bug without compiling the LO sources. You can 
edit the filter directly. You find the filter in folder>/share/XSLT/export/xhtml. The part body.xsl is relevant here. Do 
you know someone with knowledge in XSLT?


Kind regards
Regina




--
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