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

[Dietrich Bollmann]

Hi, Jay,

On Tue, 2011-07-12 at 16:38 -0400, planas wrote:
> On Tue, 2011-07-12 at 17:48 +0900, Dietrich Bollmann wrote:
> > 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?
> 
> Is it practical to the replace feature EDIT>>FIND&REPLACE to replace the
> name with the initial?

Editing everything by hand was what I wanted to avoid.  But it looks as
if this might be the easiest way to solve the problem for smaller
documents...

Thanks for your answer!

Dietrich

> -- 
> 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] How to abbreviate the first name of the author?

[Dietrich Bollmann]

Hi,

Thanks for your friendly answer.

So there is no way to do this with the built-in bibliography tools
alone?  As lots of bibliography styles use Initials something like a
built-in filter would be nice.

Should I do this manipulation when the document is finished, or is it
possible to switch to a spreadsheet as bibliography database?

How do I copy the list of authors into a spreadsheet?  When marking the
authors row by pushing on the "Author" field in the header row of the
bibliography database tool, the "edit -> copy" functionality is
deactivated.  I also couldn't find any way to export the bibliography
database to a spreadsheet.

Thanks, Dietrich




On Tue, 2011-07-12 at 13:05 +0200, OBUTEX/Hladůvka wrote:
> Hi,
> - copy list of authors into spreadsheet into column A
> - type formula =FIND(",";A1;1) into B1
> - type formula =LEFT(A1;B1-1)&MID(A1;B1;3)&"." into C1
> 
> - copy&paste B1 and C1 into remaining rows
> - copy&paste column C into your document
> 
> Regards, Jiri
> 
> 
> Dne 12.7.2011 10:48, Dietrich Bollmann napsal(a):
> > 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

[libreoffice-users] Re: Feature Request :Evolution

[Andreas Säger]

Am 12.07.2011 18:46, 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?

Thanks,

-Shane



This office suite serves one single main purpose. It is the reference 
implementation of the ODF standard.
It creates office documents in the ODF file formats (*.odt, *.ods, 
*.odp) which can be read by a wide variety of programs for decades to 
come without too heavy technical problems and without any legal issues.


Document creation has nothing to do with web-content nor email. Neither 
web-content nor email suffer from proprietary file formats.


Whatever your preferred email program has to offer, it is unrelated to 
document creation.
LibreOffice should be able to cooperate with your prefered mail program 
in 3 ways:
1) When you click on a mail hyperlink your mail application should start 
up with a new email and the clicked mail address in the receipient field.
2) When you call menu:File>Send>Email your mail application should start 
with a new email and the current document attatched in ODF, Microsoft or 
PDF format.
3) You should be able to use the address lists of your email application 
for serial letters where you send the same letter to a list of 
receipients. The list will be read from the address book of your mail 
application.



--
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: Error in Calc logical functions

[Andreas Säger]

Am 12.07.2011 19:39, John B wrote:

Tom

That was the very 1st thing I thought, so I ran charmap on Arial and
chose an accii code less than a number such as # and it still comes up
TRUE.



The character "1" is not the same value as the number 1.
Any number is smaller than any number.


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

[Lorenzo Sutton]

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.

Lorenzo.
> Thanks,
>
> -Shane
>

-- 
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: Mail merge saved into individual documents

[Olivier Bietzer]

Le 12/07/2011 22:12, nvrk a écrit :

On Tue, Jul 12, 2011 at 11:21 AM, Steve Edmonds
wrote:




On 13/07/11 4:14 AM, Olivier Bietzer wrote:


Hello,
Using LibreOffice after some years under OOo...
The Mail merge has an option to save the merged documents into one single
document OR into individual documents, with some parameters to give an
individual name to each doc...
But this does NOT work, it does only create one single document...
This was working in an older OOo (3.0 ??) but does not work in 3.3, and
neither into LO 3.4.1...
Does anyone else see that problem ??
Regards,
Olivier

  Confirmed, suggest you file a bug.

steve


--
Unsubscribe instructions: E-mail to 
users+help@global.libreoffice.**org
In case of problems unsubscribing, write to postmaster@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

Encountered this some months ago with OOo.  Investigation revealed that (1)

a bug had been filed; (2) that OOo rewrote the print module for ver3.3.3
which resulted in the fault, and: (3) LibO picked it up from OOo.  The
solution for me so far is to revert to a OOo version that worked.
All the best,  nvsoar

OK, I'm waiting for the Bugzilla account to create the bug... Maybe I 
will have a look at the code to solve it myself Who knows ??

Olivier


--
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: Mail merge saved into individual documents

[Tom Davies]

Hi :)
Did you manage to file the bug-report in the LibreOffice area or OpenOffice?
http://wiki.documentfoundation.org/BugReport
Hopefully reports filed agaist LibreOffice get some sort of priority when 
people 
are looking for something to fix.  The "Easy Hacks" is a good way to pick bugs 
that you might e able to help with to develop your skills before taking on 
greater challenges.  It's even a good idea to start that way if you are an 
experienced and skilled dev although it might take a LOT less Easy Hacks before 
you get warmed-up if you are.  If you are completely new there are mentors to 
help guide you through.  

Good luck and regards from
Tom :)





From: Olivier Bietzer 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 10:52:38
Subject: [libreoffice-users] Re: Mail merge saved into individual documents

Le 12/07/2011 22:12, nvrk a écrit :
> On Tue, Jul 12, 2011 at 11:21 AM, Steve Edmonds
> wrote:
>
>>
>>
>> On 13/07/11 4:14 AM, Olivier Bietzer wrote:
>>
>>> Hello,
>>> Using LibreOffice after some years under OOo...
>>> The Mail merge has an option to save the merged documents into one single
>>> document OR into individual documents, with some parameters to give an
>>> individual name to each doc...
>>> But this does NOT work, it does only create one single document...
>>> This was working in an older OOo (3.0 ??) but does not work in 3.3, and
>>> neither into LO 3.4.1...
>>> Does anyone else see that problem ??
>>> Regards,
>>> Olivier
>>>
>>>   Confirmed, suggest you file a bug.
>> steve
>>
>>
>> --
>> Unsubscribe instructions: E-mail to 
>>users+help@global.libreoffice.**org
>> In case of problems unsubscribing, write to postmaster@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
>>
>> Encountered this some months ago with OOo.  Investigation revealed that (1)
> a bug had been filed; (2) that OOo rewrote the print module for ver3.3.3
> which resulted in the fault, and: (3) LibO picked it up from OOo.  The
> solution for me so far is to revert to a OOo version that worked.
> All the best,  nvsoar
>
OK, I'm waiting for the Bugzilla account to create the bug... Maybe I 
will have a look at the code to solve it myself Who knows ??
Olivier


-- 
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] Re: Feature Request :Evolution

[Roland Hughes]

That would be a viciously short sighted opinion, but consistent with
bottom posting.


On Wed, 2011-07-13 at 10:32 +0200, Andreas Säger wrote:

> Am 12.07.2011 18:46, 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?
> >
> > Thanks,
> >
> > -Shane
> >
> 
> This office suite serves one single main purpose. It is the reference 
> implementation of the ODF standard.
> It creates office documents in the ODF file formats (*.odt, *.ods, 
> *.odp) which can be read by a wide variety of programs for decades to 
> come without too heavy technical problems and without any legal issues.
> 
> Document creation has nothing to do with web-content nor email. Neither 
> web-content nor email suffer from proprietary file formats.
> 
> Whatever your preferred email program has to offer, it is unrelated to 
> document creation.
> LibreOffice should be able to cooperate with your prefered mail program 
> in 3 ways:
> 1) When you click on a mail hyperlink your mail application should start 
> up with a new email and the clicked mail address in the receipient field.
> 2) When you call menu:File>Send>Email your mail application should start 
> with a new email and the current document attatched in ODF, Microsoft or 
> PDF format.
> 3) You should be able to use the address lists of your email application 
> for serial letters where you send the same letter to a list of 
> receipients. The list will be read from the address book of your mail 
> application.
> 
> 


