[libreoffice-users] Re: My Tools, Options, Security menu doesn't exist?!?

2011-07-14 Thread floridabrits
A-ha... I am finally sorted...   thanks Larry...

I did look under the preferences but couldn't see anything but with further
investigation and poking around I found it! :-)

Here is the path for others in case they have the same problem...

LibreOffice - Preferences - LibreOffice - Security - Macro Security (then
adjust to what level you want).

Thanks for everyone's  prompt responses...

/g

--
View this message in context: 
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-exist-tp3166597p3167567.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: My Tools, Options, Security menu doesn't exist?!?

2011-07-14 Thread floridabrits
Thanks David... really appreciate the image file to point me in the right
direction...  got there in the end :-)

Cheers!

/g

--
View this message in context: 
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-exist-tp3166597p3167576.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] [Calc] Create and export chart

2011-07-14 Thread Tom Davies
Hi :)
Nicely done :)  The mailing list doesn't accept attachments so off-list is a 
good work-around.  If you send to the list but Cc the person then the person 
gets the attachments and the list doesn't.  Hopefully you will get the 
'hilarious joke' i sent as an attachment.  I don't know if it's better to send 
2 
emails or just 1 that goes to the 2 places.  The problem with just 1 is that 
other people are a bit mystified since they can't see the attachment. 

Regards from
Tom :)





From: jorge 
To: users@global.libreoffice.org
Sent: Thu, 14 July, 2011 1:50:36
Subject: Re: [libreoffice-users] [Calc] Create and export chart

Hi

I sent an e-mail answer to Mr. Kampe with How to I think he would solve
his problems.

I sent directly because I think this users@ list not accept add files
and I sent three files to him with the answer, because is to hard to
explain all with words.

If someone wants to know the answer with "How to", send an e-mail to
this users@ list and I will send a copy.

Regards,

Jorge Rodríguez
___



El mié, 13-07-2011 a las 19:13 +0200, Thorsten Kampe escribió:
> Hi,
> 
> I have a Calc file which contains multiple sheets.
> 
> - every sheet contains one month of data: from May 2010 to July 2011.
> 
> - every sheet has two columes: in column A the days and in column B the 
> actual data.
> 
> For example:
> 
> [July 2011 Sheet]
>   A  B
> 1 07/02  75.6
> 2 07/03
> 3
> 4 07/04  76.4
> 5 07/05  76.3
> 6 07/06  76.2
> 7 07/07
> 8 07/08  75.6
> 
> The data entries are sometimes empty (07/07 for example), do not always 
> start on the 1st and there are some empty rows in between.
> 
> Problem 1: I want to create a chart of all sheets/months. What do I have 
> to enter for Date Range in step 2 of the chart wizard (pre-selected is 
> $'July 2011'.$A$1:$B$3)?
> 
> Problem 2: I'd like to automatically create this chart every day and 
> export it to a PNG file. Is that doable via LibreOffice Calc?
> 
> Thanks in advance, Thorsten
> 
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Feature Request :Evolution

2011-07-14 Thread Tom Davies
Hi :)
I am having trouble getting people to use LibreOffice at work too and the 
reasons are somewhat mystifying sometimes.  They have seen LO out-perform MS 
Office in a number of ways but still don't even try to use LO.  It would be 
good 
to get an answer from the person that initially asked for help because people 
are obviously using MSO in ways that are not obvious.  

Regards from
Tom :)





From: planas 
To: users@global.libreoffice.org
Sent: Thu, 14 July, 2011 0:31:10
Subject: Re: [libreoffice-users] Feature Request :Evolution

Lorenzo

On Wed, 2011-07-13 at 11:45 +0200, Lorenzo Sutton wrote:

> Hi,
> 
> Shane Van Loenen wrote:
> > I could not find a place on the website to list a feature request, so
> > I will try here.  Open Office and Libre Office are great tools that
> > can be used in the enterprise, but since there is not an e-mail
> > client, my org will gravitate back to MS.  Anyway to integrate
> > Evolution (or like) into Libre offcie?
> Just out of curiosity... what exactly is "integration" between office
> suite and email client to you? I think there is much misunderstanding
> about this.
> I happily use LibO and Thunderbird. A software for doing office things,
> a software for doing email things.

Good question.

> Lorenzo.
> > Thanks,
> >
> > -Shane
> >
> 

For me, I do not regularly use LO email features. I tend send files as
an attachment from the email client. So good behavior for me is that
attaching files is easy and opening attachments is straightforward.

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

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: My Tools, Options, Security menu doesn't exist?!?

2011-07-14 Thread Dave Griffiths
floridabrits wrote:

> Thanks David... really appreciate the image file to point me in the right
> direction...  got there in the end :-)
> 
> Cheers!
> 
> /g
> 
> --
> View this message in context:
> http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-
exist-tp3166597p3167576.html
> Sent from the Users mailing list archive at Nabble.com.

No problem, glad to hear you got there :-)

All the best

Dave



-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: My Tools, Options, Security menu doesn't exist?!?

2011-07-14 Thread Tom Davies
Hi :)
+1 
Congrats for working out how to solve the problem. Good team-work here again.  
Thanks for all those answers.  I learned some things there, thanks  :)
Regards from
Tom :)

PS I hope to buy a new keyboard today.  New fingers would be ideal but just a 
new keyboard should help! lol





From: Dave Griffiths 
To: users@global.libreoffice.org
Sent: Thu, 14 July, 2011 9:54:01
Subject: [libreoffice-users] Re: My Tools, Options, Security menu doesn't 
exist?!?

floridabrits wrote:

> Thanks David... really appreciate the image file to point me in the right
> direction...  got there in the end :-)
> 
> Cheers!
> 
> /g
> 
> --
> View this message in context:
> http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-
exist-tp3166597p3167576.html
> Sent from the Users mailing list archive at Nabble.com.

No problem, glad to hear you got there :-)

All the best

Dave



-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Feature Request :Evolution

2011-07-14 Thread Marcello Romani

Il 12/07/2011 18:46, Shane Van Loenen ha scritto:

I could not find a place on the website to list a feature request, so
I will try here.  Open Office and Libre Office are great tools that
can be used in the enterprise, but since there is not an e-mail
client, my org will gravitate back to MS.  Anyway to integrate
Evolution (or like) into Libre offcie?

Thanks,

-Shane



OOo/LibO has options to talk to e-mail programs.
IMHO adding yet another (almos unrelated) program to an already huge 
office suite would be a bad move. I guess then people would "gravitate 
back to MS" because either: a) OOo is too "heavy" or b) they don't like 
the bundled e-mail client.


Besides, I can't see why the lack of full e-mail functionality in OOo is 
keeping one tied with Microsoft products. Just install Thunderbird or 
Evolution and off you go.
Perhaps the question is "how can I have all the features that MS Outlook 
offers with free/libre programs ?".
Just as an example, Mozilla Thunderbird + Lightning gives you e-mail, 
calendar, alarms, periodic reminders, todo-lists ("activities"). You can 
have multiple calendars, too, including remote ones.


HTH

--
Marcello Romani

--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO files?

2011-07-14 Thread Tom Davies
Hi :)
There is a LOT more than just the installer.  Stuff that really helps people be 
up and running without spending ages searching around the internet for crucial 
add-ons/extensions, language packs, dictionaries and so on.  There is a list of 
the included stuff somewhere in the wiki.  

