Re: [libreoffice-users] Email more than once .doc file

2012-05-07 Thread Ing. Jiří Hladůvka

Dne 7.5.2012 6:04, Marc Paré napsal(a):
A couple of users who are using LibreOffice professionally are 
wondering if it was possible to email their .odt files through the 
File-Send-Email as Microsoft Word not only one at a time? There 
are many occasions where they need to email to contacts but need to 
send .doc formatted files.


The File-Send-Email as Microsoft Word allows emailing .odt files 
into .doc without being forced to save the same file into an identical 
.doc file.


They said that they would really like a function where the 
Send-Email as Microsoft Word that would allow to do this with more 
than only one file at a time.


Cheers,

Marc



Why should be the LibO a clon from M$ Word?
There is no obstacle for the users to download and install LibO
as an alternative software for reading open document format
if the M$ apps are not able to show o.d.files correctly.

Regards,
Jiri

--
Ing. Jiří Hladůvka - REVIDA

http://www.revida.sk
mailto:m...@revida.sk


--
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Gergely Buday
Hi there,

I made the mistake to have one image as Drawing and another one as
Illustration. Now I want to change the Drawing into Illustration. The
Caption entry in the Insert menu is only for creating a new caption -
how can I get a similar menu for editing a caption?

- Gergely

-- 
For unsubscribe instructions e-mail to: users+h...@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: Impress on mac g4 - graphics filter not found

2012-05-07 Thread Alexander Thurgood
Le 05/05/12 16:42, David Lawson a écrit :

Hi David,


 I am trying to put together a picture presentation using Impress. Using a mac 
 mini running Lion I am having no problem. As the presentation will be given 
 elsewhere I want to use a G4 laptop running osx 10.4.11. Transfering the file 
 fails to work as it fails to include all of the pictures. Any attempt to 
 rebuild on the G4 fails as it says Graphics filter not found on most of the 
 pictures, all jpeg. I can use some other pictures, as a test, but there seems 
 to be no consistency.
 I am using LibreOffice 3.5.3.2 on the G4 and LibreOffice 3.5.0rc3 on the mac 
 mini.
 

As far as I can recall, some of the more recent JPEG formats aren't
fully supported on Tiger, I used to use Xee to provide that support for
me instead of Preview. These apps provide the background
conversion/display libraries for handling those kinds of files, and LO
will use system libraries where available.


Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Tom Davies
Hi :)
You can just click into the text of an existing caption and then edit it as 
normal text.  
Regards from
Tom :)


--- On Mon, 7/5/12, Gergely Buday gbu...@gmail.com wrote:

From: Gergely Buday gbu...@gmail.com
Subject: [libreoffice-users] caption editing
To: users@global.libreoffice.org
Date: Monday, 7 May, 2012, 9:15

Hi there,

I made the mistake to have one image as Drawing and another one as
Illustration. Now I want to change the Drawing into Illustration. The
Caption entry in the Insert menu is only for creating a new caption -
how can I get a similar menu for editing a caption?

- Gergely

-- 
For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Mirosław Zalewski
On 07/05/2012 at 12:07, Tom Davies tomdavie...@yahoo.co.uk wrote:

 You can just click into the text of an existing caption and then edit it as
 normal text.

But you will end up with numbering not updated automatically, i.e. will got 
two Illustration 1.

There is option to edit field reference, but I was not able to get it working. 
Perhaps I was doing something wrong.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@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] Email more than once .doc file

2012-05-07 Thread Tom Davies
Hi :)
True but that doesn't help in the real world.  

Is tehre any problem with just keeping the original in odt format and then do 
Save As ... to create a doc to share with other people?
Regards from
Tom :)


--- On Mon, 7/5/12, Ing. Jiří Hladůvka m...@revida.sk wrote:

From: Ing. Jiří Hladůvka m...@revida.sk
Subject: Re: [libreoffice-users] Email more than once .doc file
To: users@global.libreoffice.org
Date: Monday, 7 May, 2012, 8:03

Dne 7.5.2012 6:04, Marc Paré napsal(a):
 A couple of users who are using LibreOffice professionally are wondering if 
 it was possible to email their .odt files through the File-Send-Email as 
 Microsoft Word not only one at a time? There are many occasions where they 
 need to email to contacts but need to send .doc formatted files.
 
 The File-Send-Email as Microsoft Word allows emailing .odt files into 
 .doc without being forced to save the same file into an identical .doc file.
 
 They said that they would really like a function where the Send-Email as 
 Microsoft Word that would allow to do this with more than only one file at a 
 time.
 
 Cheers,
 
 Marc
 
 
Why should be the LibO a clon from M$ Word?
There is no obstacle for the users to download and install LibO
as an alternative software for reading open document format
if the M$ apps are not able to show o.d.files correctly.

Regards,
Jiri

-- Ing. Jiří Hladůvka - REVIDA

http://www.revida.sk
mailto:m...@revida.sk


-- For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Brian Barker

At 10:15 07/05/2012 +0200, Gergely Buday wrote:
I made the mistake to have one image as Drawing and another one as 
Illustration. Now I want to change the Drawing into Illustration. 
The Caption entry in the Insert menu is only for creating a new 
caption - how can I get a similar menu for editing a caption?


I'm not sure there is any easy direct method.  You can edit the text 
of a caption in place.  You can even edit the headword Drawing to 
Illustration in place - but this does not modify the associated 
field, so caption numbering will no longer behave correctly: your new 
illustration will be numbered as if it were still a drawing.  That's 
your problem, of course.


Here's a workaround:
o Click in the image to select it: you will see the eight green 
handles.  Make sure you select the image and not the frame that 
contains the image and its caption.

o Cut the image (Edit | Cut or Ctrl+X).
o Click the edge of the frame that now contains just the caption to select it.
o Press Backspace to delete the frame.
o Paste the cut image (Edit | Paste or Ctrl+V).
o Now create a new Illustration caption for the new image.
o If necessary, press F9 to update the fields to renumber the 
illustrations automatically.