-- 
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] Error in Calc logical functions

[John B]

I had another play with this LO logic buster this morning.

Whilst in Lotus 123 would only need  @IF(A1>10,"True","False")

the way LO works the formula needs to be:-( placed in say B1 looking at 
cell A1) to cater for LO's rationale and possibly to cover prior versions.


=IF(A1="","",IF(A1>N,"",IF(A1>10,"True","False")))

N has to max out above any number in your list (eg 1000) as  it 
would appear that any Letter is seen by LO as greater than the highest 
possible number, to block this and to prevent the table seeing Letters 
as Numbers you need N.  With N in place, if you type in a letter  into 
cell  A1, then B1 remains blank and does not to give a false positive 
(or negative).


regards

John B





On 12/07/2011 19:37, John B wrote:

Got it

Regina is correct, so:-

=IF(A1>50,"False",IF(A1>10,"True","False"))

Where 50 (or 1000)  is higher than any number in your table


regards

John B

 






On 12/07/2011 19:28, John B wrote:

Alejo

The strange thing is is that if you reverse the logic such as 
=IF(A1<11  and then reverse the True & False


You get the same results table and but with A still being TRUE

I am convinced this is a bug, which stops you writing  an IF within 
an IF such as =IF(A1<11,"False",IF(A1>10,"True","False"))  which 
should work - but it doesn't.


regards

John B

 






On 12/07/2011 18:05, Alejo C.S. wrote:

Hi all, this is a little example to show what is going on.
In A column I have a numeric list from 1 to 21, in the middle I have a
letter, lets put A.
If a run this function in the next column =IF(A1>10), this function
evaluate the letter A like TRUE, why?


1FALSE
2FALSE
3FALSE
4FALSE
5FALSE
6FALSE
7FALSE
8FALSE
9FALSE
10  FALSE
11  TRUE
A   TRUE
13  TRUE
14  TRUE
15  TRUE
16  TRUE
17  TRUE
18  TRUE
19  TRUE
20  TRUE
21 TRUE

Thanks a lot in advance

C.




Internal Virus Database is out of date.
Checked by AVG - www.avg.com
Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 
07/04/11 19:35:00







Internal Virus Database is out of date.
Checked by AVG - www.avg.com
Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 
07/04/11 19:35:00







Internal Virus Database is out of date.
Checked by AVG - www.avg.com
Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 
19:35:00

   



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

[Michael D. Setzer II]

How about this formula.

=IF(ISNUMBER(A1),IF(A1>10,"True","False"),"Non-numeric")

   1
False

   2
False

   3
False

   4
False

   5
False

   6
False

   7
False

   8
False

   9
False

  10
False

  11
True

A
Non-numeric

  13
True

  14
True

  15
True

  16
True

  17
True

  18
True

  19
True

  20
True

  21
True




On 12 Jul 2011 at 20:14, Regina Henschel wrote:

Date sent:  Tue, 12 Jul 2011 20:14:27 +0200
From:   Regina Henschel 
To: users@global.libreoffice.org
Subject:Re: [libreoffice-users] Error in Calc logical 
functions
Send reply to:  users@global.libreoffice.org

> Alejo C.S. schrieb:
> > Hi all, this is a little example to show what is going on.
> > In A column I have a numeric list from 1 to 21, in the middle I have a
> > letter, lets put A.
> > If a run this function in the next column =IF(A1>10), this function
> > evaluate the letter A like TRUE, why?
> >
> >
> > 1FALSE
> > 2FALSE
> > 3FALSE
> > 4FALSE
> > 5FALSE
> > 6FALSE
> > 7FALSE
> > 8FALSE
> > 9FALSE
> > 10  FALSE
> > 11  TRUE
> > A   TRUE
> > 13  TRUE
> > 14  TRUE
> > 15  TRUE
> > 16  TRUE
> > 17  TRUE
> > 18  TRUE
> > 19  TRUE
> > 20  TRUE
> > 21 TRUE
> >
> 
> The ODF1.2 spec says ("functions" are here the comparison operators),
> "These functions return one of True, False, or an Error if Left and 
> Right have different types, but it is implementation-defined which of 
> these results will be returned when the types differ."
> 
> And OpenOffice.org and LibreOffice have the simple rule "number is less 
> than string". Excel and Gnumeric have these results too.
> 
> 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
> 


+--+
  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
SETI10992790.927474   |   EINSTEIN 6170633.720851
ROSETTA  3366299.645114   |   ABC  6849302.005189


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

[webmaster for Kracked Press Productions]

On 07/12/2011 04:10 PM, Zak McKracken wrote:
Am 10.07.2011, 15:49 Uhr, schrieb webmaster for Kracked Press 
Productions :



On 07/09/2011 07:12 PM, Zak McKracken wrote:
Am 09.07.2011, 20:40 Uhr, schrieb webmaster for Kracked Press 
Productions :>
My hosting company will not allow files larger than 700+ MB and the 
two DVD versions [3.3.3 and 3.4.1] of LibreOffice are over 3.4 GB 
in size.  The account has not issues of having 100 GB of executable 
files online but if I have any ISO files, then they say that I am a 
repository and it is not allowed.


Hmm... what would happen if you put the ISOs into a zip container? :)


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



I was refereing to the hosting company not liking iso files but having 
no problem with executables. So maybe zip files are no problem either?
Or make them self-extracting archives, so you'll have executables ... 
problem solved :)
If then it is possible to seed a torrent from that hosting machine, 
the bandwidth problem also becomes a lot less of a problem.


 Zak

P.S.: Sorry for seemingly not knowing the rest of the thread ... gmane 
gives me many of the posts a lot later than they are posted, and my 
own ones sometimes take days to become visible ...


P.P.S.: Good luck with the distribution (and maintenance!) of the 
DVDs, they seem like a pretty good idea!


It does not matter what the file is, zip, exe, html, image.  My hosting 
company will not allow DVD size files on their servers.  Every type of 
upload I have to their servers either block the upload, or will just 
show the file with a Zero file size.  They have some security scripts, 
or something, in place to make sure you cannot have such a large file on 
their servers.





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

[John B]

Michael

Excellent, I did not know ISNUMBER existed, I never needed it before,  
but for my usage I would remove the word "Non-numeric" and just leave "" 
so the cell would remain blank.


I can see that in LO or any other spreadsheet that treats Letters as 
Numbers, this would be a necessary function.


I have learned something today - thanks

John B


--

On 13/07/2011 13:24, Michael D. Setzer II wrote:

How about this formula.

=IF(ISNUMBER(A1),IF(A1>10,"True","False"),"Non-numeric")

1
False

2
False

3
False

4
False

5
False

6
False

7
False

8
False

9
False

   10
False

   11
True

A
Non-numeric

   13
True

   14
True

   15
True

   16
True

   17
True

   18
True

   19
True

   20
True

   21
True




On 12 Jul 2011 at 20:14, Regina Henschel wrote:

Date sent:  Tue, 12 Jul 2011 20:14:27 +0200
From:   Regina Henschel
To: users@global.libreoffice.org
Subject:Re: [libreoffice-users] Error in Calc logical
functions
Send reply to:  users@global.libreoffice.org

   

Alejo C.S. schrieb:
 

Hi all, this is a little example to show what is going on.
In A column I have a numeric list from 1 to 21, in the middle I have a
letter, lets put A.
If a run this function in the next column =IF(A1>10), this function
evaluate the letter A like TRUE, why?


1FALSE
2FALSE
3FALSE
4FALSE
5FALSE
6FALSE
7FALSE
8FALSE
9FALSE
10  FALSE
11  TRUE
A   TRUE
13  TRUE
14  TRUE
15  TRUE
16  TRUE
17  TRUE
18  TRUE
19  TRUE
20  TRUE
21 TRUE

   

The ODF1.2 spec says ("functions" are here the comparison operators),
"These functions return one of True, False, or an Error if Left and
Right have different types, but it is implementation-defined which of
these results will be returned when the types differ."

And OpenOffice.org and LibreOffice have the simple rule "number is less
than string". Excel and Gnumeric have these results too.

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

 