Regards from
Tom :)





From: Michelle Konzack 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 21:22:29
Subject: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO 
files?

Hello webmaster for Kracked Press Productions,

Am 2011-07-10 09:49:11, hacktest Du folgendes herunter:
> 3.7 GB as an ISO
> 3.4 GB as a zipped file.

How do you get this size?

I create regulary Install-CD/DVD and they have ALWAYS onle the size
cunsumed never the physicaly maximum size of the medium.

Thanks, Greetings and nice Day/Evening
Michelle Konzack

-- 
# Debian GNU/Linux Consultant ##
   Development of Intranet and Embedded Systems with Debian GNU/Linux

itsystems@tdnet Franceitsystems@tdnet
Owner Michelle KonzackOwner Michelle Konzack

Apt. 917 (homeoffice) Gewerbe Straße 3
50, rue de Soultz 77694 Kehl/Germany
67100 Strasbourg/France   Tel: +49-177-9351947  mobil
Tel: +33-6-61925193 mobil Tel: +49-176-86004575 office

  
 

Jabber linux4miche...@jabber.ccc.de
ICQ#328449886

Linux-User #280138 with the Linux Counter, http://counter.li.org/

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Feature Request :Evolution

2011-07-14 Thread Stefano Fraccaro

Hi Marcello

Il 14/07/2011 11.20, Marcello Romani ha scritto:

OOo/LibO has options to talk to e-mail programs.
IMHO adding yet another (almos unrelated) program to an already huge 
office suite would be a bad move. I guess then people would "gravitate 
back to MS" because either: a) OOo is too "heavy" or b) they don't 
like the bundled e-mail client.


We use both MSO and LibO... MSO in most cases is "preferred" because it 
start faster. We have also some programs that generate doc documents 
with a collage process. In this case we should convert all procedures 
for the odt. The sysadmin mantra say: "is working? don't touch it !" ... 
I introduced a lot of open source software in the company with good 
results :)   but in some fields there is much resistance to change 
(understandable)


Besides, I can't see why the lack of full e-mail functionality in OOo 
is keeping one tied with Microsoft products. Just install Thunderbird 
or Evolution and off you go.
Perhaps the question is "how can I have all the features that MS 
Outlook offers with free/libre programs ?".
Just as an example, Mozilla Thunderbird + Lightning gives you e-mail, 
calendar, alarms, periodic reminders, todo-lists ("activities"). You 
can have multiple calendars, too, including remote ones.


Many users have changed Outlook 2000 with Thunderbird 3.1.x ... and now 
are happy TB users  :)


Stefano

--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: [Calc] Create and export chart

2011-07-14 Thread Tom Davies
Hi :)
As i see it the problems are 
1.  to get the full years data onto one sheet
2.  remove any rows where there is no data for a particular day
Making the chart based on that would be very easy
4.  exporting as png dynamically

I'm beginning to think my initial suggestion of using Base might not have been 
as bad as i first thought.  A simple Query table would add all the values and 
dates from the various sheets.  I would use another Query to remove the blanks 
but that could be done in the same Query.  I've not used Base to create charts 
but i suspect it would be easier to use that chart wherever it's needed.

Is the png needed for displaying on a web-page?
Regards from
Tom :)





From: Michael D. Setzer II 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 21:08:57
Subject: Re: [libreoffice-users] Re: [Calc] Create and export chart

On 13 Jul 2011 at 20:09, Thorsten Kampe wrote:

To: users@global.libreoffice.org
From:   Thorsten Kampe 
Subject:[libreoffice-users] Re: [Calc] Create and export 
chart
Date sent:  Wed, 13 Jul 2011 20:09:50 +0200
Send reply to:  users@global.libreoffice.org

> * Tom Davies (Wed, 13 Jul 2011 18:42:47 +0100 (BST))
> > Personally i would probably stick to Calc and insert a new sheet that
> > calculated summaries from all the other sheets and then use that as
> > the basis for a chart.
> 
> So you cannot create charts in one sheet that takes data from another 
> sheet from within the same Calc file? There is no $'ALL SHEETS'.$A$1:$B
> $3)??
> 
> If not how can I create a sheet that includes all the other sheets' 
> values?
> 
> Thorsten

I was playing with this, and couldn't figure a way to get data from 
different sheets into a chart, but did come up with something 
interest.

In a single sheet, I put the dates in column A from 1/1/2011 thru 
12/31/2011. Used =randbetween(1,10) in column B just to have 
some data.

Then did an XY graph using the Block, and that showed the whole 
years of data. 

Then went into the X-axis Scale, and turned off automatic, and set 
the minimum to 3/1/2011 and maximum to 3/30/2011 as a test, 
and got a chart with that data range..

Haven't done much with Calc, so there might be a way to 
automate the process?



> 
> 
> -- 
> Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
> In case of problems unsubscribing, write to postmas...@documentfoundation.org
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
> 


+--+
  Michael D. Setzer II -  Computer Science Instructor  
  Guam Community College  Computer Center  
  mailto:mi...@kuentos.guam.net
  mailto:msetze...@gmail.com
  http://www.guam.net/home/mikes
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer 
  http://sourceforge.net/projects/g4l/
+--+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS
SETI10996793.814598   |   EINSTEIN 6176402.050851
ROSETTA  3370540.763838   |   ABC  6867671.595982


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: RE: Re: [Calc] Create and export chart

2011-07-14 Thread Thorsten Kampe
* Thorsten Kampe (Thu, 14 Jul 2011 03:26:01 +0200)
> * Regina Henschel (Wed, 13 Jul 2011 22:36:31 +0200)
> > Thorsten Kampe schrieb:
> > > I'd like to create a line chart with the values from columm A (the
> > > dates) as the X axis and the values from column B for the Y axis
> > > and this from all sheets in the spreadsheet. As if I would not
> > > have used multiple sheets but would have put all the data just in
> > > one.
> > 
> > OK, that is clearer now. You have to use the tab "Data Series". For
> > the role "X-Values" you would write $Sheet1.A2:$Sheet3.A6 and for
> > the role "Y-Values" you would write §Sheet1.B2:$Sheet3.B6, for
> > example. The chart is drawn as if the data are $Sheet1.A2:B6
> > followed by &Sheet2.A2:B6 followed by $Sheet3.A2:B6.
> 
> That sounds good but the result doesn't look right. See the chart for
> multiple sheets[1] versus the chart I created by copying the data of
> all sheets into one sheet[2].

I finally figured it out. For reasons I don't fully understand yet, it 
was the wrong chart type: Line > Lines Only instead of XY (Scatter) > 
Lines Only. I switched to the latter and it started looking right[1] 
(and the same as if using just one sheet).

From my limited understanding and my previous exposure to charts I 
actually wanted a Lines chart and not a XY (Scatter) with lines only[2].

Anyway, thanks to everyone who helped me in this thread; and especially 
thanks to Regina, the queen of charts!

Thanks, Thorsten
[1] http://www.screencast.com/t/9jQqD8oGxD
[2] http://home.gna.org/pychart/doc/module-line-plot.html


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Label on selected data series of XY chart

2011-07-14 Thread Stefano De Toni

Hello!

I want to add label only to some selected data series of my xy chart, 
but when I select an area for label it applies to all data series.


