[Upstream] Base Report "E-Mail as PDF" gives error instead of opening Evolution

[Tony Pursell]

Binary package hint: openoffice.org

1) lsb_release -rd
Description: Ubuntu 11.10
Release: 11.10

2) apt-cache policy libreoffice-base
libreoffice-base:
  Installed: 1:3.4.4-0ubuntu1
  Candidate: 1:3.4.4-0ubuntu1
  Version table:
 *** 1:3.4.4-0ubuntu1 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.4.3-3ubuntu2 0
        500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages

3) What is expected to happen in LibreOffice Base via the Terminal:

cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/433563/+attachment/2409961/+files/Test-A.odb && lobase -nologo Test-A.odb

Reports -> secondary click TelNos -> Open -> File -> Send -> E-Mail as PDF... -> PDF options window -> Export button is Evolution opens with the report attached in PDF format.

What happens instead is an error message is displayed https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/433563/+attachment/732492/+files/Screenshot-OpenOffice.org%203.0%20.png . This does not occur if the same is done in Writer.

ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
Package: openoffice.org-core 1:3.0.1-9ubuntu3
ProcEnviron:
 PATH=(custom, no user)
 LANG=en_GB.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Tags: ubuntu-unr
Uname: Linux 2.6.28-15-generic i686

[Lislo (lislo)]

When i send a report from openoffice base by :
- open report
- File -> Send -> E-mail as PDF
The error is :
"An error occurred in sending the message. Posible errors could be a missing
user account or defective setup
Please check the OpenOffice.org settings or your e-mail program settings."

If I send it in Writer everything is OK

[R4zoli (r4zoli)]

All email options works well with SRB Based reports.

In case of "Old" type reports, I can confirm, on windows XP, OOo 3.1.1 and
DEV300_m57 I get similar errors.

[Tony Pursell (ajpursell)]

Originally Question #82337

[Chris Cheney (ccheney)]

Do you still have this issue with the new version in Ubuntu 9.04 with the ppa at https://launchpad.net/~openoffice-pkgs/+archive/ppa or Ubuntu Karmic?

[Tony Pursell (ajpursell)]

Hi Chris

I installed Karmic 6 in VirtualBox OSE, updated it with Update Manager then installed OOo Base using the new Software Store.

The version is

openoffice.org-core 1:3.1.1-1ubuntu2 Fri Sep 4 15:36 UTC 2009

It still exhibits this bug when sending a Base report as a PDF file, but not if it is sending the same report saved as a Text file. For what it is worth, the same build (3.1.1 ooo310m19 (Build 9420)) in Windows XP has the same problem.

The error message appears as soon as the 'Report as PDF attachment' option is taken . When sending a Text file, the 'PDF Options' dialog appears when the 'Report as PDF attachment' option is taken, and before the program calls the email app.

Hope this helps. Let me know if there is any more testing I can do.

Tony

[R4zoli (r4zoli)]

This is not working with .doc document format, too.
You only can send as .odt file.

Workaround, save as .doc to file system, open file, then you can send it as .doc.
To email as pdf file, save report as .odt or .doc, open saved file, now you can
create pdf from both version.

It is same in OOO320m_6.
Now I tested on linux x86_64.

[penalvch (penalvch)]

Tony Pursell, could you please attach an example base file that demonstrates this problem? Does this occur for you in LibreOffice? If using Lucid or Maverick feel free to type at the Terminal:

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-base

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[Tony Pursell (ajpursell)]

Christopher, it is still there in LibreOffice (with Natty & Unity)

In fact all the Send > Email As... options (Open Document Text.., Microsoft Word... and PDF...) give this error for a Base Report, but not for a Writer Document. In Writer, the attachment is created and attached to a new Evolution message.

I am attaching a test database (Test-A.odb).

[penalvch (penalvch)]

Tony Pursell, please answer the following questions:

+ What is your default e-mail client that works with Writer but not in Base?
+ When you click Tools -> Options -> Internet -> E-Mail what is in the drop down box?

[Tony Pursell (ajpursell)]

Christopher,

You asked: What is your default e-mail client that works with Writer but not in Base?

As I said in #7, I use Evolution.