+--+
   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
SETI10992790.927474   |   EINSTEIN 6170633.720851
ROSETTA  3366299.645114   |   ABC  6849302.005189


   




Internal Virus Database is out of date.
Checked by AVG - www.avg.com
Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 
19:35:00

   



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

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

[Regina Henschel]

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.




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

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.



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.




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



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.




I cannot see any case where the reverse would be of practical use, if a
box is expecting a number and you enter in a letter then "nothing"
should be the result - In which case its a bug - unless - you know better?


If you want a cell to only expect a number, you have to set up the cell 
accordingly before entering something, otherwise a cell expects all input.


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] Error in Calc logical functions

[Tom Davies]

Hi :)
Wow!!  I wonder if this answers the bigger question behind what the original 
poster was asking.  Sometimes it's difficult to "See the forest(/wood) for the 
trees" = If you are too close to the problem it can be difficult to get a good 
overview. 


Anyway it looks as though this question has been resolved, perhaps inspired by 
the stuff i snipped from this mail.  

Congrats, thanks and regards from
Tom :):)





From: Regina Henschel 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 14:14:27
Subject: Re: [libreoffice-users] Error in Calc logical functions

Hi John,



If you want a cell to only expect a number, you have to set up the cell 
accordingly before entering something, otherwise a cell expects all input.

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] Re: Feature Request :Evolution

[Tom Davies]

Hi :)
+1 
would be my vote for how this all works.  I've not really tried it but 
hopefully 
it works that way for several email clients possibly including the proprietary 
"The Bat".  I tend to prefer OpenSource programs such as Thunderbird or Claws 
and suspect that Thunderbird is the most likely one to work well.  Evo has a 
surprisingly small team and would probably welcome more devs.  It would 
certainly be good to support them better.  

Regards from
Tom :)





From: Andreas Säger 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 9:32:05
Subject: [libreoffice-users] Re: Feature Request :Evolution



Whatever your preferred email program has to offer, it is unrelated to document 
creation.
LibreOffice should be able to cooperate with your preferred mail program in 3 
ways:
1) When you click on a mail hyper-link your mail application should start up 
with a new email and the clicked mail address in the recipient field.
2) When you call menu:File>Send>Email your mail application should start with a 
new email and the current document attached in ODF, Microsoft or PDF format.
3) You should be able to use the address lists of your email application for 
serial letters where you send the same letter to a list of recipients. The list 
will be read from the address book of your mail application.
-- 
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] When using "tools -> update -> update all" bibliography styles get lost.

[Tom Davies]

Hi :)
If it works fine using ODF formats such as Odt then it's possibly either a 
problem or restriction of the alternative format you are trying to use or else 
it's a problem with LibreOffice's implementation.  Either way it's probably a 
good idea to post a bug report and mention which format in the subject line.  

http://wiki.documentfoundation.org/BugReport

If the bad results are with a proprietary format such as .Doc, .DocX, .Pdf then 
it might take a long time before the problem can get fixed.  Open Document 
Format issues are probably easier to pin-down.  


Regards from
Tom :)





From: Dietrich Bollmann 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 7:43:27
Subject: [libreoffice-users] When using "tools -> update -> update all" 
bibliography styles get lost.

Hi, 

I configured the styles applied to the bibliography via the "styles" tab
of the bibliography tool.  But whenever I use  "tools -> update ->
update all" they get lost again.

Also, when saving the document in another format, the bibliography is
not exported.

Am I doing something wrong or are these problems 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

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

[Tom Davies]

Hi :)
Keyboard short-cuts sometimes work when menus don't
Ctrl C = copy
Ctrl X = cut (X looks a little like a pair of scissors)
Ctrl V = Paste
Ctrl Shift V = sometimes pastes 'without formatting' (doesn't work in my 
web-based email program)
Also selecting the Authors in a different way might work but i don't really 
understand exactly how they are held in the document.

If it's not confidential you could try forwarding me a copy by attaching the 
document (or part of the document) in a personal email to me.  Just use 
copy&paste to put my email address in the "To" or "Cc" field.  The mailing list 
doesn't accept attachments
Good luck and regards from
Tom :)




From: Dietrich Bollmann 
To: ad...@obutex.com
Cc: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 4:49:27
Subject: Re: [libreoffice-users] How to abbreviate the first name of the author?

Hi,

Thanks for your friendly answer.

So there is no way to do this with the built-in bibliography tools
alone?  As lots of bibliography styles use Initials something like a
built-in filter would be nice.

Should I do this manipulation when the document is finished, or is it
possible to switch to a spreadsheet as bibliography database?

How do I copy the list of authors into a spreadsheet?  When marking the
authors row by pushing on the "Author" field in the header row of the
bibliography database tool, the "edit -> copy" functionality is
deactivated.  I also couldn't find any way to export the bibliography
database to a spreadsheet.

Thanks, Dietrich




On Tue, 2011-07-12 at 13:05 +0200, OBUTEX/Hladůvka wrote:
> Hi,
> - copy list of authors into spreadsheet into column A
> - type formula =FIND(",";A1;1) into B1
> - type formula =LEFT(A1;B1-1)&MID(A1;B1;3)&"." into C1
> 
> - copy&paste B1 and C1 into remaining rows
> - copy&paste column C into your document
> 
> Regards, Jiri
> 
> 
> Dne 12.7.2011 10:48, Dietrich Bollmann napsal(a):
> > 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

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

[T. R. Valentine]

I can understand why software companies expand software products to do
more and more things (to justify new versions, to convince chumps to
'upgrade', and to push other software companies out of the picture),
but I do not understand those who buy into such a process with its
accompanying bloat.

I want to choose the product which is best for my needs in each area
where I have a need for an application. If, for instance, I use
web-based e-mail, I have no need for an office suite which includes an
e-mail function and I neither want to spend the money nor waste hard
drive space for such a 'feature'.

The worst expansions-into-bloat are what used to be anti-virus
products which now try to be firewalls, anti-spam,
anti-whatever-you-might-not-want, etc. But Microsoft Office isn't all
that far behind. I'm actually surprised they haven't rolled Visio into
the suite. (Or have they and I didn't notice?)


-- 
T. R. Valentine
Your friends will argue with you. Your enemies don't care.
'When I get a little money I buy books; and if any is left I buy food
and clothes.' -- Erasmus

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

[David B Teague sr]

On 7/13/2011 11:20 AM, T. R. Valentine wrote:

I can understand why software companies expand software products to do
more and more things (to justify new versions, to convince chumps to
'upgrade', and to push other software companies out of the picture),
but I do not understand those who buy into such a process with its
accompanying bloat.

I want to choose the product which is best for my needs in each area
where I have a need for an application. If, for instance, I use
web-based e-mail, I have no need for an office suite which includes an
e-mail function and I neither want to spend the money nor waste hard
drive space for such a 'feature'.

The worst expansions-into-bloat are what used to be anti-virus
products which now try to be firewalls, anti-spam,
anti-whatever-you-might-not-want, etc. But Microsoft Office isn't all
that far behind. I'm actually surprised they haven't rolled Visio into
the suite. (Or have they and I didn't notice?)


I understand not wanting to install features you don't use. Similarly, I 
would like have in LO/OO.o is the ability to install just the parts I 
actually use, and to have this save disk space. Our of 1 or 2 TB 200 MB 
isn't a whole lot. But a 100 MB here and a 100 MB there, pretty soon, 
adds up to a lot of space, to paraphrase Tip O'neal.


David Teague
In 1980, we paid $5000 for a 5 MB hard disk, shared among 15 Apple II+ 
computers.


--
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] Save odt/ods files take too much time

[Tom Davies]

Hi :)
Here is a guide to posting a bug-report
http://wiki.documentfoundation.org/BugReport
It might help you work out if it is a bug or not.  Sorry, hopefully it's more 
helpful than i am!  If in doubt it's probably better to file a bug-report and 
let the triagers decide how to treat it.
Good luck, thanks and regards from
Tom :)