Is it possible to apply label only to some data series?

Thank you
Stefano



--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Feature Request :Evolution

2011-07-14 Thread Marcello Romani

Il 14/07/2011 11:44, Stefano Fraccaro ha scritto:

Hi Marcello


Hi



Il 14/07/2011 11.20, Marcello Romani ha scritto:

OOo/LibO has options to talk to e-mail programs.
IMHO adding yet another (almos unrelated) program to an already huge
office suite would be a bad move. I guess then people would "gravitate
back to MS" because either: a) OOo is too "heavy" or b) they don't
like the bundled e-mail client.


We use both MSO and LibO... MSO in most cases is "preferred" because it
start faster. We have also some programs that generate doc documents


Yes, MSO has faster startup times also IME, at least on windows. On 
Ubuntu 10.04 I must say that the provided OOo takes a little time when 
first started after a reboot, but from then on, given sufficient memory 
(I have 2.5GB) it starts almost instantly.



with a collage process. In this case we should convert all procedures
for the odt. The sysadmin mantra say: "is working? don't touch it !" ...
I introduced a lot of open source software in the company with good
results :) but in some fields there is much resistance to change
(understandable)


When MSO is part of a custom software infrastructure it's almost 
impossible to remove unless the whole system is re-designed (and oftern 
re-implemented). Same for Access (I talk from experience...) :-(





Besides, I can't see why the lack of full e-mail functionality in OOo
is keeping one tied with Microsoft products. Just install Thunderbird
or Evolution and off you go.
Perhaps the question is "how can I have all the features that MS
Outlook offers with free/libre programs ?".
Just as an example, Mozilla Thunderbird + Lightning gives you e-mail,
calendar, alarms, periodic reminders, todo-lists ("activities"). You
can have multiple calendars, too, including remote ones.


Many users have changed Outlook 2000 with Thunderbird 3.1.x ... and now
are happy TB users :)


IMHO TB is far superioro to Outlook 2K. Don't know about 2K3 or newer 
versions, though.

It shurely beats OUtlook on price vs. functionality! :-)



Stefano



--
Marcello Romani

--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO files?

2011-07-14 Thread webmaster for Kracked Press Productions


Tom

The Wiki is not up-to-date

The LibreOffice-NA.US site will show you everything that is on the DVD 
ISOs [except the CSS theme files]


I do have a Windows/DOS dir/s list of the DVD - it is 33 pages long, 
since it included all the CSS theme files/data.




On 07/14/2011 05:35 AM, Tom Davies wrote:

Hi :)
There is a LOT more than just the installer.  Stuff that really helps people be
up and running without spending ages searching around the internet for crucial
add-ons/extensions, language packs, dictionaries and so on.  There is a list of
the included stuff somewhere in the wiki.

Regards from
Tom :)





From: Michelle Konzack
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 21:22:29
Subject: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO
files?

Hello webmaster for Kracked Press Productions,

Am 2011-07-10 09:49:11, hacktest Du folgendes herunter:

3.7 GB as an ISO
3.4 GB as a zipped file.

How do you get this size?

I create regulary Install-CD/DVD and they have ALWAYS onle the size
cunsumed never the physicaly maximum size of the medium.

Thanks, Greetings and nice Day/Evening
 Michelle Konzack





--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Feature Request :Evolution

2011-07-14 Thread David B Teague sr

On 7/14/2011 9:17 AM, Marcello Romani wrote:
Yes, MSO has faster startup times also IME, at least on windows. On 
Ubuntu 10.04 I must say that the provided OOo takes a little time when 
first started after a reboot, but from then on, given sufficient 
memory (I have 2.5GB) it starts almost instantly. 
I have 64 bit W7, an AMD II X4 3.2 GHz quad core processor and 4 GB RAM, 
3GB/sec SATA drives. LO starts and loads a small Writer document in 10 
seconds immediately after a reboot, and as you said, instantaneously 
thereafter.


How much faster does MSO start?

--David

--
nil significat nisi oscillat



--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO files?

2011-07-14 Thread Tom Davies
Hi :)
It might not always be up to the minute but it gives a good idea of the types 
of 
things that have been considered.  It's very useful for people outside the 
project or on the fringes of it.
Regards from
Tom :)





From: webmaster for Kracked Press Productions 
To: users@global.libreoffice.org
Sent: Thu, 14 July, 2011 14:30:06
Subject: Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing 
ISO files?


Tom

The Wiki is not up-to-date

The LibreOffice-NA.US site will show you everything that is on the DVD 
ISOs [except the CSS theme files]

I do have a Windows/DOS dir/s list of the DVD - it is 33 pages long, 
since it included all the CSS theme files/data.



On 07/14/2011 05:35 AM, Tom Davies wrote:
> Hi :)
> There is a LOT more than just the installer.  Stuff that really helps people 
be
> up and running without spending ages searching around the internet for crucial
> add-ons/extensions, language packs, dictionaries and so on.  There is a list 
of
> the included stuff somewhere in the wiki.
>
> Regards from
> Tom :)
>
>
>
>
> 
> From: Michelle Konzack
> To: users@global.libreoffice.org
> Sent: Wed, 13 July, 2011 21:22:29
> Subject: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing 
ISO
> files?
>
> Hello webmaster for Kracked Press Productions,
>
> Am 2011-07-10 09:49:11, hacktest Du folgendes herunter:
>> 3.7 GB as an ISO
>> 3.4 GB as a zipped file.
> How do you get this size?
>
> I create regulary Install-CD/DVD and they have ALWAYS onle the size
> cunsumed never the physicaly maximum size of the medium.
>
> Thanks, Greetings and nice Day/Evening
>  Michelle Konzack
>



-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: [Calc] Create and export chart

2011-07-14 Thread Andreas Säger

Hi Thorsten,

Put everything in one sheet in any order and let the data pilot do the rest.


http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot
Introduction

Many requests for software support are caused by complicated formulas and 
solutions to simple day to day procedures. For more efficient and effective 
solutions, use the DataPilot, a tool for combining, comparing, and analyzing 
large amounts of data easily. By using the DataPilot, you can view different 
summaries of the source data, display the details of areas of interest, and 
create reports, whether you are a beginner or an intermediate or advanced user.



Example pilot:

http://user.services.openoffice.org/en/forum/download/file.php?id=8592



Greetings,
Andreas


--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: [Calc] Create and export chart

2011-07-14 Thread Andreas Säger

Am 13.07.2011 22:26, Thorsten Kampe wrote:


I'd like to create a line chart with the values from columm A (the
dates) as the X axis and the values from column B for the Y axis and
this from all sheets in the spreadsheet. As if I would not have used
multiple sheets but would have put all the data just in one.

Thorsten




Thank you for clarification. Forget my first suggestion about the data 
pilot and try scenarios. A scenario is a range where you can easily 
switch the content (show January data in this range, show February data 
in the same range,...). The formatting, the formulas and the chart 
remain the same.


Example scenarios:

http://user.services.openoffice.org/en/forum/download/file.php?id=3004





--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO files?

2011-07-14 Thread Tom Davies
Hi :)
Errr, i am one of those on the outside or fringes of the project (obviously lol)
Regards from
Tom :)




