Issue 46895 - MS- interop : send email as .doc .xls .ppt
Summary: MS- interop : send email as .doc .xls .ppt
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: ui (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0.3
Assignee: h.ilter
QA Contact: issues@framework
URL: http://specs.openoffice.org/appwide/s...
Keywords: oooqa, rfe_eval_ok
: 15848 18432 21326 55584 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-04-07 07:25 UTC by einstienindia
Modified: 2006-05-11 16:23 UTC (History)
8 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Proposed patch for the enhancement (19.67 KB, text/plain)
2005-04-07 07:28 UTC, einstienindia
no flags Details
new patch (26.50 KB, patch)
2006-02-24 09:20 UTC, noel.power
no flags Details | Diff
Test case specification (12.42 KB, text/html)
2006-04-07 11:22 UTC, h.ilter
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description einstienindia 2005-04-07 07:25:29 UTC
A user should be able to send as email (File->send as ...)the document (calc
impress and doc) in MS format(.xls, .doc, .ppt).

Currently a user have to  do a painful conversion such as "save as" and then
send the document. Could not find appropriate component to file :(
Comment 1 einstienindia 2005-04-07 07:28:56 UTC
Created attachment 24771 [details]
Proposed patch for the enhancement
Comment 2 michael.ruess 2005-04-07 08:34:00 UTC
Appropriate component is framework.
Comment 3 carsten.driesner 2005-04-07 16:43:39 UTC
CD: I have just looked through your proposed patch and from a technical point of
view it looks ok. I am a little bit concered about the massive amount of slots
used for sending a documents with different file formats as an e-mail. The PDF
feature was just a quick additional implementation, so we decided to use a new
slot. If we want to support more than pdf and the default file format, we should
use a more common approach (something like SID_MAIL_SENDDOCASFORMAT) and provide
the format as a parameter.

SfxBoolItem SendMailDocAsFormat SID_MAIL_SENDDOCASFORMAT
(SfxStringItem Recipient SID_MAIL_RECIPIENT,SfxStringItem Subject
SID_MAIL_SUBJECT,SfxStringItem MailText SID_MAIL_TEXT,SfxUInt16Item Priority
SID_MAIL_PRIORITY,SfxStringItem FilterName SID_FILTER_NAME, SfxStringItem
FilterOptions SID_FILE_FILTEROPTIONS)

The menu can use the following commands to provide the filter:
".uno:SendMailDocAsFormat?FilterName:string=<filter name1>
".uno:SendMailDocAsFormat?FilterName:string=<filter name2>
Comment 4 udomerk 2005-04-08 11:28:52 UTC
I am just working with 1.9.91-linux.  
 
When I save a file as doc or xls I cannot send it by  
"send -> document as e-mail". And no error message is coming ... 
 
With pdf and OO-format it is working, but "send as email" is 
really irritating when you are limited to certain formats.  
 
 
  
  
Comment 5 marshall 2005-04-26 20:48:27 UTC
I can confirm this is annoying with 1.9.93. this is not an enhancement but a
serious bug, since it was working on 1.1.4 version. it should not ne neted as new
Comment 6 marshall 2005-04-26 20:51:20 UTC
mistyped: it should not be treated as new feature.
Comment 7 einstienindia 2005-04-27 06:48:40 UTC
Its not a new feature, as the bug was filed as enhancement. The patches were 
created for m79 so there are some changes that needs to be done for m92+ 
versions. "send as xls/ppt/doc" was not there in 114 too, IHMO Only pdf was 
present.
Comment 8 marshall 2005-04-27 07:16:43 UTC
well, i remember i used that in 1.1.4 and more, I tried that in 1.1.4 before i
posted so I know it was present.
Comment 9 lohmaier 2005-10-30 11:35:20 UTC
*** Issue 18432 has been marked as a duplicate of this issue. ***
Comment 10 lohmaier 2005-10-30 11:37:33 UTC
*** Issue 15848 has been marked as a duplicate of this issue. ***
Comment 11 lohmaier 2005-10-30 11:40:16 UTC
*** Issue 55584 has been marked as a duplicate of this issue. ***
Comment 12 lohmaier 2005-10-30 11:45:17 UTC
what about a Menu Entry "Send in other formats" that will popup a dialog where
one can select the desired format.

I guess it won't be too exotic that one wishes to send the document both in
editable format as well as PDF or to send it in both odt and doc.

@jayant_madavi: Could you modify the patch so it works like cd suggested?
Comment 13 lohmaier 2005-10-30 11:46:59 UTC
*** Issue 21326 has been marked as a duplicate of this issue. ***
Comment 14 noel.power 2006-02-24 09:17:36 UTC
add cd as cc:
Carsten I'm uploading a new version of the patch, it would be great to get some
feedback. Thanks
Comment 15 noel.power 2006-02-24 09:18:07 UTC
I don't think Jayant is looking after this anymore, anyway there was a bug with
the original patch ( it seems attaching an unsaved ( untitlted ) document as pdf
just doesn't work ) ). 
So, yes agreed the excessive Slot usage is a problem. I have reworked the patch
to cater for that as per your sugguestions. But, unfamiliarity with SIDs,
resource files and such leave me with more questions. So first a little about
the patch, then I'll try and outline my questions.

a) removed SID_MAIL_SENDDOCASPDF, so "Send Mail", "Send Mail as PDF attachment",
"Send Mail as MS xxxx attachment" all now use the same command. :-)
b) I didn't change the name of either the existing SLOT or the existing command,
of course if thats really an issue thats not a problem to change ( imo the
existing command with the additional filter arg is clear enough ) e.g. for calc
the commands are as follows
    + ".uno:SendMail" for attach 'this' calc doc
    + ".uno:SendMail?FilterName:string=calc_pdf_Export" attach doc as pdf
    + ".uno:SendMail?FilterName:string=MS Excel 95" attach doc as XL file