From: MichaelB 
To: users@global.libreoffice.org
Sent: Tue, 12 July, 2011 14:58:28
Subject: [libreoffice-users] Save odt/ods files take too much time

Hi,

When i save (Ctrl+S) a file after some modification, it take 5 seconds or
more with a .odt file (~2.5 Mo)
If i save the same presention with .ppt format, it take only 1.5 seconds to
save.

Is only a little presentation file with 25 slides..  I tested it on Windows
and Linux with LibreOffice 3.4.1 and is the same.
Is in a company context and is really too slow..

It is normal ? it is a possible bug ?

Thanks in advance,
Michael

--
View this message in context: 
http://nabble.documentfoundation.org/Save-odt-ods-files-take-too-much-time-tp3162499p3162499.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
-- 
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: Feature request: native BibTeX support

[Tom Davies]

Hi :)
Base is often quite quirky and has different quirks in different releases with 
confusions and regressions too!  It's not got any devs actively working on it 
right now but hopefully some people will start taking up the challenge and gain 
a lot of respect by moving into this very difficult area!  That said, most of 
Base works fine and it's great where it does work.  

Regards from
Tom :)




From: Zak McKracken 
To: users@global.libreoffice.org
Sent: Tue, 12 July, 2011 21:44:43
Subject: [libreoffice-users] Re: Re: Feature request: native BibTeX support

Am 12.07.2011, 01:17 Uhr, schrieb planas :
> An alternative is to use Base. I have been thinking on these lines so I
> will look into it more.

I am using base for my literature database, but it has serious drawbacks. You 
can use the built-in LO literature database (which isn't portable), or you can 
set up a new one, which will let you include stuff you think is useful but not 
conetained in the original. You can register that as a data source and start 
using it, but as soon as you want to edit any entry from within writer, it will 
tell you that it can't associate the db entries with the properties the 
literature module expects. So what I did was copy the existing db, add a few 
more fields and work with that, but I still had to re-asiciate all the db 
categories anew. And even though I stored it in the same directory as the 
document I used it for, if I copy that directory elswehere, the game starts 
anew.
If I change one of the entries in the db, I have to remove the citation from 
the 
document and re-insert it before it updates in the literature index. If you 
have 
cited it multiple times and you misclick once, be prepared for additional fun.

Ok, so aside from ranting about stuff I haven't done myself and should be 
thankful for instead of criticizing:
What should be doable (I speculate) is to construct something that will import 
bibtex into the OO-database, maybe even link the database to a bitex file (or 
several)? So if you change your bibtex file, the db will update, including 
establishing new categories, properties and the like.
What should also be done is improve the literature workflow. There is certainly 
something to improve there.

I do not use a plugin for citations because I prefer to have all done within 
one 
program (actually If I restarted my current project right now, I'd probably use 
a plugin, but now most of the stuff is in LO's database, and I won't undo 
that), 
and would welcome not having to copy/paste bibtex entries into the literature 
DB 
by hand. I'll also welcome any improvement of LO's bibliography module.


Zak


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

[Roland Hughes]

The pathetic draw tool MS had before purchasing another company was
actually part of office for a while.  Now it usually only comes bundled
with Corporate and super professional versions.  They found people would
pay for a drawing program.

KOffice includes a pretty good drawing program bundled as well...much
better than Visio.


On Wed, 2011-07-13 at 10:20 -0500, T. R. Valentine wrote:

> I can understand why software companies expand software products to do
> more and more things (to justify new versions, to convince chumps to
> 'upgrade', and to push other software companies out of the picture),
> but I do not understand those who buy into such a process with its
> accompanying bloat.
> 
> I want to choose the product which is best for my needs in each area
> where I have a need for an application. If, for instance, I use
> web-based e-mail, I have no need for an office suite which includes an
> e-mail function and I neither want to spend the money nor waste hard
> drive space for such a 'feature'.
> 
> The worst expansions-into-bloat are what used to be anti-virus
> products which now try to be firewalls, anti-spam,
> anti-whatever-you-might-not-want, etc. But Microsoft Office isn't all
> that far behind. I'm actually surprised they haven't rolled Visio into
> the suite. (Or have they and I didn't notice?)
> 
> 
> -- 
> T. R. Valentine
> Your friends will argue with you. Your enemies don't care.
> 'When I get a little money I buy books; and if any is left I buy food
> and clothes.' -- Erasmus
> 


-- 
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] Error in Calc logical functions

[Dennis E. Hamilton]

+1

-Original Message-
From: Regina Henschel [mailto:rb.hensc...@t-online.de] 
Sent: Wednesday, July 13, 2011 06:14
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Error in Calc logical functions

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.

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

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

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

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

>
> I cannot see any case where the reverse would be of practical use, if a
> box is expecting a number and you enter in a letter then "nothing"
> should be the result - In which case its a bug - unless - you know better?

If you want a cell to only expect a number, you have to set up the cell 
accordingly before entering something, otherwise a cell expects all input.

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


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

[Johnny Rosenberg]

2011/7/13 Tom Davies :
> Hi :)
> Keyboard short-cuts sometimes work when menus don't
> Ctrl C = copy
> Ctrl X = cut (X looks a little like a pair of scissors)
> Ctrl V = Paste
> Ctrl Shift V = sometimes pastes 'without formatting' (doesn't work in my
> web-based email program)
✁

Sorry for this being very off topic, but why does most people write
Ctrl C, Ctrl V and so on? Shouldn't it rather be Ctrl c, Ctrl v?
Ctrl C should be the same thing as Ctrl Shift c, shouldn't it? Since C
is the same as Shift c, I mean (unless you didn't create your own very
suspect keyboard layout, of course… like I did, but not THAT suspect…
☺

I would even prefer writing like Ctrl+c, since the ”+” indicates that
”Ctrl” should not be released before the ”c” is hit. That way this
syntax for the Compose key makes sense: Compose o c ⇨ © (press the
compose key, release it, press o, release it, press c, release it ⇨ a
© appears at the cursor's position).

Once again, sorry for being off topic here, I just couldn't stop myself… ☺


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
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] [Calc] Create and export chart

[Thorsten Kampe]

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


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

[Tom Davies]

Hi :)
+1
Lol, i totally agree.  I just never thought about it.  I did notice someone 
taking extravagant care in a very precise guide ages ago.  Hmm Ctrl+c would be 
Ctrl and the + key and the c?  I got told off for using the +  one time.  I 
have 
even been told off for using the space too but it's too confusing for a higher 
percentage of people if they saw Ctrlc in a guide.  There is an old 'joke' 
about 
spending hours looking for the "Any" key.  I think Ctrl+c is fine unless you 
bump into my old, very fussy and ex boss.
Regards from
Tom :)






From: Johnny Rosenberg 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 18:01:43
Subject: Re: [libreoffice-users] How to abbreviate the first name of the author?

2011/7/13 Tom Davies :
> Hi :)
> Keyboard short-cuts sometimes work when menus don't
> Ctrl C = copy
> Ctrl X = cut (X looks a little like a pair of scissors)
> Ctrl V = Paste
> Ctrl Shift V = sometimes pastes 'without formatting' (doesn't work in my
> web-based email program)
✁