You asked: When you click Tools -> Options -> Internet -> E-Mail what is in the drop down box?

sensible-ooomua

The only option that works is a straight File > Send > Document as Email. This sends the report as ODT, but the problem here is that you cannot send a Base Report as PDF.

I am currently using

LibreOffice 3.4.4
OOO340m1 (Build:402)

with Ubuntu 11.10

Tony

[penalvch (penalvch)]

Tony Pursell, the issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. Thanks in advance.

[Tony Pursell (ajpursell)]

Created attachment 53886
Screen Shot sowing the error message.

Problem description:

If you open a report in Base and try to use File > Send > E-Mail as PDF... the result is an error message (see attached screen shot). This is the same for all the File > Send > E-Mail as... options.

There is no problem with File > Send > Document as E-Mail, which will attach an odt version of the report to an email using my default mailer (Evolution).

Expected behavior is found in Writer where all the File > Send > E-Mail as... options work correctly.

This problem was originally reported in OpenOffice.org version 3.0 for Ubuntu 9.04 (see https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/433563) and is still present in LibreOffice 3.4.4 and Ubuntu 11.10. It was also know to exist in OpenOffice 3.1.1 for Windows XP.

[Tony Pursell (ajpursell)]

Upstream bug added - 43277

[Tony Pursell (ajpursell)]

I do not think Evolution is relevant to this error message. The error message was also found in the Windows XP version where the mail client was Pegasus mail. In both cases the equivalent option in writer calls the mail client with an attached PDF version of the report.

I also think that the nature of the mail client is not relevant because there is a PDF dialogue box opened in Writer for the user to confirm the PDF options to be used before the mail client's new mail dialogue is called.

[julien2412 (serval2412-6)]

I confirm this with 3.4.4 on Debian testing. x86-32
I tested by letting Evolution by default (sensible-ooomua in options of Base).
Send Email works but not Send Email as PDF whereas it works well on Writer.
No error messages in console, no exception throwed in gdb during the test of sending.

[Tony Pursell (ajpursell)]

I would emphasise that this is not a bug related to Evolution. I think it will be the same whatever mail client is used, if the mail client responds to a call from LO in Writer. After all, the bug was there in Windows XP with OpenOffice.org, when I last looked.

[julien2412 (serval2412-6)]

On pc Debian x86-64, with 3.5 branch, I didn't reproduce this behaviour.
I selected "E-Mail as PDF" and it launched Icedove.
The weird thing is I expected it to try to launch Evolution since Iceweasel tries to open mailto link with Evolution.

Anyway, do you reproduce this behaviour with 3.5.1 ? (could you use a brand LO profile if possible)

[3y9m2vcwq6lm-ljhb-fkzsxrqg2c8f (3y9m2vcwq6lm-ljhb-fkzsxrqg2c8f)]

On Fedora 16 x86_64 with LO 3.5.3rc0+ I don't get this behaviour either.

Initially I hadn't got Evolution configured as mail client, so Base complained. On configuring it it still didn't load Evolution, but it did send the email, with attachment.

?

[3y9m2vcwq6lm-ljhb-fkzsxrqg2c8f (3y9m2vcwq6lm-ljhb-fkzsxrqg2c8f)]

> On configuring it it still didn't load Evolution,

Hmm, perhaps I'm expecting the wrong thing. It *did* open a message dialogue which I used to send the email. It didn't say "Evolution" on it, but on closer inspection that is what it is.

[Tony Pursell (ajpursell)]

Apologies to all for having not made any further comment on this bug after posting it. That is primarily due to it being an upstream bug report for a bug in Launchpad for Ubuntu. See https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/433563 where I have made more comments.

What I would like to point out is that it has nothing to do with the mail client (Evolution, Thunderbird, or whatever). See my comments in the above link.

As far as knowing whether this bug is fixed in any further release, I did download and install LO dev 3.5 for Ububtu, and it was still there. I have also installed Beta 2 of Ubuntu 12.04 (which has LO version 3.5.1.2) on a USB stick and have found the bug in that version. I will now wait for the final version of Ubuntu 12.04 at the end of this month and retest.