From: webmaster for Kracked Press Productions 
To: users@global.libreoffice.org
Sent: Thu, 14 July, 2011 14:30:06
Subject: Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing 
ISO files?


Tom

The Wiki is not up-to-date

The LibreOffice-NA.US site will show you everything that is on the DVD 
ISOs [except the CSS theme files]

I do have a Windows/DOS dir/s list of the DVD - it is 33 pages long, 
since it included all the CSS theme files/data.



On 07/14/2011 05:35 AM, Tom Davies wrote:
> Hi :)
> There is a LOT more than just the installer.  Stuff that really helps people 
be
> up and running without spending ages searching around the internet for crucial
> add-ons/extensions, language packs, dictionaries and so on.  There is a list 
of
> the included stuff somewhere in the wiki.
>
> Regards from
> Tom :)
>
>
>
>
> 
> From: Michelle Konzack
> To: users@global.libreoffice.org
> Sent: Wed, 13 July, 2011 21:22:29
> Subject: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing 
ISO
> files?
>
> Hello webmaster for Kracked Press Productions,
>
> Am 2011-07-10 09:49:11, hacktest Du folgendes herunter:
>> 3.7 GB as an ISO
>> 3.4 GB as a zipped file.
> How do you get this size?
>
> I create regulary Install-CD/DVD and they have ALWAYS onle the size
> cunsumed never the physicaly maximum size of the medium.
>
> Thanks, Greetings and nice Day/Evening
>  Michelle Konzack
>



-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Ability to change currency as needed across a spreadsheet in Calc?

2011-07-14 Thread floridabrits
Hello LibreOffice fans...

I'm looking for some help with calc on a spreadsheet that I have set up. I'm
not sure if it needs a macro set up, or if there's something in LibreOffice
that will do this for me, or if I have to seek custom development to do
this

Here's the problem:

- I have a large risk management spreadsheet that contains a number of cells
with currency based risk numbers in it; some of these are manually entered
by the user and some are calculated from cells where the user enters the
information.
- Currently, the financial risk cells are all in USD ($) currency.
- If I have a user in another country that wants to use this spreadsheet,
I'd like that person to be able to either press a button, or select from a
drop-down list, a list of available currencies to choose from.
- When they choose their currently, I want a macro (or something!) to go and
find all the US currency based cells in the spreadsheet and change them to
the currency selected by the user.
- If I can get this to work, then this spreadsheet could pretty much be used
in any country/currency and the user would not have to go into every single
currency based cell and make the changes needed (which would be time
prohibitive).
- i.e. Looking for a minimum click solution to achieve this. I do realize
that the local install will change the currency for the user by default, but
I want to be able to over-ride this so that if a local user sees the
spreadsheet in USD and changes it to, for example, GBP, then when he sends
it back to me, I see the numbers in GBP and not my local language setting
(which would default back to USD).

I hope I have explained this clearly!   If not please don't hesitate to
ask...

Has anyone done this before or have any ideas how to achieve what I am
looking for?

Many thanks in advance.

Regards,

Geoff

--
View this message in context: 
http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169381.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Ability to change currency as needed across a spreadsheet in Calc?

2011-07-14 Thread toki

On 07/14/2011 03:04 PM, floridabrits wrote:


- If I have a user in another country that wants to use this spreadsheet,
I'd like that person to be able to either press a button, or select from a
drop-down list, a list of available currencies to choose from.


Create a specific cell style for currency, and change the currency when 
needed.


jonathon
--
If Bing copied Google, there wouldn't be anything new worth requesting.

If Bing did not copy Google, there wouldn't be anything relevant worth 
requesting.


  DaveJakeman 20110207 Groklaw.

--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing ISO files?

2011-07-14 Thread webmaster for Kracked Press Productions


I have added a link on the Wiki page for the current DOS dir/s list of 
the 3.3.3 DVD files.

This is a stop gap for the updating of that page.

http://wiki.documentfoundation.org/Marketing/Americas_LibreOffice_DVD


On 07/14/2011 10:18 AM, Tom Davies wrote:

Hi :)
It might not always be up to the minute but it gives a good idea of the types of
things that have been considered.  It's very useful for people outside the
project or on the fringes of it.
Regards from
Tom :)





From: webmaster for Kracked Press Productions
To: users@global.libreoffice.org
Sent: Thu, 14 July, 2011 14:30:06
Subject: Re: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing
ISO files?


Tom

The Wiki is not up-to-date

The LibreOffice-NA.US site will show you everything that is on the DVD
ISOs [except the CSS theme files]

I do have a Windows/DOS dir/s list of the DVD - it is 33 pages long,
since it included all the CSS theme files/data.



On 07/14/2011 05:35 AM, Tom Davies wrote:

Hi :)
There is a LOT more than just the installer.  Stuff that really helps people

be

up and running without spending ages searching around the internet for crucial
add-ons/extensions, language packs, dictionaries and so on.  There is a list

of

the included stuff somewhere in the wiki.

Regards from
Tom :)





From: Michelle Konzack
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 21:22:29
Subject: [libreoffice-users] Re: Re: Has anyone used RapidShare for sharing

ISO

files?

Hello webmaster for Kracked Press Productions,

Am 2011-07-10 09:49:11, hacktest Du folgendes herunter:

3.7 GB as an ISO
3.4 GB as a zipped file.

How do you get this size?

I create regulary Install-CD/DVD and they have ALWAYS onle the size
cunsumed never the physicaly maximum size of the medium.

Thanks, Greetings and nice Day/Evening
  Michelle Konzack







--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Error in Calc logical functions

2011-07-14 Thread John B

Hello Regina

I have ** inlaid my answers, its good to see such a different and more 
apt perspective, one I am going to have to get used to.


thanks
---

On 13/07/2011 14:14, Regina Henschel wrote:

Hi John,

John B schrieb:

Dear Regina

The way LO explains (you mention), its not a bug, but that does not mean
that it is correct either and can be classed as a false positive.

It is not until you have practical use.


LO follows the standard ODF and acts the same as main competitors.
There are some aspects,
(1) You can argue, that the standard should be changed to specify the 
behavior directly and do not leave it to the implementations. If you 
think so, you should write an request to OASIS.
(2) You think, that LO should behave different to Excel, OOo, and 
Gnumeric. Then you need very good rationals.
(3) You want to achieve something, but might have used a wrong way. 
Then you should first explain, what you want to achieve. It is likely, 
that you need different formula.


** Yes I fully understand this, its just when I are used to Lotus 123, 
then I can understand why you think the way you do; and yes I do think 
(wish)  that LO should emulate 123. In 123, in the main, does not need 
to do any cell tweaking, it does it all for you.


** Who is / are OASIS?



For example if a box ="" (say in B1 which means empty)


"box" is "cell"?
If you write ="" into a cell, the cell is not empty. Test with 
ISBLANK() will result in FALSE and tests with ISFORMULA() and ISTEXT() 
will result in TRUE. It is a common error to consider an empty string 
as empty cell.


 then box stays blank
** I can see why you would need all the" IS xyz" functions in LO and 
Excel, although Excel is not something I would hold up as a good example.
**even in LO "" still means empty cell, for the purposes of the sheets 
default  mathematical calculation mechanism (not for other purposes - 
agreed).