Sorry for this being very off topic, but why does most people write
Ctrl C, Ctrl V and so on? Shouldn't it rather be Ctrl c, Ctrl v?
Ctrl C should be the same thing as Ctrl Shift c, shouldn't it? Since C
is the same as Shift c, I mean (unless you didn't create your own very
suspect keyboard layout, of course… like I did, but not THAT suspect…
☺

I would even prefer writing like Ctrl+c, since the ”+” indicates that
”Ctrl” should not be released before the ”c” is hit. That way this
syntax for the Compose key makes sense: Compose o c ⇨ © (press the
compose key, release it, press o, release it, press c, release it ⇨ a
© appears at the cursor's position).

Once again, sorry for being off topic here, I just couldn't stop myself… ☺


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
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] My Tools, Options, Security menu doesn't exist?!?

[floridabrits]

Hello

I am hoping someone can help me here. Thanks in advance!

I have installed LibreOffice on my Mac and am opening a spreadsheet that has
macro's in it. I get a warning that says macros contain viruses and I don't
have macros enable and so I need to go to  "Tools - Options - LibreOffice -
Security" to enable it...

I also googled this message and found this page:
http://help.libreoffice.org/3.3/Common/Security

However, I don't have the "Tools - Options - LibreOffice - Security" menu
navigation :-(

Anyone have any idea how I enable macro's as suggested in the above URL when
I don't have this menu navigation or am I just looking in the wrong place...
I've navigated the menu system and cannot find anything in the "Tools -
Macros" menu that helps me either.

Thanks for any help or guidance...



--
View this message in context: 
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-exist-tp3166597p3166597.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

[Tom Davies]

Hi :)
This sort of summary report is usually easier in a proper database program such 
as Base.  Coincidentally Base can read Calc/Excel files so you wouldn't have to 
"transfer" any data, just use what you have.

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. 
 
You could even create those 2 sheets in another file that just referenced the 
original although that tends to get messy as it asks for permission to update 
"links" to the original and complains if it can't find the file.  I'm not sure 
how to create charts in Base.  


The bit i would be really stuck over is exporting that as a png or any other 
image format.  Perhaps Draw might help?  I have never used Draw so i don't know 
what it can do.  The chart in Calc would be constantly updated.  If any new 
data 
was entered into the other sheets the chart would reflect that.
Regards from
Tom :)






From: Thorsten Kampe 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 18:18:38
Subject: [libreoffice-users] [Calc] Create and export chart

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


-- 
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] [Calc] Create and export chart

[Thorsten Kampe]

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


-- 
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] My Tools, Options, Security menu doesn't exist?!?

[Tom Davies]

Hi :)
I don't understand Macros but Chapter 13 here
http://www.libreoffice.org/get-help/documentation/
might help.  Which file-format is the file in?  Is it an .xls or .xlsX (from MS 
Excel) or is it an .ods?  MS do their macros slightly differently so it can 
take 
a bit of lkuck gettign them to work sometimes.  There are compatibility 
switches 
on
Tools - Options
but i'm not sure if they really help with macros.

Hopefully someone might be able to give a better answer later!  Apols for this 
one.
Good luck and regards from
Tom :)




From: floridabrits 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 17:27:19
Subject: [libreoffice-users] My Tools, Options, Security menu doesn't exist?!?

Hello

I am hoping someone can help me here. Thanks in advance!

I have installed LibreOffice on my Mac and am opening a spreadsheet that has
macro's in it. I get a warning that says macros contain viruses and I don't
have macros enable and so I need to go to  "Tools - Options - LibreOffice -
Security" to enable it...

I also googled this message and found this page:
http://help.libreoffice.org/3.3/Common/Security

However, I don't have the "Tools - Options - LibreOffice - Security" menu
navigation :-(

Anyone have any idea how I enable macro's as suggested in the above URL when
I don't have this menu navigation or am I just looking in the wrong place...
I've navigated the menu system and cannot find anything in the "Tools -
Macros" menu that helps me either.

Thanks for any help or guidance...



--
View this message in context: 
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-exist-tp3166597p3166597.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
-- 
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

[Thorsten Kampe]

* 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


-- 
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: Conditional formatting cell copying?

[Hylton Conacher (ZR1HPC)]

Hi Dave,

Thanks for the answer, and sorry for the belated reply, however it
doesn't work using LibreOffice 3.3.1
OOO330m19 (Build:8)
tag libreoffice-3.3.1.2 On OpenSuse 11.0

You are quite correct that the conditional formulae are copied too,
however the formulae still refer to the same cell references given in
the copied cell.

In other words if you copied cell C3 and pasted special on C4:c10, the
conditional formatting would be copied but the cell references in cell
C10 for the conditional formatting would point to the same cell as those
referenced in cell C3.

Please confirm if this is the case.

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

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

[Tom Davies]

Hi :)
You probably can do it all in one sheet but 2 would probably be easier to 
trouble-shoot later if you ran into problems.  

What type of chart are you hoping to end-up with?  Do you want a single line 
representing the entire year or do you want to compare months against each 
other?  


For the latter option my way would be fairly clumsy.  On the calculations sheet 
the A column would give the dates from Jan & B the data from Jan.  C & D would 
be Feb.  E & F would be March.  I would set-up the first row and then drag the 
equations down as far as required. In A an equation such as 

=Sheet1.A1

unless you have renamed Sheets to the name of the month in which case something 
like
=Jan.A1
drag this to copy into B.  C would need a new equation
=Sheet2.A1
Now if you select those 3 cells you can probably drag-fill all the remaining 
columns, then drag-fill down.  


Hmm, you probably want a graph showing the whole year in a line?  I would be 
fairly clumsy with that too tbh.  Someone is likely to have a much better 
answer 
in a few hours but it would help to know what you are aiming for.  

Regards from
Tom :)






From: Thorsten Kampe 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 19:09:50
Subject: [libreoffice-users] Re: [Calc] Create and export chart

* 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


-- 
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] How to abbreviate the first name of the author?

[Johnny Rosenberg]

2011/7/13 Tom Davies :
> Hi :)
> +1
> Lol, i totally agree.  I just never thought about it.  I did notice someone
> taking extravagant care in a very precise guide ages ago.  Hmm Ctrl+c would be
> Ctrl and the + key and the c?  I got told off for using the +  one time.  I 
> have
> even been told off for using the space too but it's too confusing for a higher
> percentage of people if they saw Ctrlc in a guide.  There is an old 'joke' 
> about
> spending hours looking for the "Any" key.  I think Ctrl+c is fine unless you
> bump into my old, very fussy and ex boss.
> Regards from
> Tom :)

Well, if the rules for key combinations are what I tried to insinuate,
Ctrl+c does not mean ”hit Ctrl, then hit + and then hit c”. Ctrl + c
would.
Remember?
Compose o c ⇨ ©
I didn't type Compose oc or Composeoc…

I am not saying that I am absolutely right here, but I think this is a
good syntax: Use a space to separate key pressings, use a ”+” if
several keys must be pressed at the same time (like AltGr+Shift+f or
whatever). I have seen some people using a ”-” instead, which is okay
for me, but I think the ”+” better describes what's going on. Well,
that's my opinion anyway.

Well, enough about this, I guess. Sorry for continuing being off topic… ☺


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
>
>
>
> 
> From: Johnny Rosenberg 
> To: users@global.libreoffice.org
> Sent: Wed, 13 July, 2011 18:01:43
> Subject: Re: [libreoffice-users] How to abbreviate the first name of the 
> author?
>
> 2011/7/13 Tom Davies :
>> Hi :)
>> Keyboard short-cuts sometimes work when menus don't
>> Ctrl C = copy
>> Ctrl X = cut (X looks a little like a pair of scissors)
>> Ctrl V = Paste
>> Ctrl Shift V = sometimes pastes 'without formatting' (doesn't work in my
>> web-based email program)
> ✁
>
> Sorry for this being very off topic, but why does most people write
> Ctrl C, Ctrl V and so on? Shouldn't it rather be Ctrl c, Ctrl v?
> Ctrl C should be the same thing as Ctrl Shift c, shouldn't it? Since C
> is the same as Shift c, I mean (unless you didn't create your own very
> suspect keyboard layout, of course… like I did, but not THAT suspect…
> ☺
>
> I would even prefer writing like Ctrl+c, since the ”+” indicates that
> ”Ctrl” should not be released before the ”c” is hit. That way this
> syntax for the Compose key makes sense: Compose o c ⇨ © (press the
> compose key, release it, press o, release it, press c, release it ⇨ a
> © appears at the cursor's position).
>
> Once again, sorry for being off topic here, I just couldn't stop myself… ☺
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
> --
> 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
>

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

[Johnny Rosenberg]

2011/7/13 Johnny Rosenberg :
> 2011/7/13 Tom Davies :
>> Hi :)
>> +1
>> Lol, i totally agree.  I just never thought about it.  I did notice someone
>> taking extravagant care in a very precise guide ages ago.  Hmm Ctrl+c would 
>> be
>> Ctrl and the + key and the c?  I got told off for using the +  one time.  I 
>> have
>> even been told off for using the space too but it's too confusing for a 
>> higher
>> percentage of people if they saw Ctrlc in a guide.  There is an old 'joke' 
>> about
>> spending hours looking for the "Any" key.  I think Ctrl+c is fine unless you
>> bump into my old, very fussy and ex boss.
>> Regards from
>> Tom :)
>
> Well, if the rules for key combinations are what I tried to insinuate,
> Ctrl+c does not mean ”hit Ctrl, then hit + and then hit c”. Ctrl + c
> would.
> Remember?
> Compose o c ⇨ ©
> I didn't type Compose oc or Composeoc…
>
> I am not saying that I am absolutely right here, but I think this is a
> good syntax: Use a space to separate key pressings, use a ”+” if
> several keys must be pressed at the same time (like AltGr+Shift+f or
> whatever). I have seen some people using a ”-” instead, which is okay
> for me, but I think the ”+” better describes what's going on. Well,
> that's my opinion anyway.
>
> Well, enough about this, I guess. Sorry for continuing being off topic… ☺