[julien2412 (serval2412-6)]

(In reply to comment #5)
...
> As far as knowing whether this bug is fixed in any further release, I did
> download and install LO dev 3.5 for Ububtu, and it was still there. I have
> also installed Beta 2 of Ubuntu 12.04 (which has LO version 3.5.1.2) on a USB
> stick and have found the bug in that version. I will now wait for the final
> version of Ubuntu 12.04 at the end of this month and retest.

Could you try 3.5.2 final with a brand new LO profile ?

[M-dr-s (m-dr-s)]

Hi Tony,

please give an update: using new components (Ubuntu and LO 3.5..5) bug still exists?

[Tony Pursell (ajpursell)]

I have tested LO version 3.5.4.2 (350m1(Build:2)) which is the version in Ubuntu 12.04 and there is no change.

File > Send > E-Mail as PDF... still gives the same error message for a Base Report but works OK for a Writer document.

I did this test both in a Guest session (with a new database and report created) and as my normal user with a new profile ~/.config/libreoffice (using the existing test database and report).

[Lionel Elie Mamane (lionel-mamane)]

Tested on Debian GNU/Linux amd64, LibreOffice 3.5.5.3 .deb packages downloaded from www.libreoffice.org (not the ones provided by Debian).

1) Menu Tools / Options / Internet / E-mail

2) Enter /usr/bin/mutt for field "E-mail program"

3) Click on "OK"

4) Send as PDF from a Base report works

[Lionel Elie Mamane (lionel-mamane)]

Tested with LibreOffice 3.4.6 (package provided by Debian). "Send / E-mail as PDF" works with /usr/bin/mutt

[Lionel Elie Mamane (lionel-mamane)]

I originally had "sensible-ooomuas" as E-mail application set in LibreOffice; this looks like a Debian extension (which Ubuntu inherited). With this, I get same error message as original reporter.

Two problems there:

1) Internet search suggests the right historical setting is "sensible-ooomua" without final "s".

2) There is no "sensible-ooomua" on my system. Maybe it got lost in the migration from OO.org to LibreOffice? I have Debian package libreoffice-common version 1:3.4.6-2.

Anyway, assuming this is a Debian/Ubuntu-specific bug and closing here.

If you get this bug with Tools / Options / Internet / E-Mail / E-mail program set to something sensible other than "sensible-ooomua" and/or "sensible-lomua", reopen this bug.

[Lionel Elie Mamane (lionel-mamane)]

(In reply to comment #11)
> I originally had "sensible-ooomuas" as E-mail application set in LibreOffice;
> this looks like a Debian extension (which Ubuntu inherited). With this, I get
> same error message as original reporter.
>
> Two problems there:
>
> 1) Internet search suggests the right historical setting is "sensible-ooomua"
> without final "s".
>
> 2) There is no "sensible-ooomua" on my system. Maybe it got lost in the
> migration from OO.org to LibreOffice? I have Debian package libreoffice-common
> version 1:3.4.6-2.

Actually, if I set it to "sensible-ooomua", it launches evolution.

[Tony Pursell (ajpursell)]

I have tested LO version 3.5.4.2 (350m1(Build:2)) which is the version in Ubuntu 12.04.

I have set Tools / Options / Internet / E-Mail / E-mail program to all of the following: "sensible-ooomua", "sensible-lomua", "/usr/bin/mutt" and "/usr/bin/evolution" and there is NO CHANGE.

File > Send > E-Mail as PDF... still gives the same error message for a Base Report, but works OK for a Writer document.

(The only thing that does not work for me is /usr/bin/mutt, which gives an error in the terminal because I do not have that program).

Pleas note that this bug is all about the difference between a Base Report and a Writer Document. It is not saying that File > Send > E-Mail as PDF... does not work per se. It is saying that it does not work for a Base Report.

I am reopening this bug.

[Tony Pursell (ajpursell)]

I have tested LO version 3.5.4.2 (350m1(Build:2)) which is the version in Ubuntu 12.04.

I have set Tools / Options / Internet / E-Mail / E-mail program to all of the following: "sensible-ooomua", "sensible-lomua", "/usr/bin/mutt" and "/usr/bin/evolution" and there is NO CHANGE.