**try in cells * E9* =IF(D9="","","full")  and then in* F9*  
=IF(E9="","empty","full") then type in a number / letter into *D9* and 
then delete* D9 *(toggle)* *you will see what I mean .



but if box A1 = a number, then a set amount appears in B1 (in business
most people do not like a page full of zero's and unused amounts
appearing for no good reason)


Then they should format the cell not to show a zero.

** This will not work where you have an amount showing (the false 
Positive) formatting it to No zero's will only help when a zero appears 
(how annoying)

** a new command is needed  ISFALSEPOSITIVE then ignore!



What you _don't_ want to happen is as per LO, if you place any Letter in
A1 then the amount shows

eg (a very common formula)

in B1 =IF(A1=0,"",4.5) - which happens if you put any non number (a
space) in A1 even by accident, B1 will show 4.5 (a false positive).


So the formula is unsuitable, use =IF(N(A1)=0;"";4.5) for example. But 
as mentioned above, not showing a zero is a matter of formatting and 
an empty string is still a string and not a value for to use in number 
calculations. 
** This is only unsuitable in LO (and your stated industry standards)- 
please accept that again in 123 it is all taken care for you. I have 
used 123 for nearly 20years!
** I can see I am going to have to think how the LO sheet works 
before:-  how I want it to work.




Also if you now add up the row B with false positives, that would give
the wrong answer as well.

As mentioned before in Lotus 123 this does not happen.


That is the crux with "implementation-defined".


** LO / Excel  "implementation-defined"(whatever that means?) is such 
hard work!




However, I suppose it depends on your point of view and the software you
are used too. But it does mean that in the case Alejo showed, it is a
false positive, which has to be manually formula-ed out.


It is the old problem with hidden, automatic conversions and the same 
old rule "Never calculate with strings", but do explicit conversions 
before.


** There is a fundamental difference between the two method of operation 
- which I think is the crux of the matter
** In cell say in A3 you have the formula A1+ B1 and the purpose is to 
add numbers (which is  99% of the time the purpose in spread sheets)

**In LO1 + a = #value!  (error) > work needs to be done!
**In 123   1 + a = 1   (correct) > with no messing about
**Hence >/ It is the old problem //and the same old rule "Never 
calculate with strings"/ - never applied to me, as the original "old" 
industry standard spreadsheet took care of it.


**This is great (and good),  because you can "simply" type in text in 
the middle (say adding up a column in D11  =Sum(d1:d10)   then in D6, 
now if you enter  Nil or Not in Stock or  FOC etc,123 simply ignored 
it. Try that with LO? you get the/* #value!*/ in the answer box (cell). 
and maybe:- Who is going to fix it? - that's why I think its a bug - not 
because of industry standard software, but because mathematical 
manipulation is a spre

Re: [libreoffice-users] Re: RE: Re: [Calc] Create and export chart

2011-07-14 Thread Tom Davies
Hi :)
Congrats :)  Nicely found!  Thanks for the useful links.  
+1 about Regina.  Charts isn't even her main thing !
Regards from
Tom :)





From: Thorsten Kampe 
To: users@global.libreoffice.org
Sent: Thu, 14 July, 2011 12:44:08
Subject: [libreoffice-users] Re: RE: Re: [Calc] Create and export chart

* Thorsten Kampe (Thu, 14 Jul 2011 03:26:01 +0200)
> * Regina Henschel (Wed, 13 Jul 2011 22:36:31 +0200)
> > Thorsten Kampe schrieb:
> > > I'd like to create a line chart with the values from columm A (the
> > > dates) as the X axis and the values from column B for the Y axis
> > > and this from all sheets in the spreadsheet. As if I would not
> > > have used multiple sheets but would have put all the data just in
> > > one.
> > 
> > OK, that is clearer now. You have to use the tab "Data Series". For
> > the role "X-Values" you would write $Sheet1.A2:$Sheet3.A6 and for
> > the role "Y-Values" you would write §Sheet1.B2:$Sheet3.B6, for
> > example. The chart is drawn as if the data are $Sheet1.A2:B6
> > followed by &Sheet2.A2:B6 followed by $Sheet3.A2:B6.
> 
> That sounds good but the result doesn't look right. See the chart for
> multiple sheets[1] versus the chart I created by copying the data of
> all sheets into one sheet[2].

I finally figured it out. For reasons I don't fully understand yet, it 
was the wrong chart type: Line > Lines Only instead of XY (Scatter) > 
Lines Only. I switched to the latter and it started looking right[1] 
(and the same as if using just one sheet).

>From my limited understanding and my previous exposure to charts I 
actually wanted a Lines chart and not a XY (Scatter) with lines only[2].

Anyway, thanks to everyone who helped me in this thread; and especially 
thanks to Regina, the queen of charts!

Thanks, Thorsten
[1] http://www.screencast.com/t/9jQqD8oGxD
[2] http://home.gna.org/pychart/doc/module-line-plot.html


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Feature Request :Evolution

2011-07-14 Thread Marcello Romani

Il 14/07/2011 16:03, David B Teague sr ha scritto:

On 7/14/2011 9:17 AM, Marcello Romani wrote:

Yes, MSO has faster startup times also IME, at least on windows. On
Ubuntu 10.04 I must say that the provided OOo takes a little time when
first started after a reboot, but from then on, given sufficient
memory (I have 2.5GB) it starts almost instantly.

I have 64 bit W7, an AMD II X4 3.2 GHz quad core processor and 4 GB RAM,
3GB/sec SATA drives. LO starts and loads a small Writer document in 10
seconds immediately after a reboot, and as you said, instantaneously
thereafter.

How much faster does MSO start?

--David



For the record, my "feelings" about OOo startup times refer to an HP 
business desktop machine with Ubuntu 10.04 32 bit, 2.5GB RAM, PIV 3.2GHz 
(w/speedstep).


--
Marcello Romani

--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Ability to change currency as needed across a spreadsheet in Calc?

2011-07-14 Thread planas
Hi Geoff,

On Thu, 2011-07-14 at 08:04 -0700, floridabrits wrote:

> Hello LibreOffice fans...
> 
> I'm looking for some help with calc on a spreadsheet that I have set up. I'm
> not sure if it needs a macro set up, or if there's something in LibreOffice
> that will do this for me, or if I have to seek custom development to do
> this
> 
> Here's the problem:
> 
> - I have a large risk management spreadsheet that contains a number of cells
> with currency based risk numbers in it; some of these are manually entered
> by the user and some are calculated from cells where the user enters the
> information.
> - Currently, the financial risk cells are all in USD ($) currency.
> - If I have a user in another country that wants to use this spreadsheet,
> I'd like that person to be able to either press a button, or select from a
> drop-down list, a list of available currencies to choose from.
> - When they choose their currently, I want a macro (or something!) to go and
> find all the US currency based cells in the spreadsheet and change them to
> the currency selected by the user.
> - If I can get this to work, then this spreadsheet could pretty much be used
> in any country/currency and the user would not have to go into every single
> currency based cell and make the changes needed (which would be time
> prohibitive).
> - i.e. Looking for a minimum click solution to achieve this. I do realize
> that the local install will change the currency for the user by default, but
> I want to be able to over-ride this so that if a local user sees the
> spreadsheet in USD and changes it to, for example, GBP, then when he sends
> it back to me, I see the numbers in GBP and not my local language setting
> (which would default back to USD).
> 
> I hope I have explained this clearly!   If not please don't hesitate to
> ask...
> 
> Has anyone done this before or have any ideas how to achieve what I am
> looking for?
> 
> Many thanks in advance.
> 
> Regards,
> 
> Geoff
> 
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169381.html
> Sent from the Users mailing list archive at Nabble.com.
> 