Just one tiny little thing… let's not forget the Emacs way of doing
it: C-x C-c, M-x command and so on… With ”my” syntax the first one
would be Ctrl+x Ctrl+c, which takes up more space and takes longer to
type unless you don't use AutoKey or similar for text expansion (which
I do…).


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
>>
>>
>>
>>
>> 
>> From: Johnny Rosenberg 
>> To: users@global.libreoffice.org
>> Sent: Wed, 13 July, 2011 18:01:43
>> Subject: Re: [libreoffice-users] How to abbreviate the first name of the 
>> author?
>>
>> 2011/7/13 Tom Davies :
>>> Hi :)
>>> Keyboard short-cuts sometimes work when menus don't
>>> Ctrl C = copy
>>> Ctrl X = cut (X looks a little like a pair of scissors)
>>> Ctrl V = Paste
>>> Ctrl Shift V = sometimes pastes 'without formatting' (doesn't work in my
>>> web-based email program)
>> ✁
>>
>> Sorry for this being very off topic, but why does most people write
>> Ctrl C, Ctrl V and so on? Shouldn't it rather be Ctrl c, Ctrl v?
>> Ctrl C should be the same thing as Ctrl Shift c, shouldn't it? Since C
>> is the same as Shift c, I mean (unless you didn't create your own very
>> suspect keyboard layout, of course… like I did, but not THAT suspect…
>> ☺
>>
>> I would even prefer writing like Ctrl+c, since the ”+” indicates that
>> ”Ctrl” should not be released before the ”c” is hit. That way this
>> syntax for the Compose key makes sense: Compose o c ⇨ © (press the
>> compose key, release it, press o, release it, press c, release it ⇨ a
>> © appears at the cursor's position).
>>
>> Once again, sorry for being off topic here, I just couldn't stop myself… ☺
>>
>>
>> Kind regards
>>
>> Johnny Rosenberg
>> ジョニー・ローゼンバーグ
>>
>> --
>> 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
>>
>

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

[Tom Davies]

Hi :)
You are right.  Some people have a different view which is not entirely wrong.  
I think there are various agreed standards and your way fits at least one of 
them.
Regards from
Tom :)




From: Johnny Rosenberg 
To: users@global.libreoffice.org
Sent: Wed, 13 July, 2011 20:16:28
Subject: Re: [libreoffice-users] How to abbreviate the first name of the author?

2011/7/13 Tom Davies :
> Hi :)
> +1
> Lol, i totally agree.  I just never thought about it.  I did notice someone
> taking extravagant care in a very precise guide ages ago.  Hmm Ctrl+c would be
> Ctrl and the + key and the c?  I got told off for using the +  one time.  I 
>have
> even been told off for using the space too but it's too confusing for a higher
> percentage of people if they saw Ctrlc in a guide.  There is an old 'joke' 
>about
> spending hours looking for the "Any" key.  I think Ctrl+c is fine unless you
> bump into my old, very fussy and ex boss.
> Regards from
> Tom :)

Well, if the rules for key combinations are what I tried to insinuate,
Ctrl+c does not mean ”hit Ctrl, then hit + and then hit c”. Ctrl + c
would.
Remember?
Compose o c ⇨ ©
I didn't type Compose oc or Composeoc…

I am not saying that I am absolutely right here, but I think this is a
good syntax: Use a space to separate key pressings, use a ”+” if
several keys must be pressed at the same time (like AltGr+Shift+f or
whatever). I have seen some people using a ”-” instead, which is okay
for me, but I think the ”+” better describes what's going on. Well,
that's my opinion anyway.

Well, enough about this, I guess. Sorry for continuing being off topic… ☺


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

>
>
>
>
> 
> From: Johnny Rosenberg 
> To: users@global.libreoffice.org
> Sent: Wed, 13 July, 2011 18:01:43
> Subject: Re: [libreoffice-users] How to abbreviate the first name of the 
>author?
>
> 2011/7/13 Tom Davies :
>> Hi :)
>> Keyboard short-cuts sometimes work when menus don't
>> Ctrl C = copy
>> Ctrl X = cut (X looks a little like a pair of scissors)
>> Ctrl V = Paste
>> Ctrl Shift V = sometimes pastes 'without formatting' (doesn't work in my
>> web-based email program)
> ✁
>
> Sorry for this being very off topic, but why does most people write
> Ctrl C, Ctrl V and so on? Shouldn't it rather be Ctrl c, Ctrl v?
> Ctrl C should be the same thing as Ctrl Shift c, shouldn't it? Since C
> is the same as Shift c, I mean (unless you didn't create your own very
> suspect keyboard layout, of course… like I did, but not THAT suspect…
> ☺
>
> I would even prefer writing like Ctrl+c, since the ”+” indicates that
> ”Ctrl” should not be released before the ”c” is hit. That way this
> syntax for the Compose key makes sense: Compose o c ⇨ © (press the
> compose key, release it, press o, release it, press c, release it ⇨ a
> © appears at the cursor's position).
>
> Once again, sorry for being off topic here, I just couldn't stop myself… ☺
>
>
> Kind regards
>
> Johnny Rosenberg
> ジョニー・ローゼンバーグ
>
> --
> 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
>

-- 
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: Conditional formatting cell copying?

[Gérard Fargeot]

Hylton Conacher (ZR1HPC) wrote:
> 
> 
> In other words if you copied cell C3 and pasted special on C4:c10, the
> conditional formatting would be copied but the cell references in cell
> C10 for the conditional formatting would point to the same cell as those
> referenced in cell C3.
> 

Formulae in Format > Conditional formatting used the same rules as Formulae
in a cell.

Used Absolute, Relative, or Mixed adressing. ($A$1,A1,$A1,A$1)

Gérard


--
View this message in context: 
http://nabble.documentfoundation.org/Conditional-formatting-cell-copying-tp3163653p3167109.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] Re: Conditional formatting cell copying?

[Johnny Rosenberg]

2011/7/13 Hylton Conacher (ZR1HPC) :
> Hi Dave,
>
> Thanks for the answer, and sorry for the belated reply, however it
> doesn't work using LibreOffice 3.3.1
> OOO330m19 (Build:8)
> tag libreoffice-3.3.1.2 On OpenSuse 11.0
>
> You are quite correct that the conditional formulae are copied too,
> however the formulae still refer to the same cell references given in
> the copied cell.
>
> In other words if you copied cell C3 and pasted special on C4:c10, the
> conditional formatting would be copied but the cell references in cell
> C10 for the conditional formatting would point to the same cell as those
> referenced in cell C3.

Remember that the $ works the same way in conditional formatting like
it does in cell formulas, for example $A$1. This reference won't
change when copying the cell, A1 would.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


>
> Please confirm if this is the case.
>
> 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
>
>

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

[Regina Henschel]

Hi Thorsten,

Thorsten Kampe schrieb:

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


First create a chart from only one sheet. Set the chart in edit mode and 
then from the context or Format menu use item 'Date Ranges'. Goto tab 
'Data Series' and add the data series of the other sheets one by one. 
Because your series start not in the same cell address, you cannot use 
the simplified data range on tab 'Data Range'.
Select the ranges including empty cells, as large as they might become. 
In the data series property you can determine how empty cells are handled.




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?


For really 'automatically' you will need a macro.

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] Conditional formatting cell copying?

[Regina Henschel]

Hi Hylton,
Hylton Conacher (ZR1HPC) schrieb:

Hi all,

Is there a way to copy a particular cells conditional formatting rules
across a  cell selection either in a row or a column?


Yes. Copy a cell, which has the conditional formatting assigned. Mark 
the target and goto Edit> Paste Special.
Unselect all but 'Format' in the section 'Selection' and mark 'Add' in 
the section 'Operations'.




I have a spreadsheet with three columns of numbers, two of which require
three conditional formatting rules on each and every cell row.


You can use a formula with ISODD(ROW()) and ISEVEN(ROW()) in the 
condition and so use the same condition for each row.




I know how to increase of the cell reference in a cell formula is
possible, but how can the cell values in the cell conditional formulae
also be updated incrementally?


?? Please post an example of such a condition. You might have to use the 
type "Formula is" instead of "Cell value is" in the condition.


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] Re: [Calc] Create and export chart