c) a good thing is now the SfxMailModel_Impl::SaveDocAsPDF method is no more,
and a fair amound of code duplication gone with it, see the patch for more info.
so to my questions, 
a) in the patch I removed a number of instances of
SID_MAIL_SENDDOCASPDF/ITEM_FILE_MAIL_SENDDOCASPDF, in svx/inc/globlmn_tmpl.hrc
these seem to defined the help-id and translations for en & de. I thought that
the translations were defined in the xml file. Maybe this is an artifact from a
previous implementation, could you clarify
b) Similarly in  sd/source/ui/app/menuids2_tmpl.src it seems there is a
redundandt Menu structure definition, again info on that would be great

I'd dearly like to get this into OO2.0, maybe its possible for 2.0.3, I'm
willing to help out to do that.
Comment 16 noel.power 2006-02-24 09:20:32 UTC
Created attachment 34428 [details]
new patch
Comment 17 noel.power 2006-02-24 09:20:53 UTC
add myself as cc
Comment 18 carsten.driesner 2006-02-24 15:39:39 UTC
cd: Set myself as owner again.
cd->npower: Thank you for your great work. Please give me some time to verify
your changes. I think we should be able to get this into OOo 2.0.3 as it makes
life easier for many people using the "Send doc as e-Mail" feature. I add user
experience on cc. 
cd->cj,fl: What do you think about this enhancement?
Comment 19 carsten.driesner 2006-02-24 15:40:39 UTC
cd: Started.
Comment 20 noel.power 2006-02-25 09:15:41 UTC
npower->cd thanks :-) for your quick response, might I suggest that issue 35780
be added to whatever cws this gets done in. I know this issue is closed [1], but
it mentions an rfe ( sorry I dont't know what the rfe number is, I'll try to dig
and see if I can find it if I get a chance )

[1] 
    * the issue in question is imo wrongly closed, it does however mention that
there is a ( as yet not found ) RFE associated with it. 
    * the fix is extreemly trivial ( or so it seems from a glance )
    * the present ( apparently works as specified ) behavior is imho very very
wrong.
    * if you agree with the above statements, then it makes sense to fix this at
the same time ( they are somewhat related )
Of course if I can do anything to make any of this happen quickly/easily etc.
just let me know.
Comment 21 kami911 2006-02-28 12:11:28 UTC
I am not sure if some of UI text are localizable:
officecfg/registry/data/org/openoffice/Office/UI/CalcCommands.xcu
officecfg/registry/data/org/openoffice/Office/UI/WriterCommands.xcu
officecfg/registry/data/org/openoffice/Office/UI/DrawImpressCommands.xcu	
because it misses the de text version...
Comment 22 christian.jansen 2006-03-06 13:42:21 UTC
CJ -> CD: Here are my two cents.
From a users point of view I suggest to add the following UI to this feature.

- The attachment has in any case the name of the document
- Systems default e-mail client, or the e-mail client specified in Ooo options
hasto be launched automatically with the document attached.
- The File -> Send menu should be extendend by the following entries listed below

For Writer:
[position: BELOW Document as PDFAttachment…]
Document as Microsoft Word Attachment…
Dokument als Microsoft Word-Anhang…

For Calc:
[position: BELOW Document as PDFAttachment…]
Document as Microsoft Excel Attachment…
Dokument als Microsoft Excel-Anhang…

For Impress:
[position: BELOW Document as PDFAttachment…]
Document as Microsoft PowerPoint Attachment…
Dokument als Microsoft PowerPoint-Anhang…

For Draw:
[position: BELOW Document as PDFAttachment…]
Document as Microsoft PowerPoint Attachment…
Dokument als Microsoft PowerPoint-Anhang…
Comment 23 carsten.driesner 2006-03-06 14:34:04 UTC
cd: Positive feedback from user experience. I set this issue to OOo 2.0.3 and
start to integrate it.
Comment 24 noel.power 2006-03-13 16:51:00 UTC
npower->cd
Can you tell me which cws this is worked on?
Comment 25 carsten.driesner 2006-03-14 08:26:08 UTC
cd->npower: CWS fwk36. Work in progress as I want to fix other bugs related to
"send document as e-mail", too.
Comment 26 noel.power 2006-03-14 10:07:45 UTC
npower->cd
>CWS fwk36. Work in progress as I want to fix other bugs related to
>"send document as e-mail", too.
Thats no problem, I'm not trying to hassle you :-) I just want to track it for
my own purposes ( e.g. I can replace my patch with yours, I need to monitor the
cws so I can remove this patch from ooo-build when this cws is integrated etc...
) Anyway thanks for taking care of this :-)
Comment 27 carsten.driesner 2006-03-15 16:53:02 UTC
cd->npower: I hope that we have a working CWS on friday. We changed your patch
to have a better abstraction from the sfx internals. The current implementation
only uses UNO API, so we would be able to move this code into a separate
service. I also fixed i35780 (we now use a temporary folder).
Comment 28 noel.power 2006-03-15 17:04:14 UTC
npower->cd I look forward to seeing the changes you made ( good opportunity for
me to learn ), brilliant to here that issue 35780 is also dealt with. Thanks again
Comment 29 carsten.driesner 2006-03-20 13:10:32 UTC
cd: The menu item for draw must be removed as it is not able to export its
content to a MS file format. 
Comment 30 carsten.driesner 2006-03-20 14:29:57 UTC
cd: My approach to fix this issue has a big drawback. Using a paramter to
provide the document filter or type is not useful, if someone wants to customize
this command. The customize dialog currently only works with plain
slots/commands. It doesn't support something like parameters. Therefore the
solution uses a slot/command which has a type parameter, but uses MS file format
as default. This provides maximum flexibility and the user is able to customize
this new command to a toolbar or menu bar.
Comment 31 carsten.driesner 2006-03-21 16:17:21 UTC
cd->hi: Please verify.

cd->npower: The fix should be complete now. If want to know any details or you
need help, don't hesitate to ask me. Thanks again for your work and patch.

re-open issue and reassign to hi@openoffice.org
Comment 32 carsten.driesner 2006-03-21 16:17:36 UTC
reassign to hi@openoffice.org
Comment 33 carsten.driesner 2006-03-21 16:17:42 UTC
reset resolution to FIXED
Comment 34 noel.power 2006-03-21 16:44:52 UTC
>cd->npower: The fix should be complete now. If want to know any details or you
>need help, don't hesitate to ask me. Thanks again for your work and patch.
npower->cd: No! thank YOU, for handling this, unfortunately I havent't had a
chance to look at the latest and greatest version yet :-(
Comment 35 h.ilter 2006-03-23 13:19:42 UTC
Verified with cws fwk36 = ok
Comment 36 matthias.mueller-prove 2006-03-24 14:33:25 UTC
add me to cc list
Comment 37 carsten.driesner 2006-03-24 16:55:46 UTC
cd: Added missing spec URL.
Comment 38 matthias.mueller-prove 2006-03-27 08:42:05 UTC
Hi Carsten, the spec does not load for me. Better a corupt spec than a corupt
colleague, gell?
Comment 39 h.ilter 2006-04-07 11:22:53 UTC
Created attachment 35555 [details]
Test case specification
Comment 40 h.ilter 2006-05-11 16:23:40 UTC
Verified with 680m168 = ok