I trust this helps.

Brian Barker


--
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Mirosław Zalewski
On 07/05/2012 at 10:15, Gergely Buday gbu...@gmail.com wrote:

 I made the mistake to have one image as Drawing and another one as
 Illustration. Now I want to change the Drawing into Illustration. The
 Caption entry in the Insert menu is only for creating a new caption -
 how can I get a similar menu for editing a caption?

I don't think there is any menu.
Good news: your problem can be solved.
Bad news: this is not straightforward way.

Let's assume you have two images with captions from different ranges and you 
want them to be in one range (Illustration).
Go to View → Field Names (or press Ctrl+F9). Instead of number you will see 
text Number range Drawing or Illustration. Right click on that text, and 
select Fields

In lower part of new window you will see Value field. One will have 
Illustration+1 and second will have Drawing+1. You want both fields in 
captions to have the same value, e.g. Illustration+1. You may want to copy 
and paste it to be sure there is no spelling mistake.

Click OK to close that window. LO (at least 3.4.6) does not update field 
text, so you may think that nothing has changed. But if you press Ctrl+F9 
again, you will see that second number is greater than first one.

All you have to do now is manually change Drawing to Illustration in 
second caption, as Tom said.

You may want to make sure that there is checkbox checked in
Tools → Options → Appearance → Field shadings
Then all fields (automatically updated text) will have different background 
color. This way you may be sure which text is safe to remove and which has 
special meaning (it is safe to remove, too, but may break your numbering).
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Dan Lewis
On Mon, 2012-05-07 at 10:15 +0200, Gergely Buday wrote:
 Hi there,
 
 I made the mistake to have one image as Drawing and another one as
 Illustration. Now I want to change the Drawing into Illustration. The
 Caption entry in the Insert menu is only for creating a new caption -
 how can I get a similar menu for editing a caption?
 
 - Gergely

 Replace the current Drawing caption with a new Illustration
caption.
 Steps to do this:
1) Place the cursor at the end of the Drawing caption.
2) Insert a new Illustration caption.
3) Erase the Drawing caption.

 This works whether you inserted the image in a frame or used
AutoCaption.

--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Brian Barker

At 12:42 07/05/2012 +0200, Miroslaw Zalewski wrote:

On 07/05/2012 at 10:15, Gergely Buday gbu...@gmail.com wrote:
I made the mistake to have one image as Drawing and another one as 
Illustration. Now I want to change the Drawing into Illustration. 
The Caption entry in the Insert menu is only for creating a new 
caption - how can I get a similar menu for editing a caption?


I don't think there is any menu. Good news: your problem can be 
solved. Bad news: this is not straightforward way.


Let's assume you have two images with captions from different ranges 
and you want them to be in one range (Illustration). Go to View - 
Field Names (or press Ctrl+F9). Instead of number you will see text 
Number range Drawing or Illustration. Right click on that text, 
and select Fields


In lower part of new window you will see Value field. One will 
have Illustration+1 and second will have Drawing+1. You want 
both fields in captions to have the same value, e.g. 
Illustration+1. You may want to copy and paste it to be sure there 
is no spelling mistake.


Click OK to close that window. LO (at least 3.4.6) does not update 
field text, so you may think that nothing has changed. But if you 
press Ctrl+F9 again, you will see that second number is greater than first one.


All you have to do now is manually change Drawing to 
Illustration in second caption, as Tom said.


You may want to make sure that there is checkbox checked in Tools - 
Options - Appearance - Field shadings Then all fields 
(automatically updated text) will have different background color. 
This way you may be sure which text is safe to remove and which has 
special meaning (it is safe to remove, too, but may break your numbering).


Sorry, but this doesn't work.  The new field will read Drawing = 
Illustration+1 - not Illustration = Illustration+1, as it needs 
to.  This means that the modified field will give the correct 
illustration number for this illustration, but the next illustration 
will repeat the same number (and any later illustrations have numbers 
one too small), and any later drawings will in general have wrong 
numbers too.  That's why there is a problem.


Brian Barker


--
For unsubscribe instructions e-mail to: users+h...@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] Workarounds for multiple problems with the legacy Report Designer-Wizard under LO 3.5

2012-05-07 Thread Pertti Rönnberg

Fred,
I also want to thank you for an adequate discussion - more of that kind 
on this mailing list is needed!
Let us only hope it will lead to something in practice -- but I am 
afraid not.


May I take part from a slightly another point of view.
My system is Windows7/LibO3.4.6 and I do not know anything about 
LibO3.5.x versions  (too much bugs and other problems!)


If someone has managed to get LibO-Base work well enough to get a 
database created and is now ready for creating reports, then he/she is 
better not to use any (report) wizard, but use a Report Builder (RB) in 
stead;
if RB is not available for LibO yet (if not - why not?  sufficient 
documentation?) then there is an add-on for OpenO-Base -- somebody 
mentioned that LibO and OpenO are identical.
The RB is as easy (if not easier) and straight forward to use and you 
are free to decide about the report's layout as you want - with the 
wizard you are (almost) bound to the it's limitations.  With the RB you 
can do everything - and more - as with the wizard, why the wizard is 
more or less a burden.
In my experience the RB worked well but, despite promises in 
introduction, with the exception of Page/Report Header and 
Page/Report Footer.


These are not only cosmetic matters but very much needed e.g. when a 
long report covers several pages.
 you may want the Report Header (report name, date, etc.) plus the 
Page Header (e.g. column headings) on the first page, but only the Page 
Header with the column headings repeated on every next pages - no Report 
Headers are wanted there
 at the end of every page, in the Page Footer, you may want to count 
or/and sum some fields per page and finally summarize them at the end of 
the report, in the Report Footer.

(Nor did the 'horisontal-line' button draw any visible lines)
As far as I know are these not possible now -- when will these be fixed?