[Dennis E. Hamilton]

You can see if it is possible to select a cuboid, but that may or may not 
provide what you want.

Also, there is an interesting problem of maintaining the correspondence between 
the column A entries and the column B entries if that is important to you. 

A cuboid is a range that starts on one sheet (say the upper left or the 
left-most column) and ends on the final sheet (say the lower right or the 
right-most column).

This is a provision of OpenFormula in ODF 1.2 but I don't know what the 
implementation is in LibreOffice.

A lot of how this works really depends on what it is you want in the chart - 
then you can figure out how to boil the date from the other sheets down to 
produce the data that is exactly the basis for the chart.

I don't want to speculate farther because it is not clear what can work without 
understanding what you want as the chart data.

 - Dennis

-Original Message-
From: Thorsten Kampe [mailto:thors...@thorstenkampe.de] 
Sent: Wednesday, July 13, 2011 11:10
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: [Calc] Create and export chart

* 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


-- 
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] Re: [Calc] Create and export chart

[Michael D. Setzer II]

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

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

[Dave Griffiths]

floridabrits wrote:

> Hello
> 
> I am hoping someone can help me here. Thanks in advance!
> 
> I have installed LibreOffice on my Mac and am opening a spreadsheet that has
> macro's in it. I get a warning that says macros contain viruses and I don't
> have macros enable and so I need to go to  "Tools - Options - LibreOffice -
> Security" to enable it...
> 
> I also googled this message and found this page:
> http://help.libreoffice.org/3.3/Common/Security
> 
> However, I don't have the "Tools - Options - LibreOffice - Security" menu
> navigation :-(
> 
> Anyone have any idea how I enable macro's as suggested in the above URL when
> I don't have this menu navigation or am I just looking in the wrong place...
> I've navigated the menu system and cannot find anything in the "Tools -
> Macros" menu that helps me either.
> 
> Thanks for any help or guidance...
> 
> 
> 
> --
> View this message in context:
> http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-
exist-tp3166597p3166597.html
> Sent from the Users mailing list archive at Nabble.com.

Hi. I believe you should be able to see what you need here: 
Menu - Tools/Options/LibreOffice/Security. On that page you should see a Macro 
Security button which leads to a dialogue where you can trust macros to work 
correctly.

You may also need go to Tools/Options/LibreOffice/General and tick Enable 
experimental (unstable) features as well. 

I am not on a MAC, but this may help, I hope :-)

best regards

Dave

Using
LibreOffice 3.3.3 
OOO330m19 (Build:301)
tag libreoffice-3.3.3.1
on openSUSE 11.4 64 bit



-- 
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: Has anyone used RapidShare for sharing ISO files?

[Michelle Konzack]

Hello webmaster for Kracked Press Productions,

Am 2011-07-09 14:40:30, hacktest Du folgendes herunter:
> Does anyone have any suggestions on low-cost or free places to share
> these LibreOffice ISO files?

How much traffic do you expect per month?

I have a bunch of VServers and RootServers with a traffic of  more  then
30 TByte available and use only 4-8 of them.   Maybe we can make a deal?

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

Re: [libreoffice-users] Conditional formatting cell copying?

[Hylton Conacher (ZR1HPC)]

Hi Regina,

See my earlier reply to Dave in addition to the below:.

Copying and writing the conditions are not the problem.

Getting the condition to automatically increment is the problem e.g. I
have cell A1 that has the formula to add the contents of cells B1, C1
and D1. Cell A1 also has 3 conditional formulas that relate its value to
cells B1, C1 and D1 and apply certain colour coding to the A1 cell.

The formula is cell A1 is the same until cell a10, with just the
respective cell references changing i.e. on cell A5 the formula would
add cells B5, C5 and D5. What I require is that the conditional
formatting applied to cell A1 also be applied to cell A5 but with the
conditional formulae having been incremented i.e. so that the correct
formatting is shown, as per the conditional formulae for the values on
that row i.e. b5, C5 and D5, when the value in A5 is compared to cells
B5, C5 and D5.

I trust that answers the query.

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] Re: Re: Has anyone used RapidShare for sharing ISO files?

[Michelle Konzack]

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

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

[Thorsten Kampe]

* Dennis E. Hamilton (Wed, 13 Jul 2011 13:04:23 -0700)
> A lot of how this works really depends on what it is you want in the
> chart - then you can figure out how to boil the date from the other
> sheets down to produce the data that is exactly the basis for the
> chart.
> 
> I don't want to speculate farther because it is not clear what can
> work without understanding what you want as the chart data.

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


-- 
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: [Calc] Create and export chart

[Regina Henschel]

Hi Thorsten,

Thorsten Kampe schrieb:

* Dennis E. Hamilton (Wed, 13 Jul 2011 13:04:23 -0700)

A lot of how this works really depends on what it is you want in the
chart - then you can figure out how to boil the date from the other
sheets down to produce the data that is exactly the basis for the
chart.

I don't want to speculate farther because it is not clear what can
work without understanding what you want as the chart data.


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.


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] Conditional formatting cell copying?

[Regina Henschel]

Hi Hylton,

Hylton Conacher (ZR1HPC) schrieb:

Hi Regina,

See my earlier reply to Dave in addition to the below:.

Copying and writing the conditions are not the problem.

Getting the condition to automatically increment is the problem e.g. I
have cell A1 that has the formula to add the contents of cells B1, C1
and D1. Cell A1 also has 3 conditional formulas that relate its value to
cells B1, C1 and D1 and apply certain colour coding to the A1 cell.


Let see, whether I understand you now.
content of A1 is =B1+C1+D1

Desired condition in A1 is for example: make red if B1 negativ, if not 
make yellow if C1 negative, if not make green if D1>10.




The formula is cell A1 is the same until cell a10, with just the
respective cell references changing i.e. on cell A5 the formula would
add cells B5, C5 and D5. What I require is that the conditional
formatting applied to cell A1 also be applied to cell A5 but with the
conditional formulae having been incremented i.e. so that the correct
formatting is shown, as per the conditional formulae for the values on
that row i.e. b5, C5 and D5, when the value in A5 is compared to cells
B5, C5 and D5.


If you use relative addresses in your condition, the condition is 
adapted when copied same as the cell formulas.


Example:
Condition for A1 is
1.condition: "Formula is" =B1<0
2.Condition: "Formula is" =C1<0
3.Condition: "Formula is" =D1>10

When you now copy this condition to A8, you will get for A8 the condition
1.condition: "Formula is" =B8<0
2.Condition: "Formula is" =C8<0
3.Condition: "Formula is" =D8>10

It that, what you are looking for?

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

[libreoffice-users] Re: Re: Conditional formatting cell copying?

[Dave Griffiths]