File > Send > E-Mail as PDF... still gives the same error message for a Base Report, but works OK for a Writer document.

(The only thing that does not work for me is /usr/bin/mutt, which gives an error in the terminal because I do not have that program).

Pleas note that this bug is all about the difference between a Base Report and a Writer Document. It is not saying that File > Send > E-Mail as PDF... does not work per se. It is saying that it does not work for a Base Report.

I am reopening this bug.

[Tony Pursell (ajpursell)]

I have tested LO version 3.5.4.2 (350m1(Build:2)) which is the version in Ubuntu 12.04.

I have set Tools / Options / Internet / E-Mail / E-mail program to all of the following: "sensible-ooomua", "sensible-lomua", "/usr/bin/mutt" and "/usr/bin/evolution" and there is NO CHANGE.

File > Send > E-Mail as PDF... still gives the same error message for a Base Report, but works OK for a Writer document.

(The only thing that does not work for me is /usr/bin/mutt, which gives an error in the terminal because I do not have that program).

Please note that this bug is all about the difference between a Base Report and a Writer Document. It is not saying that File > Send > E-Mail as PDF... does not work per se. It is saying that it does not work for a Base Report.

I am reopening this bug.

[Lionel Elie Mamane (lionel-mamane)]

Reproduced in my libreoffice-3-5 dev tree with *legacy* report, not report builder report.

[Lionel Elie Mamane (lionel-mamane)]

Traced the calls; the difference is in SfxMailModel::SaveDocumentAsFormat in file sfx2/source/dialog/mailmodel.cxx

Interesting things happen around line 419:

In the working case (Report Builder report), aQuery looks like:

uno::Sequence of length 3 = {{
    Name = "Type",
    Value = uno::Any "pdf_Portable_Document_Format"
  }, {
    Name = "DocumentService",
    Value = uno::Any "com.sun.star.text.TextDocument"
  }, {
    Name = "Flags",
    Value = uno::Any 524354
  }}

and then xEnumeration->hasMoreElements() is true and aFilterName is set.

In the not working case (legacy report), aQuery looks like:

uno::Sequence of length 3 = {{
    Name = "Type",
    Value = uno::Any "pdf_Portable_Document_Format"
  }, {
    Name = "DocumentService",
    Value = uno::Any "com.sun.star.sdb.TextReportDesign"
  }, {
    Name = "Flags",
    Value = uno::Any 524354
  }}

and xEnumeration->hasMoreElements() is false, and aFilterName is not set. Thus on line 485, the procedure aborts because "aFilterName.getLength() == 0".

Now we need to find someone that understands this filter lookup stuff...

[Lionel Elie Mamane (lionel-mamane)]

Reproduction instructions for people not familiar with LibreOffice Base: download attachment 63667. Open in LibreOffice. Click on "Reports", double-click on "City Filter". It asks for parameter "Cidade", enter "London" (without the quotes), click OK.

Menu File / Send / E-mail as PDF

[Lionel Elie Mamane (lionel-mamane)]

work-around:

1) menu File / Save Copy as
2) save into some temporary file
3) open said temporary file
4) send as PDF
5) delete temporary file

[Tony Pursell (ajpursell)]

It is good to see someone looking at this seriously now. After all, this bug is about 3 years old having migrated from OpenOffice.org to LibreOffice in that time. It started originally as a question In Launchpad (https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/82337) and I reported it as a bug only because the person who asked it was not particularly technically competent to do so.

The work round of exporting to PDF then attaching the report to an email, was discussed in the reply to that question, but the OP was trying to get a more automated routine for the office to use to send reports automatically via Outlook, and, yes, I did confirm some years back that this bug affects Windows as well.

[Libreoffice-z (libreoffice-z)]

[Reproducible] with Server Installation of "LibreOffice 3.6.0.4 rc English UI/ German Locale [Build-ID: 932b512] on German WIN7 Home Premium (64bit) and attachment 63667

Proceeding due to Comment 16: Menu 'File -> Send -> As PDF' shows up error message "An error occurred in sending the message. Possible errors could be a missing user account or a defective setup. Please Check the LibreOffice settings or your e-mail program settings."