If I understand you problem, you want to show the currency in a user
defined manner. One possibility is to have a cover worksheet that
summarizes the data in any currency. You might use a macro to set the
proper currency and exchange rates. 

One idea that might make finding all the cells with data to be converted
is to name each one as a one-cell range (ex the cell sheet4!C3 is named
'Fred').

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

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Error in Calc logical functions

2011-07-14 Thread Regina Henschel

Hi John,

John B schrieb:
[..]

** Who is / are OASIS?


OASIS is the organization, which prepared the ODF1.0 specification, 
which then became ISO standard. Now OASIS works on ODF1.2. This is 
currently in puplic review. For details and download links see

http://lists.oasis-open.org/archives/office/201106/msg00061.html






For example if a box ="" (say in B1 which means empty)


"box" is "cell"?
If you write ="" into a cell, the cell is not empty. Test with
ISBLANK() will result in FALSE and tests with ISFORMULA() and ISTEXT()
will result in TRUE. It is a common error to consider an empty string
as empty cell.

then box stays blank

** I can see why you would need all the" IS xyz" functions in LO and
Excel, although Excel is not something I would hold up as a good example.
**even in LO "" still means empty cell, for the purposes of the sheets
default mathematical calculation mechanism (not for other purposes -
agreed).

**try in cells * E9* =IF(D9="","","full") and then in* F9*
=IF(E9="","empty","full") then type in a number / letter into *D9* and
then delete* D9 *(toggle)* *you will see what I mean .


The comparison D9="" in cell E9 is evaluated as comparison = 
because "" is a text. Therefore the reference D9 is resolved to a text. 
So the rule in 6.3.14 in "Open Document Format for Office Applications 
(OpenDocument) Version 1.2 Part 2" is applied, which is,

If the expected type is Text, then if value is of type:
[..]
Reference: perform conversion to scalar. If the referenced cell
is empty, treat as an empty string (a text value with length 0).

Therefore the comparison D9="" resolves to TRUE, if D9 is empty.

[..]

** This is only unsuitable in LO (and your stated industry standards)-
please accept that again in 123 it is all taken care for you. I have
used 123 for nearly 20years!
** I can see I am going to have to think how the LO sheet works before:-
how I want it to work.


LibreOffice is designed to work as specified in the ODF standard. So we 
are not totally free, how to calculate.






Also if you now add up the row B with false positives, that would give
the wrong answer as well.

As mentioned before in Lotus 123 this does not happen.


That is the crux with "implementation-defined".


** LO / Excel "implementation-defined"(whatever that means?) is such
hard work!


"implementation-defined" means, that there is no rule in ODF standard, 
but each application may implement it in its own way.






However, I suppose it depends on your point of view and the software you
are used too. But it does mean that in the case Alejo showed, it is a
false positive, which has to be manually formula-ed out.


It is the old problem with hidden, automatic conversions and the same
old rule "Never calculate with strings", but do explicit conversions
before.


** There is a fundamental difference between the two method of operation
- which I think is the crux of the matter
** In cell say in A3 you have the formula A1+ B1 and the purpose is to
add numbers (which is 99% of the time the purpose in spread sheets)
**In LO 1 + a = #value! (error) > work needs to be done!
**In 123 1 + a = 1 (correct) > with no messing about


The term 1+a is mathematically nonsense, so the term "correct" is 
questionable. But I agree, that it is handy to have an automatic 
conversion to zero in this case. This discussion arises from time to 
time, but before LibreOffice can change its way to calculate it, the ODF 
standard would have to be changed.



**Hence >/ It is the old problem //and the same old rule "Never
calculate with strings"/ - never applied to me, as the original "old"
industry standard spreadsheet took care of it.

**This is great (and good), because you can "simply" type in text in the
middle (say adding up a column in D11 =Sum(d1:d10) then in D6, now if
you enter Nil or Not in Stock or FOC etc, 123 simply ignored it. Try
that with LO? you get the/* #value!*/ in the answer box (cell).


That's not correct. The function SUM is defined in a way, that it 
ignores empty or text cells inside a range. The problem is only with the 
operator +. You will get no error for =SUM(D1:D10).




[..]  > ** My (plus 10's of thousands) problem is that IBM have ditched Lotus
123 in favor of their new IBM Symphony (OOo), so I really want/need to
learn LO., but at this time it feels like swapping a right hand for a
left hand drive - and I have to peddle and use hand signals as well!



We will do our best to help you getting familiar with LibreOffice.

Kind regards
Regina



--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] [Calc] Create and export chart

2011-07-14 Thread Hylton Conacher (ZR1HPC)
Hi Thorsten,

On 13/07/11 19:18, Thorsten Kampe wrote:
> Hi,
> 
> I have a Calc file which contains multiple sheets.
> 
> - every sheet contains one month of data: from May 2010 to July 2011.
> 
> - every sheet has two columes: in column A the days and in column B the 
> actual data.

This sounds very much like the rainfall spreadsheet I use currently.
Currently it has 19 sheets and it covers the entire year as well as 5
years history.

I have attached it for you to view and adapt to your need.

I hope it assists you

Regards
Hylton
-- 

Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A)
http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] What is an "Office" Package?

2011-07-14 Thread Roland Hughes
People have been poking at this from different angles based upon what
"they" want, and what "they think" LibreOffice is or should be.  Putting
it bluntly, they are all incorrect.  When you work in IT for a
significant length of time and reach the Architect or procurement level
there is a single definition which has existed LONG BEFORE MS OFFICE
EVER CAME OUT.  In that world, and "Office" package is defined as
follows: 

A standardized bundle of software, that, when installed with the base
operating system on a desktop allows a corporate worker to do at least
90% of their job.

This definition has existed since the days of DOS before we even hand
reliable networks in corporate offices.  The "bundle" varies company to
company.  Believe it or not, it used to include PC-TOOLS and WordPerfect
at most shops then.  After it became determined that each user needed
Internet access the package requirements became:

Browser
email
word processor
Calendar tool
drawing program
Spreadsheet
database reporting tool

Some companies add presentation tool to the list, only because MS forces
that down their throat and sells them Visio for extra money.

The more highly integrated these tools are, the easier it is to bring on
new users because the keystrokes will be the same, and, they can share a
common contact database with more robust features.  The KOffice project
understood this.  OpenOffice explains why SUN went bankrupt.  They
wanted to show off Java, fine, but they left out most of the package.
LibreOffice is in the same boat.  The only one really benefiting from OO
and LO right now is IBM because they bundle their Symphony package into
Lotus Notes with full integration.  The "Notes" environment provides all
of the missing "Office" pieces.

KOffice has had a fork and is now Calligra.
http://www.ask.com/wiki/Calligra_Suite  http://www.calligra-suite.org/

I am somewhat shocked they haven't pulled KMail and Kalendar into the
package.

One thing is certain.  As Qt continues to expand its application
framework, there will be less and less of the KDE libs needed which will
make it easier for Calligra to continue supporting all of the platforms
it supports.