Hylton Conacher (ZR1HPC) wrote:

> Hi Dave,
> 
> Thanks for the answer, and sorry for the belated reply, however it
> doesn't work using LibreOffice 3.3.1
> OOO330m19 (Build:8)
> tag libreoffice-3.3.1.2 On OpenSuse 11.0
> 
> You are quite correct that the conditional formulae are copied too,
> however the formulae still refer to the same cell references given in
> the copied cell.
> 
> In other words if you copied cell C3 and pasted special on C4:c10, the
> conditional formatting would be copied but the cell references in cell
> C10 for the conditional formatting would point to the same cell as those
> referenced in cell C3.
> 
> Please confirm if this is the case.
> 
> Regards
> Hylton
Hi Hylton

No problem with the belated reply. As mentioned in other replies, the cell 
references can be relative, absolute or mixed so I think what you want is 
achievable.

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

[libreoffice-users] Re: Printing OLE problem

[NoOp]

On 07/12/2011 09:10 AM, Jeremy Morris wrote:
> Hope someone can provide some advice -
> 
> System: Ubuntu 64-bit v11.4, LibreOffice 3.3.3
> 
> I have a .doc file from an MS-Word 2003 source, containing two OLE 
> images. When opening this file I can see the images, but they are not 
> visible in the Print Preview function and do not print with the rest of 
> the document.
> 
> Saving the file as a .odt version makes no difference.
> 
> The GIF files used to create the document header and logos print 
> perfectly, and if I embed a JPG in the file I can see and print it. The 
> problem appears to be only with OLE objects.
> 
> All help gratefully received!
> 

Can you check in Writer: Tools|Options|LibreOffice Writer|Print and see
if 'Pictures and objects' is checked?




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

[floridabrits]

Thanks for the quick response Tom. It is an ODS file...

I just don't understand why I don't have this tools/options menu that is
discussed.

Anyone?

Thanks in advance for your help and suggestions...

/g

--
View this message in context: 
http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-exist-tp3166597p3166878.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] Converting references to non-reference text in LibreOffice Writer: the dumbest possible way?!

[Sandy Miller]

I have LibreOffice documents (written in 3.2/3.3) with extensive field
cross-referencing to numbers of tables, numbered paragraphs, numbered
sections and chapters, etc. Conversion to Word often messes those up
so I wanted to change them all to text. Now, in Word one could just
highlight the whole text, press CTRL+SHIFT+F9, and be done with it. In
LibreOffice, the help says, I have to convert every field into
unformatted text with Paste Special ... Whoever  programmed this has
got to be kidding me? Am I really supposed to go through a document
one field at a time and update every one on its own, plus I have to
figure out the right order because if I do that from the beginning of
the doc, changing one changes the numbering of everything etc. after
it ... Is there srsly no better way? Any pointers or changes in
LibreOffice would be much appreciated!

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

[Dave Griffiths]

floridabrits wrote:

> Thanks for the quick response Tom. It is an ODS file...
> 
> I just don't understand why I don't have this tools/options menu that is
> discussed.
> 
> Anyone?
> 
> Thanks in advance for your help and suggestions...
> 
> /g
> 
> --
> View this message in context:
> http://nabble.documentfoundation.org/My-Tools-Options-Security-menu-doesn-t-
exist-tp3166597p3166878.html
> Sent from the Users mailing list archive at Nabble.com.

Hi again. Perhaps my explanation confused slightly. Go to the Tools menu, then 
select options. This will present the LibreOffice configuration dialogue. 
Expand the LibreOffice heading then you should see both the Security and 
General headings. Select Security and you should see the following dialogue: 

http://dl.dropbox.com/u/21689478/Macro%20Security.png

As stated previously you may also need to select General and tset a tick in 
the Enable experimental (unstable) features as well.

HTH.

Best regards, 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

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

[Larry Gusaas]

On 2011/07/13 12:04 PM  floridabrits wrote:

I just don't understand why I don't have this tools/options menu that is
discussed.

On Macs it is  /Preferences.

Larry
--
_
Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - 
Edgard Varese




--
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: Conditional formatting cell copying?

[jorge]

Hi

You can do it like this:

1) Select two columns and all rows that you need format.
2) Select Menu-Format-Conditional Format
3) Make the format that you need
4) Accept

I know that this conditional format is for all area selected and it
didn't show a special cell formula o condition... It looks transparent.

Regards,

Jorge Rodríguez
___



El mié, 13-07-2011 a las 21:04 +0200, Hylton Conacher (ZR1HPC) escribió:
> Hi Dave,
> 
> Thanks for the answer, and sorry for the belated reply, however it
> doesn't work using LibreOffice 3.3.1
> OOO330m19 (Build:8)
> tag libreoffice-3.3.1.2 On OpenSuse 11.0
> 
> You are quite correct that the conditional formulae are copied too,
> however the formulae still refer to the same cell references given in
> the copied cell.
> 
> In other words if you copied cell C3 and pasted special on C4:c10, the
> conditional formatting would be copied but the cell references in cell
> C10 for the conditional formatting would point to the same cell as those
> referenced in cell C3.
> 
> Please confirm if this is the case.
> 
> 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
> 
> 

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

Re: [libreoffice-users] Feature Request :Evolution

[planas]

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

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

[Simon Cropper (The foss Workflow Guides)]

On 14/07/11 03:13, 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.

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



Thorsten,

This is how I would address this problem

Sheet 1 would include all data (column A & B) for every month.

Sheet 2 will be the monthly summary sheet.

In this sheet we create a stylised month.

Cell A1 and B1 would be a picklist of months or years. Use data > 
validity > Criteria to set up a list or point to a allowable range.


In row A3:AE3 create the numbers 1-31 which represents the day of the month.

Then underneath each day in A4:AE4, use the Vlookup() function to 
extract the data for each day of the month and year selected.


The function would look like this...
=VLOOKUP(DATE($A$1,$B$1,A3),Sheet1.YourRange,2,0)

to get rid of the annoying situation where absent values throw and error 
use the following to capture them


=IF(ISERROR(VLOOKUP(DATE($A$1,$B$1,A3),Sheet1.YourRange,2,0)), "", 
VLOOKUP(DATE($A$1,$B$1,A3),Sheet1.YourRange,2,0))


This will create an idealised month with values populated based on what 
month and year you select.


Create your chart based on this.

In regards to exporting as a PNG, several options exist if you are using 
Windows...


1. use a PDF printer driver that exports to PNG, rather than the inbuild 
export utility like PDFCreator

http://sourceforge.net/projects/pdfcreator/

2. Use an ImageCreating printer driver like ImagePrinter
http://sourceforge.net/projects/imageprinter/

Doing the same in GNU/Linux requires you to install a better PDF Printer 
Driver than allows you to save as an image or post-process the PDF using 
another program.


Once you set this up to work manually create a macro and attach it to a 
button or something.


--
Cheers Simon

   Simon Cropper
   Website Administrator
   http://www.fossworkflowguides.com
   The fossWorkflow Guides
   (c) Simon Cropper CC-BY-SA 3.0 Australia
   http://creativecommons.org/licenses/by-sa/3.0/au/deed.en

--
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: Feature Request :Evolution

[NoOp]

On 07/12/2011 09:46 AM, 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?

Any particular reason why you don't just use Evolution as your mail
client in: Tools|Options|Internet|Email?




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

[webmaster for Kracked Press Productions]

On 07/13/2011 04:22 PM, Michelle Konzack wrote:

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


Well, I used K3b to make my ISO files.
I used ISO 9660 images.
I have tried several archive methods and software for the archive type 
of file goes from 3.4 to 3.6 GB.


Physical Max of the medium?  DVD can be 4.7GB, according to what is 
printed on the package of media.


The DVD has install files, extensions, dictionaries, templates, artwork 
and other extras.  That is a lot of total file size.


go to LibreOffice-NA.US and choose 3.3.3 Windows-Linux-MacOS and see 
what is in the DVD.







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

[jorge]

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

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

[Thorsten Kampe]

* 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].

Thorsten
[1]

[2] 



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