In my opinion also the Form Wizard is of no use - it should be skipped. 
Much better is to create the form manually using Form Design View, 
provided that both the program/development and the documentation are 
recreated to a sufficient level of functionality and quality. At least 
that helps the user to understand what he/she is doing.
in LibO there are no easy to reach and sufficient documentation 
on how to create a form (and a subform) manually using Form Design View
in LibO (with embedded HSQL) you are bound to create a form based 
on a table only (= each form on one table!) - you can not create a form 
on a query!
These errors must be immediately corrected to increase the usability and 
flexibility of LibO.

Best regards
Pertti Rönnberg



On 6.5.2012 23:01, Tom Davies wrote:

Hi :)
Nice work Fred!  Have you considered joining either the docs team (to help Dan write the 
guide for Base or develop the Faq further) or the devs team to do some Easy 
Hacks and then come back to Base?  The docs team could really use the help!
Regards from
Tom :) 



--- On Sat, 5/5/12, frofafro...@yahoo.com.au  wrote:

From: frofafro...@yahoo.com.au
Subject: [libreoffice-users] Workarounds for multiple problems with the legacy 
Report Designer-Wizard under LO 3.5
To: users@global.libreoffice.org
Date: Saturday, 5 May, 2012, 8:07

After doing a bit more investigation recently, this is a summary of what I've
found (so far) regarding the multiple problems with the legacy Report
Designer-Wizard (RDW) under LO 3.5. For convenience and succinctness, I
thought it might be worth SUMMARIZING the situation in this new message. It
seems there are (at least) 3 different problems/bugs with the RDW under LO
3.5.


SUMMARY OF PROBLEMS WITH THE REPORT-DESIGNER-WIZARD (UNDER LO 3.5)

1. All reports of course need to be based on an SQL query (whether
pre-existing, or generated 'on-the-fly' by the RDW)

2. When building a Report using the LRD, there are 2 situations (specified
in the first step of the RDW):
   a.  Select a TABLE from your database
   b.  Select a (pre-existing) QUERY from your database (referencing the
TABLE above)

3. In the first case (2a above), using LO 3.5, the wizard DOES generate the
appropriate query (with the fields and sorting the user has selected), and
stores it in the hidden COMMAND control field. But NOTE, there is still a
PROBLEM in the case where the Report needs to have GROUP HEADERS (i.e.
GROUPED on one of the database fields). In this case, the auto-generated
QUERY is incomplete, and the GROUP BY term is omitted. This can be fixed by
simply editing the QUERY in the COMMAND control field and adding the GROUP
BY term. This is effectively another BUG, in my opinion (the 'Repeated
Headings Bug'). e.g. see here:
http://nabble.documentfoundation.org/Base-and-new-Report-Builder-in-3-5-td3817159.html#a3835807

4. In the second case (2b above), the wizard either does NOT generate the
query (or does NOT copy it into the COMMAND control field) - leaving it
BLANK. So it has to be entered 'manually'. This is the 'Blank COMMAND field'
bug mentioned elsewhere.

[libreoffice-users] Issue with LibreOffice Calc after Ubuntu upgrade to 12.04

2012-05-07 Thread NLinTKO
I am experiencing an issue in LibreOffice Calc since upgrading from Ubuntu
11.10 to 12.04. I could not find the solution online, so am posting here,
hoping that somebody recognizes this and can help me. Originally I posted
the same topic at ubuntuforums.org and was advised to try it at this forum
as well.
I have several spreadsheets (both .XLS and .ODS) which have a pull down list
in some of the cells. The items in the pull down list are listed on a
separate sheet in the same file. In 12.04 is this not displayed properly
anymore. Instead of the word from the pull down list is only the row number
of the sheet where the word is listed displayed. If I create a new
spreadsheet from scratch is everything OK. So this issue only affects
already existing spreadsheets.
What could I do to get Calc to display the entries correctly without having
to manually modify all spreadsheets?

--
View this message in context: 
http://nabble.documentfoundation.org/Issue-with-LibreOffice-Calc-after-Ubuntu-upgrade-to-12-04-tp3968398.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Workarounds for multiple problems with the legacy Report Designer-Wizard under LO 3.5

2012-05-07 Thread Dan Lewis
Comments inline:

On Mon, 2012-05-07 at 15:28 +0300, Pertti Rönnberg wrote:
 Fred,
 I also want to thank you for an adequate discussion - more of that kind 
 on this mailing list is needed!
 Let us only hope it will lead to something in practice -- but I am 
 afraid not.
 
 May I take part from a slightly another point of view.
 My system is Windows7/LibO3.4.6 and I do not know anything about 
 LibO3.5.x versions  (too much bugs and other problems!)
 
 If someone has managed to get LibO-Base work well enough to get a 
 database created and is now ready for creating reports, then he/she is 
 better not to use any (report) wizard, but use a Report Builder (RB) in 
 stead;
 if RB is not available for LibO yet (if not - why not?  sufficient 
 documentation?) then there is an add-on for OpenO-Base -- somebody 
 mentioned that LibO and OpenO are identical.
 The RB is as easy (if not easier) and straight forward to use and you 
 are free to decide about the report's layout as you want - with the 
 wizard you are (almost) bound to the it's limitations.  With the RB you 
 can do everything - and more - as with the wizard, why the wizard is 
 more or less a burden.
 In my experience the RB worked well but, despite promises in 
 introduction, with the exception of Page/Report Header and 
 Page/Report Footer.
 
 These are not only cosmetic matters but very much needed e.g. when a 
 long report covers several pages.
   you may want the Report Header (report name, date, etc.) plus the 
 Page Header (e.g. column headings) on the first page, but only the Page 
 Header with the column headings repeated on every next pages - no Report 
 Headers are wanted there
   at the end of every page, in the Page Footer, you may want to count 
 or/and sum some fields per page and finally summarize them at the end of 
 the report, in the Report Footer.
 (Nor did the 'horisontal-line' button draw any visible lines)
 As far as I know are these not possible now -- when will these be fixed?

 I wish that I could answer your concerns. I have not learned of
when someone will address these problems. It is likely that Apache
OpenOffice will not have a Report Builder for Base because of these
problems, at least not until someone can solve these problems.

 In my opinion also the Form Wizard is of no use - it should be skipped. 
 Much better is to create the form manually using Form Design View, 
 provided that both the program/development and the documentation are 
 recreated to a sufficient level of functionality and quality. At least 
 that helps the user to understand what he/she is doing.
  in LibO there are no easy to reach and sufficient documentation 
 on how to create a form (and a subform) manually using Form Design View
  in LibO (with embedded HSQL) you are bound to create a form based 
 on a table only (= each form on one table!) - you can not create a form 
 on a query!

 Each have their own opinions about the Base Wizards. I prefer to
use the Form Wizard as a beginning point. It does have a limitation of
the main form and its subform. But from this beginning, I have added a
subform to a subform by editing the form. In another embedded database,
I also have created a form containing the main form, its subform (a
table), and two queries based upon that table. When I change data in the
table, I immediately see the corresponding changes in the queries. 

--Dan

 These errors must be immediately corrected to increase the usability and 
 flexibility of LibO.
 Best regards
 Pertti Rönnberg
 
 
 
 On 6.5.2012 23:01, Tom Davies wrote:
  Hi :)
  Nice work Fred!  Have you considered joining either the docs team (to help 
  Dan write the guide for Base or develop the Faq further) or the devs team 
  to do some Easy Hacks and then come back to Base?  The docs team could 
  really use the help!
  Regards from
  Tom :) 
 
 
  --- On Sat, 5/5/12, frofafro...@yahoo.com.au  wrote:
 
  From: frofafro...@yahoo.com.au
  Subject: [libreoffice-users] Workarounds for multiple problems with the 
  legacy Report Designer-Wizard under LO 3.5
  To: users@global.libreoffice.org
  Date: Saturday, 5 May, 2012, 8:07
 
  After doing a bit more investigation recently, this is a summary of what 
  I've
  found (so far) regarding the multiple problems with the legacy Report
  Designer-Wizard (RDW) under LO 3.5. For convenience and succinctness, I
  thought it might be worth SUMMARIZING the situation in this new message. It
  seems there are (at least) 3 different problems/bugs with the RDW under LO
  3.5.
 
 
  SUMMARY OF PROBLEMS WITH THE REPORT-DESIGNER-WIZARD (UNDER LO 3.5)
 
  1. All reports of course need to be based on an SQL query (whether
  pre-existing, or generated 'on-the-fly' by the RDW)
 
  2. When building a Report using the LRD, there are 2 situations (specified
  in the first step of the RDW):
 a.  Select a TABLE from your database
 b.  Select a (pre-existing) QUERY from your database (referencing the
  TABLE above)
 
  3. In 

[libreoffice-users] Re: Issue with LibreOffice Calc after Ubuntu upgrade to 12.04

2012-05-07 Thread chimak111

NLinTKO wrote
 ... Originally I posted the same topic at ubuntuforums.org and was advised
 to try it at this forum as well.
 ...
I had also suggested that you could upload a sample file that illustrates
your problem.

--
View this message in context: 
http://nabble.documentfoundation.org/Issue-with-LibreOffice-Calc-after-Ubuntu-upgrade-to-12-04-tp3968398p3968933.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: Email more than once .doc file

2012-05-07 Thread Marc Paré

Hi Jiri and Tom

Le 2012-05-07 06:18, Tom Davies a écrit :

Hi :)
True but that doesn't help in the real world.

Is tehre any problem with just keeping the original in odt format and then do Save As 
... to create a doc to share with other people?
Regards from
Tom :)


--- On Mon, 7/5/12, Ing. Jiří Hladůvkam...@revida.sk  wrote:

From: Ing. Jiří Hladůvkam...@revida.sk
Subject: Re: [libreoffice-users] Email more than once .doc file
To: users@global.libreoffice.org
Date: Monday, 7 May, 2012, 8:03

Dne 7.5.2012 6:04, Marc Paré napsal(a):

A couple of users who are using LibreOffice professionally are wondering if it was possible to 
email their .odt files through the File-Send-Email as Microsoft Word not 
only one at a time? There are many occasions where they need to email to contacts but need to 
send .doc formatted files.

The File-Send-Email as Microsoft Word allows emailing .odt files into .doc 
without being forced to save the same file into an identical .doc file.

They said that they would really like a function where the Send-Email as Microsoft 
Word that would allow to do this with more than only one file at a time.

Cheers,

Marc



Why should be the LibO a clon from M$ Word?
There is no obstacle for the users to download and install LibO
as an alternative software for reading open document format
if the M$ apps are not able to show o.d.files correctly.

Regards,
Jiri

-- Ing. Jiří Hladůvka - REVIDA

http://www.revida.sk
mailto:m...@revida.sk



Jiri: Both of these people work for professional organizations where the 
organizations have settled on the .docx format as their default document 
format. For one of these people, installing LibreOffice at his 
university is simply not an option for now. The other person works for a 
large music organization that has also settled on MSO although she is 
advocating LibreOffice with some sort of success, but not yet endorsed 
by the organization.


Tom: Both of these people are already exporting their files in .doc or 
.pdf files. The problem with this is that they now have a ton of files 
that have been doubled; they are both at the admin levels of their 
organizations and have very active roles in committees.


Being able to Send more than one file at a time would eliminate 
completely the need to export physical files to hardrives.


I was thinking if LibreOffice were able to do this, then people would 
grow to depend on the ODF file formats more and view any other file 
format as being less important. The perception to users would be that 
ODF formats are the defacto format and other are really sub-formats 
to the defacto OFD formats.


Perhaps add this as a feature request?

Marc


--
For unsubscribe instructions e-mail to: users+h...@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: Email more than once .doc file

2012-05-07 Thread Tom Davies
Hi :)
+1
This link might help you post a feature request
http://wiki.documentfoundation.org/BugReport
Regards from
Tom :)



--- On Mon, 7/5/12, Marc Paré m...@marcpare.com wrote:

From: Marc Paré m...@marcpare.com
Subject: [libreoffice-users] Re: Email more than once .doc file
To: users@global.libreoffice.org
Date: Monday, 7 May, 2012, 18:18

Hi Jiri and Tom

Le 2012-05-07 06:18, Tom Davies a écrit :
 Hi :)
 True but that doesn't help in the real world.

 Is there any problem with just keeping the original in odt format and then do 
 Save As ... to create a doc to share with other people?
 Regards from
 Tom :)


 --- On Mon, 7/5/12, Ing. Jiří Hladůvkam...@revida.sk  wrote:

 From: Ing. Jiří Hladůvkam...@revida.sk
 Subject: Re: [libreoffice-users] Email more than once .doc file
 To: users@global.libreoffice.org
 Date: Monday, 7 May, 2012, 8:03

 Dne 7.5.2012 6:04, Marc Paré napsal(a):
 A couple of users who are using LibreOffice professionally are wondering if 
 it was possible to email their .odt files through the File-Send-Email as 
 Microsoft Word not only one at a time? There are many occasions where they 
 need to email to contacts but need to send .doc formatted files.

 The File-Send-Email as Microsoft Word allows emailing .odt files into 
 .doc without being forced to save the same file into an identical .doc file.

 They said that they would really like a function where the Send-Email as 
 Microsoft Word that would allow to do this with more than only one file at 
 a time.

 Cheers,

 Marc


 Why should LibO be a clone of M$ Word?
 There is no obstacle for the users to download and install LibO
 as an alternative software for reading open document format
 if the M$ apps are not able to show o.d.files correctly.

 Regards,
 Jiri

 -- Ing. Jiří Hladůvka - REVIDA

 http://www.revida.sk
 mailto:m...@revida.sk


Jiri: Both of these people work for professional organizations where the 
organizations have settled on the .docx format as their default document 
format. For one of these people, installing LibreOffice at his university is 
simply not an option for now. The other person works for a large music 
organization that has also settled on MSO although she is advocating 
LibreOffice with some sort of success, but not yet endorsed by the organization.

Tom: Both of these people are already exporting their files in .doc or 
.pdf files. The problem with this is that they now have a ton of files 
that have been doubled; they are both at the admin levels of their 
organizations and have very active roles in committees.

Being able to Send more than one file at a time would eliminate 
completely the need to export physical files to hardrives.

I was thinking if LibreOffice were able to do this, then people would 
grow to depend on the ODF file formats more and view any other file 
format as being less important. The perception to users would be that ODF 
formats are the defacto format and other are really sub-formats to the 
defacto OFD formats.

Perhaps add this as a feature request?

Marc


-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Mirosław Zalewski
On 07/05/2012 at 13:49, Brian Barker b.m.bar...@btinternet.com wrote:

 Sorry, but this doesn't work.  The new field will read Drawing = 
 Illustration+1 - not Illustration = Illustration+1, as it needs 
 to.  This means that the modified field will give the correct 
 illustration number for this illustration, but the next illustration 
 will repeat the same number (and any later illustrations have numbers 
 one too small), and any later drawings will in general have wrong 
 numbers too.  That's why there is a problem.

You are right. I checked only for two images and it seemed to be working. Too 
bad it is really not.

Perhaps workaround presented in your post is the only way to achieve what 
Gergely was asking (apart from editing content.xml in odt file, of course).
Don't you think this is serious UI issue? Maybe it should be raised on UI list 
or reported as bug?
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Mirosław Zalewski
On 07/05/2012 at 12:18, Brian Barker b.m.bar...@btinternet.com wrote:

 Here's a workaround:
 o Click in the image to select it: you will see the eight green 
 handles.  Make sure you select the image and not the frame that 
 contains the image and its caption.
 o Cut the image (Edit | Cut or Ctrl+X).
 o Click the edge of the frame that now contains just the caption to select
 it. o Press Backspace to delete the frame.
 o Paste the cut image (Edit | Paste or Ctrl+V).
 o Now create a new Illustration caption for the new image.
 o If necessary, press F9 to update the fields to renumber the 
 illustrations automatically.

Is it really necessary to remove also frame?

My test case: three images with captions. First is Illustration 1, second is 
Drawing 1 and third is Illustration 2. I have removed Drawing 1 caption inside 
frame; only text, image and frame was still there. Then I selected image and 
added Illustration caption. Effect: first image had Illustration 1, second 
Illustration 2 and third Illustration 3.
Then I inserted fourth image and it had caption Illustration 4.

It seems to be desired behavior, although my test case was so simple, I might 
have missed something important here (again :( ).
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@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] how add new alphabetic and numeric for generate in CALC?

2012-05-07 Thread manuel_songokuh
hello

i wanted to add new alphabetic + numeric for create generate like key 128bit or 
64bit or 32bit in a cell from CALC libreoffice 3.5?  also can uo and down ( abc 
and ABC, mix: AbC)?

example:
cell is A1: df6rEI9f753lr3xldgjm2we0d or 

-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Dan Lewis
On Mon, 2012-05-07 at 20:13 +0200, Mirosław Zalewski wrote:
 On 07/05/2012 at 13:49, Brian Barker b.m.bar...@btinternet.com wrote:
 
  Sorry, but this doesn't work.  The new field will read Drawing = 
  Illustration+1 - not Illustration = Illustration+1, as it needs 
  to.  This means that the modified field will give the correct 
  illustration number for this illustration, but the next illustration 
  will repeat the same number (and any later illustrations have numbers 
  one too small), and any later drawings will in general have wrong 
  numbers too.  That's why there is a problem.
 
 You are right. I checked only for two images and it seemed to be working. Too 
 bad it is really not.
 
 Perhaps workaround presented in your post is the only way to achieve what 
 Gergely was asking (apart from editing content.xml in odt file, of course).
 Don't you think this is serious UI issue? Maybe it should be raised on UI 
 list 
 or reported as bug?
 -- 
 Best regards
 Mirosław Zalewski
 

  I wonder what happened to my reply sent 12 hours ago? Here it is
again:

 Replace the current Drawing caption with a new Illustration
caption.
 Steps to do this:
1) Place the cursor at the end of the Drawing caption.
2) Insert a new Illustration caption.
3) Erase the Drawing caption.

 This works whether you inserted the image in a frame or used
AutoCaption.

--Dan



-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Tom Davies
Hi :)
+1 
Well, kinda.  I don't think it's a serious UI problem but i still think it 
would be good to create a feature request for it.
Regards from
Tom :)

--- On Mon, 7/5/12, Mirosław Zalewski mini...@poczta.onet.pl wrote:

From: Mirosław Zalewski mini...@poczta.onet.pl
Subject: Re: [libreoffice-users] caption editing
To: users@global.libreoffice.org
Date: Monday, 7 May, 2012, 19:13

On 07/05/2012 at 13:49, Brian Barker b.m.bar...@btinternet.com wrote:

 Sorry, but this doesn't work.  The new field will read Drawing = 
 Illustration+1 - not Illustration = Illustration+1, as it needs 
 to.  This means that the modified field will give the correct 
 illustration number for this illustration, but the next illustration 
 will repeat the same number (and any later illustrations have numbers 
 one too small), and any later drawings will in general have wrong 
 numbers too.  That's why there is a problem.

You are right. I checked only for two images and it seemed to be working. Too 
bad it is really not.

Perhaps workaround presented in your post is the only way to achieve what 
Gergely was asking (apart from editing content.xml in odt file, of course).
Don't you think this is serious UI issue? Maybe it should be raised on UI list 
or reported as bug?
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] LibreOffice integration into gnome-shell

2012-05-07 Thread Tom Davies
Hi :)  
You have installed the files that are in the DEBS folder.  Inside that folder 
is another folder called something like Desktop-integration.  The next step 
is to install the files in there too.  
http://wiki.documentfoundation.org/Installing_LibreOffice_on_Linux
I thought they were for the Gnome DE (or Xfce) so i'm not sure what to do if 
you are running KDE or something else.  
Regards from
Tom :)


--- On Fri, 4/5/12, Anca Tibor Attila anca.ti...@gmail.com wrote:

From: Anca Tibor Attila anca.ti...@gmail.com
Subject: [libreoffice-users] LibreOffice integration into gnome-shell
To: LibreOffice Users users@global.libreoffice.org
Date: Friday, 4 May, 2012, 22:42

Hi,

I have been trying this since a long time, googled, nothing helped. So here is 
the problem. Maybe you have some hints.

I want to use LibreOffice from the website, for it supports Thunderbird address 
book integration which is impossible with the debian packaged version (as it is 
impossible with the packaged version of Ubuntu, etc.).

Now, if I install LO, I can not add the starters to the gnome-shell favorites 
(using gnome 3.4 under debian sid - this is a reproducable problem/bug with 
other gnome versions...).

Thanks in advance,
-- Tibor
Skype: anca.tibor
Twitter: twitter.com/ancatibor
Yahoo: anca_tibor

-- For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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] caption editing

2012-05-07 Thread Brian Barker

At 20:15 07/05/2012 +0200, Miroslaw Zalewski wrote:

Is it really necessary to remove also frame?


Possibly not.

My test case: three images with captions. First is Illustration 1, 
second is Drawing 1 and third is Illustration 2. I have removed 
Drawing 1 caption inside frame; only text, image and frame was still 
there. Then I selected image and added Illustration caption. 
Effect: first image had Illustration 1, second Illustration 2 and 
third Illustration 3. Then I inserted fourth image and it had 
caption Illustration 4.


If I do this, I end up with a second frame containing the first 
frame, which is slightly messy.  But yes: the numbering works and 
this is another workaround.


Brian Barker

PS: Apologies that my mail client refuses to reproduce your L-stroke.


--
For unsubscribe instructions e-mail to: users+h...@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] how add new alphabetic and numeric for generate in CALC?

2012-05-07 Thread Brian Barker

At 19:19 07/05/2012 +0100, Manuel Songokuh wrote:
i wanted to add new alphabetic + numeric for create generate like 
key 128bit or 64bit or 32bit in a cell from CALC libreoffice 
3.5?  also can uo and down ( abc and ABC, mix: AbC)?


example: cell is A1: df6rEI9f753lr3xldgjm2we0d or


You want to create a random alphanumeric string?

These may help you in your quest:
 =INT(RAND()*10) will create a single random digit as a number.
 =CHAR(48+RAND()*10) will create a random digit as text.
 =CHAR(65+RAND()*26) will create a random capital letter.
 =CHAR(97+RAND()*26) will create a random lower-case letter.

Alternatively, you could make a list of the sixty-two characters; 
suppose these are in A1 to A62.  Then
 =INDIRECT(AINT(1+RAND()*62)) will create a single random 
character from the set.


This may give you a start; I trust it helps.

Brian Barker


--
For unsubscribe instructions e-mail to: users+h...@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] how add new alphabetic and numeric for generate in CALC?

2012-05-07 Thread manuel_songokuh
thank you for reply!
but  maybe i'm not explain good.. or i'm bad question.. i wish to generate 
automatic from a1 to a1000 with 128bit key this is possible, lenth 8 or 
12...it's possible?
see example link: http://randomkeygen.com/




 Da: Brian Barker b.m.bar...@btinternet.com
A: users@global.libreoffice.org 
Inviato: Lunedì 7 Maggio 2012 22:29
Oggetto: Re: [libreoffice-users] how add new alphabetic and numeric for 
generate in CALC?
 
At 19:19 07/05/2012 +0100, Manuel Songokuh wrote:
 i wanted to add new alphabetic + numeric for create generate like key 128bit 
 or 64bit or 32bit in a cell from CALC libreoffice 3.5?  also can uo and down 
 ( abc and ABC, mix: AbC)?
 
 example: cell is A1: df6rEI9f753lr3xldgjm2we0d or

You want to create a random alphanumeric string?

These may help you in your quest:
=INT(RAND()*10) will create a single random digit as a number.
=CHAR(48+RAND()*10) will create a random digit as text.
=CHAR(65+RAND()*26) will create a random capital letter.
=CHAR(97+RAND()*26) will create a random lower-case letter.

Alternatively, you could make a list of the sixty-two characters; suppose these 
are in A1 to A62.  Then
=INDIRECT(AINT(1+RAND()*62)) will create a single random character from the 
set.

This may give you a start; I trust it helps.

Brian Barker


-- For unsubscribe instructions e-mail to: users+h...@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
-- 
For unsubscribe instructions e-mail to: users+h...@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] Read error on .ods file

2012-05-07 Thread Paul Schwartz
I recently installed Libre Office [default on a new Ubuntu 12.04 install]. I 
have a file that opens fine with Open Office but generates a Read error with 
Libre Office.

Any clues on how to solve this problem?

TIA

Paul Schwartz

-- 
For unsubscribe instructions e-mail to: users+h...@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: Email more than once .doc file

2012-05-07 Thread Nino

On 07.05.2012 06:04, Marc Paré wrote:

A couple of users who are using LibreOffice professionally are wondering
if it was possible to email their .odt files through the
File-Send-Email as Microsoft Word not only one at a time? There are
many occasions where they need to email to contacts but need to send
.doc formatted files.

The File-Send-Email as Microsoft Word allows emailing .odt files
into .doc without being forced to save the same file into an identical
.doc file.

They said that they would really like a function where the Send-Email
as Microsoft Word that would allow to do this with more than only one
file at a time.


Did you search for a suitable Macro? I'm not familiar with Macro 
programming, but I'd suppose one could add such functionality using 
OOoBasic (or is it AOOBasic now?).


Regards, Nino






Cheers,

Marc






--
For unsubscribe instructions e-mail to: users+h...@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: Email more than once .doc file

2012-05-07 Thread Dan Lewis
On Tue, 2012-05-08 at 01:31 +0200, Nino wrote:
 On 07.05.2012 06:04, Marc Paré wrote:
  A couple of users who are using LibreOffice professionally are wondering
  if it was possible to email their .odt files through the
  File-Send-Email as Microsoft Word not only one at a time? There are
  many occasions where they need to email to contacts but need to send
  .doc formatted files.
 
  The File-Send-Email as Microsoft Word allows emailing .odt files
  into .doc without being forced to save the same file into an identical
  .doc file.
 
  They said that they would really like a function where the Send-Email
  as Microsoft Word that would allow to do this with more than only one
  file at a time.
 
  Cheers,
 
  Marc
 
Did you search for a suitable Macro? I'm not familiar with Macro 
 programming, but I'd suppose one could add such functionality using 
 OOoBasic (or is it AOOBasic now?).
 
 Regards, Nino

 Since LO has a Document Converter that will convert multiple Word,
Excel, and PowerPoint into their equivalent LO formats, OOoBasic should
be able to be used to convert documents in the opposite direction. The
only problem: I don't know how to do this either. Hopefully, someone on
this list does know.

--Dan

--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@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: Email more than once .doc file

2012-05-07 Thread Marc Paré

Hi Dan and Nino,

Le 2012-05-07 19:50, Dan Lewis a écrit :

On Tue, 2012-05-08 at 01:31 +0200, Nino wrote:

On 07.05.2012 06:04, Marc Paré wrote:

A couple of users who are using LibreOffice professionally are wondering
if it was possible to email their .odt files through the
File-Send-Email as Microsoft Word not only one at a time? There are
many occasions where they need to email to contacts but need to send
.doc formatted files.

The File-Send-Email as Microsoft Word allows emailing .odt files
into .doc without being forced to save the same file into an identical
.doc file.

They said that they would really like a function where the Send-Email
as Microsoft Word that would allow to do this with more than only one
file at a time.

Cheers,

Marc


Did you search for a suitable Macro? I'm not familiar with Macro

programming, but I'd suppose one could add such functionality using
OOoBasic (or is it AOOBasic now?).

Regards, Nino


  Since LO has a Document Converter that will convert multiple Word,
Excel, and PowerPoint into their equivalent LO formats, OOoBasic should
be able to be used to convert documents in the opposite direction. The
only problem: I don't know how to do this either. Hopefully, someone on
this list does know.

--Dan

--Dan



Thanks for the input.

I think I'll put this in as a feature request. I'll see if there could 
be an additional function in the Send option so that a user could have 
the choice of sending through email not only 1 document but multiple 
documents. It should be available to all LibreOffice users.


I think the Send option is an awesome tool but that it still needs to 
be tweaked for the regular production user.


Maybe a dev will decide to take up the challenge to modify the Send 
option.


Cheers,

Marc


--
For unsubscribe instructions e-mail to: users+h...@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] Read error on .ods file

2012-05-07 Thread Jay Lozier

Paul,

On 05/07/2012 07:11 PM, Paul Schwartz wrote:

I recently installed Libre Office [default on a new Ubuntu 12.04 install]. I 
have a file that opens fine with Open Office but generates a Read error with 
Libre Office.

Any clues on how to solve this problem?

TIA

Paul Schwartz

What is the error message? Also, can you post the file on Nabble so 
someone can try to find the problem.


A possible work around is to unzip the ods file to recover the xml data 
file and then open that in LO. I forget what the default Ubuntu archive 
utility is.


--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@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] Read error on .ods file

2012-05-07 Thread Dan Lewis
On Mon, 2012-05-07 at 21:20 -0400, Jay Lozier wrote:
 Paul,
 
 On 05/07/2012 07:11 PM, Paul Schwartz wrote:
  I recently installed Libre Office [default on a new Ubuntu 12.04 install]. 
  I have a file that opens fine with Open Office but generates a Read error 
  with Libre Office.
 
  Any clues on how to solve this problem?
 
  TIA
 
  Paul Schwartz
 
 What is the error message? Also, can you post the file on Nabble so 
 someone can try to find the problem.
 
 A possible work around is to unzip the ods file to recover the xml data 
 file and then open that in LO. I forget what the default Ubuntu archive 
 utility is.
 
 -- 
 Jay Lozier
 jsloz...@gmail.com


The name is Archive Manager, and the file name is fileroller.

--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@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] Read error on .ods file

2012-05-07 Thread Paul Schwartz






 From: Jay Lozier jsloz...@gmail.com
To: users@global.libreoffice.org 
Sent: Monday, May 7, 2012 7:20 PM
Subject: Re: [libreoffice-users] Read error on .ods file
 
Paul,

On 05/07/2012 07:11 PM, Paul Schwartz wrote:
 I recently installed Libre Office [default on a new Ubuntu 12.04 install]. I 
 have a file that opens fine with Open Office but generates a Read error with 
 Libre Office.
 
 Any clues on how to solve this problem?
 
 TIA
 
 Paul Schwartz
 
What is the error message? Also, can you post the file on Nabble so someone 
can try to find the problem.

A possible work around is to unzip the ods file to recover the xml data file 
and then open that in LO. I forget what the default Ubuntu archive utility is.

-- Jay Lozier
jsloz...@gmail.com


The error message is

Read-Error
An unknown error has occurred

I will see if I can recover the data. Is there a how-to out there?

Paul Schwartz

-- 
For unsubscribe instructions e-mail to: users+h...@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] Read error on .ods file

2012-05-07 Thread Paul Schwartz






 From: Dan Lewis elderdanle...@gmail.com
To: users@global.libreoffice.org 
Sent: Monday, May 7, 2012 8:02 PM
Subject: Re: [libreoffice-users] Read error on .ods file
 
On Mon, 2012-05-07 at 21:20 -0400, Jay Lozier wrote:
 Paul,
 
 On 05/07/2012 07:11 PM, Paul Schwartz wrote:
  I recently installed Libre Office [default on a new Ubuntu 12.04 install]. 
  I have a file that opens fine with Open Office but generates a Read error 
  with Libre Office.
 
  Any clues on how to solve this problem?
 
  TIA
 
  Paul Schwartz
 
 What is the error message? Also, can you post the file on Nabble so 
 someone can try to find the problem.
 
 A possible work around is to unzip the ods file to recover the xml data 
 file and then open that in LO. I forget what the default Ubuntu archive 
 utility is.
 

Neither gunzip nor fileroller/Archive Manager work. gunzip says

 gunzip STOCKS.ods
gzip: STOCKS.ods: unknown suffix -- ignored

Archive Manger says

Could not open STOCKS.ods

Archive type not supported.

I tried changing the name to temp.zip; same thing.

Paul

 -- 
 Jay Lozier
 jsloz...@gmail.com


    The name is Archive Manager, and the file name is fileroller.

--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@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



-- 
For unsubscribe instructions e-mail to: users+h...@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] Display of Table entries - one record repeated many times

2012-05-07 Thread frofa
This is a potentially serious problem I hadn't seen before and was pointed
out here recently...
http://en.libreofficeforum.org/node/1267

The problem manifests in at least TWO situations (at least on my setup):

1. When using the SEARCH function (button with 'binoculars' icon)
 - click on TABLE to view
 - click on the SEARCH icon and enter your search term in the 'Search for'
box
 - choose SINGLE FIELD in the 'Where to search' area
 - in SETTINGS/Position choose 'Anywhere in the field' from the menu
 - click on  SEARCH until your term is found, and REPEAT this several times
 - at some point (repeating 3 times?), the listing will show a particular
found record REPEATED many times
 - clicking SEARCH again just goes to the NEXT (REPEATED) record
 - if I CLOSE the SEARCH WINDOW, and then I simply scroll down, the repeated
records disappear off the top of the window (as expected)
 - but then, if I scroll up the list, more multiple records appear, and it's
a different record than the initial repeating record

2. If one simply OPENS a TABLE as a table listing, the problem also
manifests:
 - click on a database TABLE in Base to open the listing
 - scroll down until you reach the last of the first batch of records (99
records)
 - then scroll up, and you might see these 'spurious' repeating entries

It looks like there is something seriously wrong with display mechanism for
database/BASE tables in LO. I  opened the same database in OpenOffice 3.3,
and there are NO problems at all! I'm using a Mac with LO 3.53. I haven't
check LO 3.3.x or 3.4.x (By the way, I'm running the database showing this
problem in 'file mode' but I suspect the other users reporting this problem
are using the standard Embedded mode' configuration.) It looks like it's a
screen 'drawing' problem and, if ubiquitous, would pretty much cripple any
TABLE editing though the listing.

I'd be interested to hear if anyone else can replicate this problem or if
there are any other USER or BUG  reports about it.

- Fred


--
View this message in context: 
http://nabble.documentfoundation.org/Display-of-Table-entries-one-record-repeated-many-times-tp3970227.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Deleting charts

2012-05-07 Thread Mark Webb

Feel a bit stupid - can create a chart but can't delete it.
I'm converting from Excel.
Any pointers?

--
Mark Webb

Line +27 (21) 786 4379
Cell +27 (72) 199 1000 [Poor reception]
Fax  +27 (86) 260 1946

Skype   tomarkwebb
Email   targetlinkm...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@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] Combining data rows on one sheet

2012-05-07 Thread Kelly Holman
I need to take data rows from a bunch of sheets, and combine them all
on one sheet at the end, so I can do calculations/analysis of all the
data. Every way I've tried, doesn't work. I can't make a named range
that goes across multiple sheets, to use for a database or a Pivot
Table. I can use Consolidate, but it doesn't seem able to update
dynamically. Also it includes all the columns in between the ones I'm
interested in, and adds them up even though it doesn't make sense for
those columns.

Is there some way to do this, without programming?


-- 
~
Kelly C. Holman
Hidden Talents Tutoring
Menomonie, WI
715-231-2191

-- 
For unsubscribe instructions e-mail to: users+h...@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