-- 
Roland Hughes, President
Logikal Solutions
(630)-205-1593

http://www.theminimumyouneedtoknow.com
http://www.infiniteexposure.net

No U.S. troops have ever lost their lives defending our ethanol
reserves.

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: Ability to change currency as needed across a spreadsheet in Calc?

2011-07-14 Thread floridabrits
thanks Jonathon... can you provide more details on how you do that and how it
will function when you change the currency?

Just not sure I understand what you mean...

Thank you!

/g


--
View this message in context: 
http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169533.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: What is an "Office" Package?

2011-07-14 Thread Twayne
Interesting how you think nothing ever changes or evolves or that different 
industres/departments might use the same term to mean different things. Go 
poke elsewhere if it bothers you; most won't have the time to spend reading 
this tripe anyway.

HTH,

Twayne`




-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



[libreoffice-users] Re: Ability to change currency as neededacross a spreadsheet in Calc?

2011-07-14 Thread Twayne
In news:1310666739.4101.16.camel@planas-pinguy,
planas  typed:
> Hi Geoff,
>
> On Thu, 2011-07-14 at 08:04 -0700, floridabrits wrote:
>
>> Hello LibreOffice fans...
>>
>> I'm looking for some help with calc on a spreadsheet
>> that I have set up. I'm
>> not sure if it needs a macro set up, or if there's
>> something in LibreOffice
>> that will do this for me, or if I have to seek custom
>> development to do
>> this
>>
>> Here's the problem:
>>
>> - I have a large risk management spreadsheet that
>> contains a number of cells
>> with currency based risk numbers in it; some of these
>> are manually entered
>> by the user and some are calculated from cells where the
>> user enters the
>> information.
>> - Currently, the financial risk cells are all in USD ($)
>> currency.
>> - If I have a user in another country that wants to use
>> this spreadsheet,
>> I'd like that person to be able to either press a
>> button, or select from a
>> drop-down list, a list of available currencies to choose
>> from. - When they choose their currently, I want a macro
>> (or something!) to go and
>> find all the US currency based cells in the spreadsheet
>> and change them to
>> the currency selected by the user.
>> - If I can get this to work, then this spreadsheet could
>> pretty much be used
>> in any country/currency and the user would not have to
>> go into every single
>> currency based cell and make the changes needed (which
>> would be time
>> prohibitive).
>> - i.e. Looking for a minimum click solution to achieve
>> this. I do realize
>> that the local install will change the currency for the
>> user by default, but
>> I want to be able to over-ride this so that if a local
>> user sees the
>> spreadsheet in USD and changes it to, for example, GBP,
>> then when he sends
>> it back to me, I see the numbers in GBP and not my local
>> language setting (which would default back to USD).
>>
>> I hope I have explained this clearly!   If not please
>> don't hesitate to
>> ask...
>>
>> Has anyone done this before or have any ideas how to
>> achieve what I am
>> looking for?
>>
>> Many thanks in advance.
>>
>> Regards,
>>
>> Geoff
>>
>> --
>> View this message in context:
>> http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169381.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
>
> If I understand you problem, you want to show the
> currency in a user defined manner. One possibility is to
> have a cover worksheet that summarizes the data in any
> currency. You might use a macro to set the proper
> currency and exchange rates.
>
> One idea that might make finding all the cells with data
> to be converted is to name each one as a one-cell range
> (ex the cell sheet4!C3 is named 'Fred').
>
> --
> Jay Lozier
> jsloz...@gmail.com

You could only make that work if you included a look-up on the exchange 
rates for every monetary system you wanted to use as they change daily, even 
hourly in some cases, and a number today m,ight not be accurate tomorrow. 
How much accuracy do you requre in other words? You could take a bath in 
some cases.

Otherwise, just set up your currency multipliers in hidden columns and do 
the multiplication.

HTH,

Twayne`




-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-14 Thread John B

You might find this useful

If say the name David is in cell C11, then type in D11  
=CHAR(CODE(C11))   will return the "D" the 1st Character


regards

John B

-



On 12/07/2011 09:48, Dietrich Bollmann wrote:

Hi,

for a paper I have to only render the Initials of the first name in the
list of references:

   At the place of:  Anderson, David
   I have to use:Anderson, D.

Any idea how to do that with the bibliography tools of libre office?

Thanks, Dietrich






--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


Re: [libreoffice-users] Ability to change currency as needed across a spreadsheet in Calc?

2011-07-14 Thread jorge
Hi

Excuse me but I think you have another problem (Not only change de
currency symbol):

The type change currency between USD and other countries (If you want
that the people looks a correct value). 

Regards,

Jorge





El jue, 14-07-2011 a las 14:05 -0400, planas escribió:
> Hi Geoff,
> 
> On Thu, 2011-07-14 at 08:04 -0700, floridabrits wrote:
> 
> > Hello LibreOffice fans...
> > 
> > I'm looking for some help with calc on a spreadsheet that I have set up. I'm
> > not sure if it needs a macro set up, or if there's something in LibreOffice
> > that will do this for me, or if I have to seek custom development to do
> > this
> > 
> > Here's the problem:
> > 
> > - I have a large risk management spreadsheet that contains a number of cells
> > with currency based risk numbers in it; some of these are manually entered
> > by the user and some are calculated from cells where the user enters the
> > information.
> > - Currently, the financial risk cells are all in USD ($) currency.
> > - If I have a user in another country that wants to use this spreadsheet,
> > I'd like that person to be able to either press a button, or select from a
> > drop-down list, a list of available currencies to choose from.
> > - When they choose their currently, I want a macro (or something!) to go and
> > find all the US currency based cells in the spreadsheet and change them to
> > the currency selected by the user.
> > - If I can get this to work, then this spreadsheet could pretty much be used
> > in any country/currency and the user would not have to go into every single
> > currency based cell and make the changes needed (which would be time
> > prohibitive).
> > - i.e. Looking for a minimum click solution to achieve this. I do realize
> > that the local install will change the currency for the user by default, but
> > I want to be able to over-ride this so that if a local user sees the
> > spreadsheet in USD and changes it to, for example, GBP, then when he sends
> > it back to me, I see the numbers in GBP and not my local language setting
> > (which would default back to USD).
> > 
> > I hope I have explained this clearly!   If not please don't hesitate to
> > ask...
> > 
> > Has anyone done this before or have any ideas how to achieve what I am
> > looking for?
> > 
> > Many thanks in advance.
> > 
> > Regards,
> > 
> > Geoff
> > 
> > --
> > View this message in context: 
> > http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169381.html
> > Sent from the Users mailing list archive at Nabble.com.
> > 
> 
> If I understand you problem, you want to show the currency in a user
> defined manner. One possibility is to have a cover worksheet that
> summarizes the data in any currency. You might use a macro to set the
> proper currency and exchange rates. 
> 
> One idea that might make finding all the cells with data to be converted
> is to name each one as a one-cell range (ex the cell sheet4!C3 is named
> 'Fred').
> 
> -- 
> Jay Lozier
> jsloz...@gmail.com
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Re: What is an "Office" Package?

2011-07-14 Thread David H. Lipman
From: "Roland Hughes" 