So indeed "OS=ALL"

Problem is not PDF-related, all "'Send -> E-Mail as ...' is broken

[thackert (thackert)]

Hello Tony, *,
I can confirm this bug with LO Version 3.6.1.2 (Build ID: e29a214) and installed Germanophone UI/help under Debian Testing AMD64 ... :( I am using mutt 1.5.21, but does not be the culprit, as I am able to send documents from within Writer and/or Calc ... ;)

HTH
Thomas.

[julien2412 (serval2412-6)]

Created attachment 101944
bt

On pc Debian x86-64 with master sources updated today, I could reproduce this.

I noticed that if I change
    933 else if ( !xReportDefinition.is() )
    934 xModule->setIdentifier( "com.sun.star.sdb.TextReportDesign" );
by
    933 else if ( !xReportDefinition.is() )
    934 xModule->setIdentifier( "com.sun.star.text.TextDocument" );
it worked
(see http://opengrok.libreoffice.org/xref/core/dbaccess/source/core/dataaccess/documentdefinition.cxx#934), of course it was just to test

Now, after other investigation, I think the filter doesn't work with "com.sun.star.sdb.TextReportDesign" because there's no fragment about it here:
filter/source/config/fragments/filters

Opengroking TextReportDesign gives few results, see http://opengrok.libreoffice.org/search?q=TextReportDesign&project=core&defs=&refs=&path=&hist=
I wonder if it could be removed and replaced by com.sun.star.text.TextDocument or if a filter fragment should be added.

[julien2412 (serval2412-6)]

I confirm send File > Send > Email as PDF works after having created writer_report_pdf_Export.xcu in filter/source/config/fragments/filters by putting + "make filters && make postprocess" + brand new profile

Should I keep on this way for other cases?

[julien2412 (serval2412-6)]

I didn't succeed with other cases by using fragments but replacing "com.sun.star.sdb.TextReportDesign" by "com.sun.star.text.TextDocument" makes the 3 sendings ok (ODT, Windows, PDF).

[Libreoffice-commits (libreoffice-commits)]

Julien Nabet committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=501ebd0f7c867c4df5ba84fd8b6b1a197aeeea92

Resolves fdo#43277 Send Legacy Report "E-Mail as ..."=>error message

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

[julien2412 (serval2412-6)]

Gerrit review:
4.3: https://gerrit.libreoffice.org/9997
4.2: https://gerrit.libreoffice.org/9998

[Libreoffice-commits (libreoffice-commits)]

Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-4-3":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=8bee126e1c8fe83c909fd65d8a2ea5d7fb421da1&h=libreoffice-4-3

Resolves fdo#43277 Send Legacy Report "E-Mail as ..."=>error message

It will be available in LibreOffice 4.3.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

[Libreoffice-commits (libreoffice-commits)]

Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-4-2":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=f72d77e627468b08bce23bf4a5d97cb2ac931afe&h=libreoffice-4-2

Resolves fdo#43277 Send Legacy Report "E-Mail as ..."=>error message

It will be available in LibreOffice 4.2.6.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

[Oeyher (oeyher)]

THe bug is still present in Libreoffice 4.3.0.4 on OSX.

Comment 25 says "It has been pushed to "libreoffice-4-3". It might be, but it there are still problems using this function at OSX.

[julien2412 (serval2412-6)]

Øystein Hermansen: could you be more specific? Do you reproduce the initial problem, I mean with the error popup https://bugs.freedesktop.org/attachment.cgi?id=53886 ?
If not, could you submit a new bug by using this link https://www.libreoffice.org/get-help/bug/ ?

Also, for the test, could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#Mac_OS_X) and give it a new try?

[julien2412 (serval2412-6)]

*** Bug 82038 has been marked as a duplicate of this bug. ***

[julien2412 (serval2412-6)]

4.2.6 is ok but 4.3.0.4 and master sources updated some days ago fail with same symptoms
-> Regression here

[julien2412 (serval2412-6)]

More wondering about this, the problem is different since it doesn't happen on Linux.
So I put it this one back to SOLVED and reopen the wrong dup.
Sorry for the noise.