> People have been poking at this from different angles based upon what
> "they" want, and what "they think" LibreOffice is or should be.  Putting
> it bluntly, they are all incorrect.  When you work in IT for a
> significant length of time and reach the Architect or procurement level
> there is a single definition which has existed LONG BEFORE MS OFFICE
> EVER CAME OUT.  In that world, and "Office" package is defined as
> follows:
>
> A standardized bundle of software, that, when installed with the base
> operating system on a desktop allows a corporate worker to do at least
> 90% of their job.
>
> This definition has existed since the days of DOS before we even hand
> reliable networks in corporate offices.  The "bundle" varies company to
> company.  Believe it or not, it used to include PC-TOOLS and WordPerfect
> at most shops then.  After it became determined that each user needed
> Internet access the package requirements became: Browser email word processor
> Calendar tool
> drawing program
> Spreadsheet
> database reporting tool
>
> Some companies add presentation tool to the list, only because MS forces
> that down their throat and sells them Visio for extra money.
>
> The more highly integrated these tools are, the easier it is to bring on
> new users because the keystrokes will be the same, and, they can share a
> common contact database with more robust features.  The KOffice project
> understood this.  OpenOffice explains why SUN went bankrupt.  They
> wanted to show off Java, fine, but they left out most of the package.
> LibreOffice is in the same boat.  The only one really benefiting from OO
> and LO right now is IBM because they bundle their Symphony package into
> Lotus Notes with full integration.  The "Notes" environment provides all
> of the missing "Office" pieces.



> One thing is certain.  As Qt continues to expand its application
> framework, there will be less and less of the KDE libs needed which will
> make it easier for Calligra to continue supporting all of the platforms
> it supports.
>

Your logic is a bubble off plumb.

We were doing DOS based SpreadSheets (ex: VisiCalc) long before MOSAIC and the 
ARPANET 
becoming main stream.

Browser part of an Office Suite - NO.

Office automation needs have changed.  Let us not forget Today's need for 
digital forms 
and workflow.

You wrote...

"No U.S. troops have ever lost their lives defending our ethanol reserves."

No but they have lost their lives so you can make stupid political statements 
like that.

-- 
Dave
Multi-AV Scanning Tool - http://multi-av.thespykiller.co.uk
http://www.pctipp.ch/downloads/dl/35905.asp 




-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] Re: What is an "Office" Package?

2011-07-14 Thread Roland Hughes
Your bottom posting equates to the IQ of your logic.  I was there for
Visicalc and DOS had nothing to do with it.  Visicalc had its Heyday on
CPM and the Commodore Super Pet.  Visicalc followed CPM into oblivion
replaced by many DOS based contenders until Lotus 123 ruled the
corporate desktop around 1986 give or take.

Office Automation needs have changed.  Today, a Browser is part of the
Standard Corporate Desktop.  Some day you might, though I have strong
doubts, become educated enough to actually know something about which
you type.  For the past decade and a half corporate America has been
embracing SOA  (Services Oriented Architecture) of which I've published
a highly regarded book on, where legacy/heritage data silos are exposed
via internal and external Web pages.

Bottom posters contribute so little to societyyour remark dissing
the troops proves that your parents should have chosen abortion over
birth.

On Thu, 2011-07-14 at 21:54 -0400, David H. Lipman wrote:

> From: "Roland Hughes" 
> 
> > People have been poking at this from different angles based upon what
> > "they" want, and what "they think" LibreOffice is or should be.  Putting
> > it bluntly, they are all incorrect.  When you work in IT for a
> > significant length of time and reach the Architect or procurement level
> > there is a single definition which has existed LONG BEFORE MS OFFICE
> > EVER CAME OUT.  In that world, and "Office" package is defined as
> > follows:
> >
> > A standardized bundle of software, that, when installed with the base
> > operating system on a desktop allows a corporate worker to do at least
> > 90% of their job.
> >
> > This definition has existed since the days of DOS before we even hand
> > reliable networks in corporate offices.  The "bundle" varies company to
> > company.  Believe it or not, it used to include PC-TOOLS and WordPerfect
> > at most shops then.  After it became determined that each user needed
> > Internet access the package requirements became: Browser email word 
> > processor
> > Calendar tool
> > drawing program
> > Spreadsheet
> > database reporting tool
> >
> > Some companies add presentation tool to the list, only because MS forces
> > that down their throat and sells them Visio for extra money.
> >
> > The more highly integrated these tools are, the easier it is to bring on
> > new users because the keystrokes will be the same, and, they can share a
> > common contact database with more robust features.  The KOffice project
> > understood this.  OpenOffice explains why SUN went bankrupt.  They
> > wanted to show off Java, fine, but they left out most of the package.
> > LibreOffice is in the same boat.  The only one really benefiting from OO
> > and LO right now is IBM because they bundle their Symphony package into
> > Lotus Notes with full integration.  The "Notes" environment provides all
> > of the missing "Office" pieces.
> 
> 
> 
> > One thing is certain.  As Qt continues to expand its application
> > framework, there will be less and less of the KDE libs needed which will
> > make it easier for Calligra to continue supporting all of the platforms
> > it supports.
> >
> 
> Your logic is a bubble off plumb.
> 
> We were doing DOS based SpreadSheets (ex: VisiCalc) long before MOSAIC and 
> the ARPANET 
> becoming main stream.
> 
> Browser part of an Office Suite - NO.
> 
> Office automation needs have changed.  Let us not forget Today's need for 
> digital forms 
> and workflow.
> 
> You wrote...
> 
> "No U.S. troops have ever lost their lives defending our ethanol reserves."
> 
> No but they have lost their lives so you can make stupid political statements 
> like that.
> 
> -- 
> Dave
> Multi-AV Scanning Tool - http://multi-av.thespykiller.co.uk
> http://www.pctipp.ch/downloads/dl/35905.asp 
> 
> 
> 
> 


-- 
Roland Hughes, President
Logikal Solutions
(630)-205-1593

http://www.theminimumyouneedtoknow.com
http://www.infiniteexposure.net

No U.S. troops have ever lost their lives defending our ethanol
reserves.

-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


RE: [libreoffice-users] Re: What is an "Office" Package?

2011-07-14 Thread Dennis E. Hamilton
First, Visicalc was a *big* hit on Apple ][.

Secondly, it would be good to tone this down.  Way down.  And talk about 
problems of mutual concern and not matters that have nothing to do with use of 
LibreOffice and the typical office-worker desktop computer software.  

There is nothing to be accomplished here with regard to other matters.
 
The personal attacks are unseemly and are not likely to inspire useful 
responses from those who might otherwise be interested in exploring this topic 
with you.

 - Dennis

-Original Message-
From: Roland Hughes [mailto:rol...@logikalsolutions.com] 
Sent: Thursday, July 14, 2011 20:19
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: What is an "Office" Package?

[ ... ]



-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] [Ping Moderator(s)] Re: What is an "Office" Package?

2011-07-14 Thread NoOp
On 07/14/2011 08:19 PM, Roland Hughes wrote:
> Your bottom posting equates to the IQ of your logic.  I was there for
...
> 
> Bottom posters contribute so little to societyyour remark dissing
> the troops proves that your parents should have chosen abortion over
> birth.
...

Enough already. Are there no moderators on this list that can/will put
Roland out to moderation? I can (of course) continue to use email client
filters to filter out such nonsense, but there must be some limits on
this list.




-- 
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted