Re: [libreoffice-users] Chart in Calc

[Walter Hildebrandt]

I am using WindowsXP and can do what you did in cells A1, A2, A3, B1, B2,
and B3.  The six cells are highlighted (selected).  The Chart Icon is
clicked.  The Chart appears along with the Wizard.  How do I get rid of the
Wizard without deleting the Chart at the same time?   By deleting the
Wizard it seems to allow you to go on further.  If I keep the wizard I can
not do what you do in the video.

Also, The title of each column appears just below the zero line.  When I
have a negative number in either cell(s) B1, B2, or B3, then the dark blue
column goes below the zero line and covers (hides) the title.

As for the title of the complete chart, I can add that at the top of the
chart by keeping the Wizard and using the Wizard to add the chart title on
a line that is above the highest columns so there is no hiding any part of
that title.


On Mon, Dec 26, 2011 at 2:52 AM, soumalya ray  wrote:

> sorry forgot to attach the link- http://youtu.be/NcYwVHIN2lE?hd=1
> regards,
>
> On 26 December 2011 13:21, soumalya ray  wrote:
>
> > about ur 2nd problem, does this help?
> > regards,
> >
> >
> >
> > Dr soumalya ray   
> MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
> Skype: som3776 | Twitter: @docbkp 
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Basic use of the spreadsheet tools

[RobertHeathfield]

I am fairly new to libre office but it seems very strange to me that there
seems to be little or no help available for simple instructions like how to
use the filters on a spreadsheet. For example when you select the autofilter
for a column why does the filter not filter all instances of a value and
only filter the first one it finds. I guess there must be a setting
somewhere but that doesn't sound very "auto" to me. I obviously need help.


--
View this message in context: 
http://nabble.documentfoundation.org/Basic-use-of-the-spreadsheet-tools-tp3612347p3612347.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: RTF to PDF Command Line

[Luuk]

i like bottom-quoting, so you know where to find my reply ;)

On 24-12-2011 17:10, Tom Davies wrote:
> Hi :)
> Hmm, i tried googling about this and some results suggested you might need to 
> use
> 
> lowriter
> 
> instead of 
> 
> soffice.exe
> or
> libreoffice.exe
> 
> Regards from
> Tom :)
> 
> 
> 
> 
> --- On Sat, 24/12/11, Luuk  wrote:
> 
> From: Luuk 
> Subject: [libreoffice-users] Re: RTF to PDF Command Line
> To: users@global.libreoffice.org
> Date: Saturday, 24 December, 2011, 11:49
> 
> On 24-12-2011 00:57, Miklos Vajna wrote:
>> On Fri, Dec 23, 2011 at 07:16:04PM +0100, Luuk  wrote:
>>> JodConverter is the tool to do it from the command-line
>>> see:
>>> http://code.google.com/p/jodconverter/wiki/GettingStarted
>>
>> Or just do 'libreoffice --headless --convert-to pdf foo.rtf'.
>>
> 
> just tested that (with LO3.3), and it should be:
> libreoffice -headless -convert-to pdf foo.rtf
> 
> 
> 
> 

indeed, in my previous post it said: 'libreoffice', but that should be:
'soffice' (or 'soffice.exe', but this last bit wont work on linux ;) )

Use of 'lowriter' is basiccally the same as 'soffice -writer "$@"'

-- 
Luuk


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Basic use of the spreadsheet tools

[Luuk]

On 26-12-2011 07:08, RobertHeathfield wrote:
> I am fairly new to libre office but it seems very strange to me that there
> seems to be little or no help available for simple instructions like how to
> use the filters on a spreadsheet. For example when you select the autofilter
> for a column why does the filter not filter all instances of a value and
> only filter the first one it finds. I guess there must be a setting
> somewhere but that doesn't sound very "auto" to me. I obviously need help.
> 
> 

Before creating the 'auto' filter, select all columns that are involved,
or (better) select all the cells involved.

After that, your problem should be solved, if not, please put your
example sheet somewhere ;)





-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Basic use of the spreadsheet tools

[Tom]

Hi :)
The best documentation is on this page
http://wiki.documentfoundation.org/Documentation/Publications
and is then copied to this page
http://www.libreoffice.org/get-help/documentation/

The help files are not so great because 2 different teams each thought the
other was responsible for updating them and both teams were short of people,
still are.  
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Basic-use-of-the-spreadsheet-tools-tp3612347p3612576.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.

[Tom]

Hi :)
It sounds a bit buggy to me.  This guide might help
http://wiki.documentfoundation.org/BugReport

Switching styles on you without being asked sounds very wrong to me.
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/LOcalc-SAVE-as-html-gratuitously-changes-HREF-from-relative-to-absolute-tp3611998p3612585.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: RTF to PDF Command Line

[Tom]

Hi Luuk

Thanks for clarifying that.  It makes more sense now.  So the command would
be either

soffice  -writer  --headless  --convert-to  pdf   file-name.rtf'

or 

lowriter  --headless  --convert-to  pdf   file-name.rtf'

or on Windows a 3rd way of trying

soffice.exe  -writer  --headless  --convert-to  pdf   file-name.rtf'

or try the jod converter
http://code.google.com/p/jodconverter/wiki/GettingStarted

Pdf does have advantages.  People are unlikely to mess up a document by
editing it because not many people have software that can edit them.  Also
documents looks the same on pretty much any system and print the same on
pretty much any printer.  

Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/RTF-to-PDF-Command-Line-tp3609044p3612664.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: RTF to PDF Command Line

[Luuk]

On 26-12-2011 13:14, Tom wrote:
> Hi Luuk
> 
> Thanks for clarifying that.  It makes more sense now.  So the command would
> be either
> 
> soffice  -writer  --headless  --convert-to  pdf   file-name.rtf'
> 
> or 
> 
> lowriter  --headless  --convert-to  pdf   file-name.rtf'
> 
> or on Windows a 3rd way of trying
> 
> soffice.exe  -writer  --headless  --convert-to  pdf   file-name.rtf'

soffice   --headless  --convert-to  pdf   file-name.rtf

The option '-writer' is not needed, because an RTF-file will be openend
with writer per-default

Is however 'strange'  that the options on a Windows computer need two
'--'  (i.e. --headless), and on linux just need one '-' (i.e. -headless)

Should this not be more standardized?




-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Basic use of the spreadsheet tools

[Ing. Jiří Hladůvka]

Dne 26.12.2011 11:24, Luuk napsal(a):

On 26-12-2011 07:08, RobertHeathfield wrote:

I am fairly new to libre office but it seems very strange to me that there
seems to be little or no help available for simple instructions like how to
use the filters on a spreadsheet. For example when you select the autofilter
for a column why does the filter not filter all instances of a value and
only filter the first one it finds. I guess there must be a setting
somewhere but that doesn't sound very "auto" to me. I obviously need help.



Before creating the 'auto' filter, select all columns that are involved,
or (better) select all the cells involved.

After that, your problem should be solved, if not, please put your
example sheet somewhere ;)






The best result you get if all columns have some heading such as
"name", "city", ... etc.
Then place the cursor to the leftmost heading and start auto filtering.
Otherwice the values of the row where the cursor is placed are used as 
"column names"


Jiri




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

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


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: RTF to PDF Command Line

[Mirosław Zalewski]

On 26/12/2011 at 14:04, Luuk  wrote:

> Is however 'strange'  that the options on a Windows computer need two
> '--'  (i.e. --headless), and on linux just need one '-' (i.e. -headless)
> 
> Should this not be more standardized?

As far as I remember, options for Windows command-line programs are delimited 
by slash (e.g. del /f some_file).

So, either way, LO behavior is non-standard for Windows apps. But, on the 
other hand, most of Windows users does not use terminal mode - those who do 
perhaps have some experience with Linux shells as well.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Basic use of the spreadsheet tools

[Stefan Weigel]

Hi,

Am 26.12.2011 11:24, schrieb Luuk:

> Before creating the 'auto' filter, select all columns that are involved,
> or (better) select all the cells involved.

I would rather recommend to select one single cell inside the list
of data. Calc will automatically detect the data range.

Stefan


-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Basic use of the spreadsheet tools

[Luuk]

On 26-12-2011 14:37, Stefan Weigel wrote:
> Hi,
> 
> Am 26.12.2011 11:24, schrieb Luuk:
> 
>> Before creating the 'auto' filter, select all columns that are involved,
>> or (better) select all the cells involved.
> 
> I would rather recommend to select one single cell inside the list
> of data. Calc will automatically detect the data range.
> 
> Stefan
> 
> 

But, be aware, that if you add a new line to your data (at the end),
that this line will not be in the range of filtered items.

Thats why i mostly select all columns. this way new data is
'automagically' included in the filter.

-- 
Luuk


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: RTF to PDF Command Line

[Luuk]

On 26-12-2011 14:31, Mirosław Zalewski wrote:
> On 26/12/2011 at 14:04, Luuk  wrote:
> 
>> Is however 'strange'  that the options on a Windows computer need two
>> '--'  (i.e. --headless), and on linux just need one '-' (i.e. -headless)
>>
>> Should this not be more standardized?
> 
> As far as I remember, options for Windows command-line programs are delimited 
> by slash (e.g. del /f some_file).
> 
> So, either way, LO behavior is non-standard for Windows apps. But, on the 
> other hand, most of Windows users does not use terminal mode - those who do 
> perhaps have some experience with Linux shells as well.


You are right, so there are 2 options:
1) Do it the Windows-way, and make LO use the '/' for this stuff.

2) Do it the LO-way, and make sure the parameters are accepted the same
way on every implemented platform.

-- 
Luuk


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Chart in Calc

[soumalya ray]

just click the "finish" button of the wizard.it'll disappear then.

that's why i move the title of the column to the end.otherwise,you could
just change the colour of the font of the title of the column from
"automatic" to something suitable to make it legible.
regards,

On 26 December 2011 14:45, Walter Hildebrandt  wrote:

> *I am using WindowsXP and can do what you did in cells A1, A2, A3, B1, B2,
> and B3.  The six cells are highlighted (selected).  The Chart Icon is
> clicked.  The Chart appears along with the Wizard.  How do I get rid of the
> Wizard without deleting the Chart at the same time?   By deleting the
> Wizard it seems to allow you to go on further.  If I keep the wizard I can
> not do what you do in the video.*
>
> Also, The title of each column appears just below the zero line.  When I
> have a negative number in either cell(s) B1, B2, or B3, then the dark blue
> column goes below the zero line and covers (hides) the title.
>
> As for the title of the complete chart, I can add that at the top of the
> chart by keeping the Wizard and using the Wizard to add the chart title on
> a line that is above the highest columns so there is no hiding any part of
> that title.
>
>
> --
Dr soumalya ray   
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] How to paste a function so Calc doesn't change addresses in it?

[Csányi Pál]

Hi,

I'm working on a spreadsheet and I want to copy/paste a function.

When I copy/paste the function Calc increase some address in the 
functions that I have in the cell and those addresses aren't proper for 
my purpose.


Eg. I want to copy/paste the value of a cell:
=HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))

but when I paste it, I get:
=HA(DARABÜRES('1.'.AD7);"0";HA('1.'.AD7="1";"-";HA("1"<'1.'.AD7<"6";"+";"hamis")))

and that isn't good for me, because I want to get
=HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))

in the new cell;
actually I would like to get:
=HA(DARABÜRES('2.'.AD6);"0";HA('2.'.AD6="1";"-";HA("1"<'2.'.AD6<"6";"+";"hamis")))

but I think that that this can't be achieve with Calc, right?

How can I copy/paste the function so so the addresses in the function 
remain the same as in the original cell?


Best Regards, Pál

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?

[Gérard FARGEOT]

Hi,


> Message du 26/12/11 16:25
> De : "Csányi Pál" 
> A : "Libre Office" 
> Copie à : 
> Objet : [libreoffice-users] How to paste a function so Calc doesn't change 
> addresses in it?
> 
> Hi,
> 
> I'm working on a spreadsheet and I want to copy/paste a function.
> 
> When I copy/paste the function Calc increase some address in the 
> functions that I have in the cell and those addresses aren't proper for 
> my purpose.
> 
> Eg. I want to copy/paste the value of a cell:
> =HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))
> 
> but when I paste it, I get:
> =HA(DARABÜRES('1.'.AD7);"0";HA('1.'.AD7="1";"-";HA("1"<'1.'.AD7<"6";"+";"hamis")))
> 
> and that isn't good for me, because I want to get
> =HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))
> 
> in the new cell;
> actually I would like to get:
> =HA(DARABÜRES('2.'.AD6);"0";HA('2.'.AD6="1";"-";HA("1"<'2.'.AD6<"6";"+";"hamis")))
> 
> but I think that that this can't be achieve with Calc, right?
> 
> How can I copy/paste the function so so the addresses in the function 
> remain the same as in the original cell?
> 
> Best Regards, Pál
> 

Use "absolute cell reference".
Press Shift+F4 will change relative to absolute reference for the active cell.

Your formula 
=HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))
will change in 
=HA(DARABÜRES($'1.'.$AD$6);"0";HA($'1.'.$AD$6="1";"-";HA("1"<$'1.'.$AD$6<"6";"+";"hamis")))

$ before sheet, column or row reference fixed them. They do not increase when 
copied.

Gérard
-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?

[Alan Boba]

2011/12/26 Csányi Pál 

> Hi,
>
> I'm working on a spreadsheet and I want to copy/paste a function.
>
> When I copy/paste the function Calc increase some address in the functions
> that I have in the cell and those addresses aren't proper for my purpose.
>
> Eg. I want to copy/paste the value of a cell:
> =HA(DARABÜRES('1.'.AD6);"0";**HA('1.'.AD6="1";"-";HA("1"<'1.**
> '.AD6<"6";"+";"hamis")))
>
> but when I paste it, I get:
> =HA(DARABÜRES('1.'.AD7);"0";**HA('1.'.AD7="1";"-";HA("1"<'1.**
> '.AD7<"6";"+";"hamis")))
>
> and that isn't good for me, because I want to get
> =HA(DARABÜRES('1.'.AD6);"0";**HA('1.'.AD6="1";"-";HA("1"<'1.**
> '.AD6<"6";"+";"hamis")))
>
> in the new cell;
> actually I would like to get:
> =HA(DARABÜRES('2.'.AD6);"0";**HA('2.'.AD6="1";"-";HA("1"<'2.**
> '.AD6<"6";"+";"hamis")))
>
> but I think that that this can't be achieve with Calc, right?
>
> How can I copy/paste the function so so the addresses in the function
> remain the same as in the original cell?
>
> Best Regards, Pál
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
> org 
> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
> unsubscribe/
> Posting guidelines + more: http://wiki.**documentfoundation.org/**
> Netiquette 
> List archive: 
> http://listarchives.**libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
> Two ways I know of...

1) use a "$" as the part of the address you don't want to change when
copy/pasting. So
=HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))

becomes
=HA(DARABÜRES('1.'.$AD$6);"0";HA('1.'.$AD$6="1";"-";HA("1"<'1.'.$AD$6<"6";"+";"hamis")))

I believe there is a function key that can be used to cycle through
absolute cell addresses when creating a formula, e.g. cycles through AD6,
$AD6, AD$6, $AD$6 as addresses when editing the formula. That avoids the
need to type in the "$"

2) name the cells you wish to stay the same as you copy the function from
cell to cell and use the cell names in the formula.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How to paste a function so ... - THANKS!!

[Csanyi Pal]

Hi Gérard,

thank you very much for your help!

-- 
Regards, Pal


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How to paste a function so ... THANKS!!

[Csanyi Pal]

Hi Alan,

thank you very much for your help!

-- 
Regards, Pal


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?

[Alan Boba]

On Mon, Dec 26, 2011 at 10:46 AM, Alan Boba  wrote:

>
> 2011/12/26 Csányi Pál 
>
>> Hi,
>>
>> I'm working on a spreadsheet and I want to copy/paste a function.
>>
>> When I copy/paste the function Calc increase some address in the
>> functions that I have in the cell and those addresses aren't proper for my
>> purpose.
>>
>> Eg. I want to copy/paste the value of a cell:
>> =HA(DARABÜRES('1.'.AD6);"0";**HA('1.'.AD6="1";"-";HA("1"<'1.**
>> '.AD6<"6";"+";"hamis")))
>>
>> but when I paste it, I get:
>> =HA(DARABÜRES('1.'.AD7);"0";**HA('1.'.AD7="1";"-";HA("1"<'1.**
>> '.AD7<"6";"+";"hamis")))
>>
>> and that isn't good for me, because I want to get
>> =HA(DARABÜRES('1.'.AD6);"0";**HA('1.'.AD6="1";"-";HA("1"<'1.**
>> '.AD6<"6";"+";"hamis")))
>>
>> in the new cell;
>> actually I would like to get:
>> =HA(DARABÜRES('2.'.AD6);"0";**HA('2.'.AD6="1";"-";HA("1"<'2.**
>> '.AD6<"6";"+";"hamis")))
>>
>> but I think that that this can't be achieve with Calc, right?
>>
>> How can I copy/paste the function so so the addresses in the function
>> remain the same as in the original cell?
>>
>> Best Regards, Pál
>>
>> --
>> For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
>> org 
>> Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
>> unsubscribe/
>> Posting guidelines + more: http://wiki.**documentfoundation.org/**
>> Netiquette 
>> List archive: 
>> http://listarchives.**libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>> Two ways I know of...
>
> 1) use a "$" as the part of the address you don't want to change when
> copy/pasting. So
>
> =HA(DARABÜRES('1.'.AD6);"0";HA('1.'.AD6="1";"-";HA("1"<'1.'.AD6<"6";"+";"hamis")))
>
> becomes
>
> =HA(DARABÜRES('1.'.$AD$6);"0";HA('1.'.$AD$6="1";"-";HA("1"<'1.'.$AD$6<"6";"+";"hamis")))
>
> I believe there is a function key that can be used to cycle through
> absolute cell addresses when creating a formula, e.g. cycles through AD6,
> $AD6, AD$6, $AD$6 as addresses when editing the formula. That avoids the
> need to type in the "$"
>
> 2) name the cells you wish to stay the same as you copy the function from
> cell to cell and use the cell names in the formula.
>

...one other thing using the "$" works for the row reference or the column
reference so two "$" are needed, one next to the column value one next to
the row value, to keep both from changing. If you want the column reference
to remain constant but allow the row to change only use "$" in front of the
column letter. If you want the row to remain constant but allow the column
to change only use the "$" in front of the row reference.

constant column when formula is copied $B6. A formula containing this
reference will always us "B" as the column but the row will change if the
formula is copied to a different row.

constant row when formula is copied B$6. A formula containing this
reference will always us "6" as the row but the column will change if the
formula is copied to a different column.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: How to paste a function so Calc doesn't change addresses in it?

[Csanyi Pal]

Alan Boba  writes:

> On Mon, Dec 26, 2011 at 10:46 AM, Alan Boba  wrote:

>> 2011/12/26 Csányi Pál 

> constant column when formula is copied $B6. A formula containing this
> reference will always us "B" as the column but the row will change if the
> formula is copied to a different row.

It works for the next raw, but how can I use this behavior when I want to
copy to a different column?

When I'm trying to copy to the next column:
=HA(DARABÜRES('5.'.$AD6);"0";HA('5.'.$AD6="1";"-";HA("1"<'5.'.$AD6<"6";"+";"hamis")))

It remains like this:
=HA(DARABÜRES('5.'.$AD6);"0";HA('5.'.$AD6="1";"-";HA("1"<'5.'.$AD6<"6";"+";"hamis")))

and the address $AD6 doesn't changed to $AD7, why?

-- 
Regards, Pal


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Chart in Calc

[Walter Hildebrandt]

It seems you know what is going on with charts.  The official documentation
has a lot left out.  You send a link that had the video of what to do.  I
did not save that link and it seems to be deleted from the Emails.  Please
send me that video link again.  Thank you.
By the way I am the person who originally started the website
TutorialsforOpenOffice.org.  We learned a lot on how to write tutorials in
a way that works for many users of OOo or TOo.  Do you know anyone who is
interested in discussing this?

On Mon, Dec 26, 2011 at 9:17 AM, soumalya ray  wrote:

> just click the "finish" button of the wizard.it'll disappear then.
>
> that's why i move the title of the column to the end.otherwise,you could
> just change the colour of the font of the title of the column from
> "automatic" to something suitable to make it legible.
> regards,
>
> On 26 December 2011 14:45, Walter Hildebrandt  wrote:
>
> > *I am using WindowsXP and can do what you did in cells A1, A2, A3, B1,
> B2,
> > and B3.  The six cells are highlighted (selected).  The Chart Icon is
> > clicked.  The Chart appears along with the Wizard.  How do I get rid of
> the
> > Wizard without deleting the Chart at the same time?   By deleting the
> > Wizard it seems to allow you to go on further.  If I keep the wizard I
> can
> > not do what you do in the video.*
> >
> > Also, The title of each column appears just below the zero line.  When I
> > have a negative number in either cell(s) B1, B2, or B3, then the dark
> blue
> > column goes below the zero line and covers (hides) the title.
> >
> > As for the title of the complete chart, I can add that at the top of the
> > chart by keeping the Wizard and using the Wizard to add the chart title
> on
> > a line that is above the highest columns so there is no hiding any part
> of
> > that title.
> >
> >
> > --
> Dr soumalya ray   
> MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
> Skype: som3776 | Twitter: @docbkp 
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Chart in Calc

[Tom]

Hi :)
You can always view the emails through Nabble.  Navigate to the right thread
or click the click in this post.  Errr, actually here is the link to the
video again 
http://youtu.be/NcYwVHIN2lE?hd=1

The documentation team might be interested in joining in with the video work
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Chart-in-Calc-tp3606746p3613044.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Basic use of the spreadsheet tools

[NoOp]

On 12/25/2011 10:08 PM, RobertHeathfield wrote:
> I am fairly new to libre office but it seems very strange to me that there
> seems to be little or no help available for simple instructions like how to
> use the filters on a spreadsheet. For example when you select the autofilter
> for a column why does the filter not filter all instances of a value and
> only filter the first one it finds. I guess there must be a setting
> somewhere but that doesn't sound very "auto" to me. I obviously need help.

F1 or Help|LibreOffice Help|'filter' in the search box|filtering;cell
ranges/database ranges:

Filtering Cell Ranges
You can use several filters to filter cell ranges in spreadsheets. A
standard filter uses the options that you specify to filter the data. An
AutoFilter filters data according to a specific value or string. An
advanced filter uses filter criteria from specified cells.
To Apply a Standard Filter to a Cell Range
1. Click in a cell range.
2. Choose Data - Filter - Standard Filter.
3. In the Standard Filter dialog, specify the filter options that you want.
4. Click OK.
The records that match the filter options that you specified are shown.
To Apply an AutoFilter to a Cell Range
1. Click in a cell range or a database range.

If you want to apply multiple AutoFilters to the same sheet, you must
first define database ranges, then apply the AutoFilters to the database
ranges.

2. Choose Data - Filter - AutoFilter.
An arrow button is added to the head of each column in the database range.
3. Click the arrow button in the column that contains the value or
string that you want to set as the filter criteria.
4. Select the value or string that you want to use as the filter criteria.
The records that match the filter criteria that you selected are shown.
To Remove a Filter From a Cell Range
1. Click in a filtered cell range.
2. Choose Data - Filter - Remove Filter.

You can also search for 'AutoFilter' and find instructions there
(applying/subtotals).

Also please see:
http://www.libreoffice.org/get-help/
click on Documentation:
Getting Started with LibreOffice
  Chapter 5 - Getting Started with Calc (ODT) (PDF)
   Page 34: Filtering which cells are visible
LibreOffice Calc Guide
  Chapter 13 - Calc as a Simple Database
   Page 313-320: Filters


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Basic use of the spreadsheet tools

[Paul Rosenstock]

Remove me from the distribution list!

On Mon, Dec 26, 2011 at 2:47 PM, NoOp  wrote:

> On 12/25/2011 10:08 PM, RobertHeathfield wrote:
> > I am fairly new to libre office but it seems very strange to me that
> there
> > seems to be little or no help available for simple instructions like how
> to
> > use the filters on a spreadsheet. For example when you select the
> autofilter
> > for a column why does the filter not filter all instances of a value and
> > only filter the first one it finds. I guess there must be a setting
> > somewhere but that doesn't sound very "auto" to me. I obviously need
> help.
>
> F1 or Help|LibreOffice Help|'filter' in the search box|filtering;cell
> ranges/database ranges:
>
> Filtering Cell Ranges
> You can use several filters to filter cell ranges in spreadsheets. A
> standard filter uses the options that you specify to filter the data. An
> AutoFilter filters data according to a specific value or string. An
> advanced filter uses filter criteria from specified cells.
> To Apply a Standard Filter to a Cell Range
> 1. Click in a cell range.
> 2. Choose Data - Filter - Standard Filter.
> 3. In the Standard Filter dialog, specify the filter options that you want.
> 4. Click OK.
> The records that match the filter options that you specified are shown.
> To Apply an AutoFilter to a Cell Range
> 1. Click in a cell range or a database range.
>
> If you want to apply multiple AutoFilters to the same sheet, you must
> first define database ranges, then apply the AutoFilters to the database
> ranges.
>
> 2. Choose Data - Filter - AutoFilter.
> An arrow button is added to the head of each column in the database range.
> 3. Click the arrow button in the column that contains the value or
> string that you want to set as the filter criteria.
> 4. Select the value or string that you want to use as the filter criteria.
> The records that match the filter criteria that you selected are shown.
> To Remove a Filter From a Cell Range
> 1. Click in a filtered cell range.
> 2. Choose Data - Filter - Remove Filter.
>
> You can also search for 'AutoFilter' and find instructions there
> (applying/subtotals).
>
> Also please see:
> http://www.libreoffice.org/get-help/
> click on Documentation:
> Getting Started with LibreOffice
>  Chapter 5 - Getting Started with Calc (ODT) (PDF)
>   Page 34: Filtering which cells are visible
> LibreOffice Calc Guide
>  Chapter 13 - Calc as a Simple Database
>   Page 313-320: Filters
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>


-- 
Regards,
Paul D. Rosenstock
paul1...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Chart in Calc

[Walter Hildebrandt]

Hi: Thank you for the link.  Yes, it would be an advantage if the
documentation team works with the video people.  I am the original creator
of the website Tutorial for OpenOffice.org.   I gave the website away and
do not know who has control of the website now.  Anyhow I think it would be
a huge advantage if the documentation team worked with the Tutorials for
OpenOffice.org website.  At a time back when I was involved we were getting
more questions than the User Group at OOo.  When a question was ask that
the tutorials website could not ask, it referred the questioner to the OOo
User Group.  Very ofter we got feedback that they had tried the OOo User
Group and thought it was no good because it did not help them so they came
to us for help.  The tutorials website found out our success was because
how we wrote the tutorials.  The tutorials were written as simple steps.
At this time, even though I am fairly well knowledgeable with OOo and LOo,
I can not understand what the video is showing and I can not understand
what much of the Calc Guide, Chapter 3, Creating Charts and Graphs is
saying.  It would be helpful if instructions was in a simple step by step
format.  For example1.  open a new spreadsheet   2.  In cell A1 type
June3.  In cell B1 type the number 5   4.  in cell A2 write  etc
 Highlight (select) cells A1, A2, A3, B1, B2, B3 Click on
the chart icon (have a picture of the chart icon  There is a better way
to word what I just gave as an example.  The bottom line is that in some
way (maybe just a link to begin with) the documentation group, the video
group, the tutorials website should be "working together" (should be"be
coordinated").

Now that the corporation's self-interest does not seem to be a factor, and
there is two separate forks, it is time for the two forks to get back
together as one group so there is no duplication and waste of physical
energy and capital resources..  I see little or no value in the idea that
the two forks create competition that is good.  There is enough competition
within one group to stimulate creativity.   Now that a lot of things have
happened we might have learned how to handle differences of opinions within
one group.  Differences of opinions is what caused there to be the
tutorials website, the User Group, the video approach, and the document
team.  You might have already demonstrated how to work together with
different opinions by using links to "integrate" the different opinions.


On Mon, Dec 26, 2011 at 12:06 PM, Tom  wrote:

> Hi :)
> You can always view the emails through Nabble.  Navigate to the right
> thread
> or click the click in this post.  Errr, actually here is the link to the
> video again
> http://youtu.be/NcYwVHIN2lE?hd=1
>
> The documentation team might be interested in joining in with the video
> work
> Regards from
> Tom :)
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Chart-in-Calc-tp3606746p3613044.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Basic use of the spreadsheet tools

[Mirosław Zalewski]

On 26/12/2011 at 21:07, Paul Rosenstock  wrote:

> Remove me from the distribution list!

Hi Paul,
please read 


If you need further assistance, don't hesitate to ask.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Basic use of the spreadsheet tools

[Andreas Säger]

Stefan Weigel wrote
> 
> Hi,
> 
> Am 26.12.2011 11:24, schrieb Luuk:
> 
>> Before creating the 'auto' filter, select all columns that are involved,
>> or (better) select all the cells involved.
> 
> I would rather recommend to select one single cell inside the list
> of data. Calc will automatically detect the data range.
> 
> Stefan
> 
Of course we have no information about the OS, the office version nor file
type. But my chrystal ball tells me that it is some Excel file with a
database range imported as "Excel_FilterData_0_8_15" or something. That
imported filter range does not include the current region. In this case the
automatic detection needs to fail because the database range is explicitly
restricted.

@Robert
menu:Data>Define... might show some filterable lists with "Excel" in the
name. Select such an entry and adjust the range address to the actual cell
range that describes the full list. Hit buttons [Modify] and [OK] when you
are done. Now all the solutions that have been given to you should work
actually.

--
View this message in context: 
http://nabble.documentfoundation.org/Basic-use-of-the-spreadsheet-tools-tp3612347p3613483.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] [Removal Hijack] Re: Basic use of the spreadsheet tools

[NoOp]

On 12/26/2011 12:07 PM, Paul Rosenstock wrote:
> Remove me from the distribution list!

Remove yourself:
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted

And quit hijacking other peoples threads. Start your own.



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Chart in Calc

[Tom Davies]

Hi :)

In any other industry competition would be seen as a good thing.  Which flavour 
of ice-cream do you prefer?  Should everyone wear identical ties bought from 
the same company?  If there was less variety in styles of music then a lot of 
effort could go into making that one style really great?  Should people have a 
choice of who to vote for?  What colour car, what manufacturer?  And so on.  
Somehow in desktop computing people think there should be a lack of choice and 
think that everyone should go with the dominant product.

Regards from
Tom :)

--- On Mon, 26/12/11, Walter Hildebrandt  wrote:

From: Walter Hildebrandt 
Subject: Re: [libreoffice-users] Re: Chart in Calc
To: users@global.libreoffice.org
Date: Monday, 26 December, 2011, 20:18

Hi: Thank you for the link.  Yes, it would be an advantage if the
documentation team works with the video people.  I am the original creator
of the website Tutorial for OpenOffice.org.   I gave the website away and
do not know who has control of the website now.  Anyhow I think it would be
a huge advantage if the documentation team worked with the Tutorials for
OpenOffice.org website.  At a time back when I was involved we were getting
more questions than the User Group at OOo.  When a question was ask that
the tutorials website could not ask, it referred the questioner to the OOo
User Group.  Very ofter we got feedback that they had tried the OOo User
Group and thought it was no good because it did not help them so they came
to us for help.  The tutorials website found out our success was because
how we wrote the tutorials.  The tutorials were written as simple steps.
At this time, even though I am fairly well knowledgeable with OOo and LOo,
I can not understand what the video is showing and I can not understand
what much of the Calc Guide, Chapter 3, Creating Charts and Graphs is
saying.  It would be helpful if instructions was in a simple step by step
format.  For example    1.  open a new spreadsheet   2.  In cell A1 type
June    3.  In cell B1 type the number 5   4.  in cell A2 write  etc
     Highlight (select) cells A1, A2, A3, B1, B2, B3             Click on
the chart icon (have a picture of the chart icon      There is a better way
to word what I just gave as an example.  The bottom line is that in some
way (maybe just a link to begin with) the documentation group, the video
group, the tutorials website should be "working together" (should be"be
coordinated").

Now that the corporation's self-interest does not seem to be a factor, and
there is two separate forks, it is time for the two forks to get back
together as one group so there is no duplication and waste of physical
energy and capital resources..  I see little or no value in the idea that
the two forks create competition that is good.  There is enough competition
within one group to stimulate creativity.   Now that a lot of things have
happened we might have learned how to handle differences of opinions within
one group.  Differences of opinions is what caused there to be the
tutorials website, the User Group, the video approach, and the document
team.  You might have already demonstrated how to work together with
different opinions by using links to "integrate" the different opinions.


On Mon, Dec 26, 2011 at 12:06 PM, Tom  wrote:

> Hi :)
> You can always view the emails through Nabble.  Navigate to the right
> thread
> or click the click in this post.  Errr, actually here is the link to the
> video again
> http://youtu.be/NcYwVHIN2lE?hd=1
>
> The documentation team might be interested in joining in with the video
> work
> Regards from
> Tom :)
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Chart-in-Calc-tp3606746p3613044.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Chart in Calc

[Tom Davies]

Hi :)
The chart that doesn't get updated.  Is that the chart in Calc itself or is it 
after it has been copy&pasted to somewhere else, perhaps a different worksheet 
in Calc?  If you copy&paste then it embeds the object but you could use a 
dynamic link instead (DDE or something)
Regards from
Tom :)


--- On Mon, 26/12/11, Walter Hildebrandt  wrote:

From: Walter Hildebrandt 
Subject: Re: [libreoffice-users] Re: Chart in Calc
To: users@global.libreoffice.org
Date: Monday, 26 December, 2011, 20:18

Hi: Thank you for the link.  Yes, it would be an advantage if the
documentation team works with the video people.  I am the original creator
of the website Tutorial for OpenOffice.org.   I gave the website away and
do not know who has control of the website now.  Anyhow I think it would be
a huge advantage if the documentation team worked with the Tutorials for
OpenOffice.org website.  At a time back when I was involved we were getting
more questions than the User Group at OOo.  When a question was ask that
the tutorials website could not ask, it referred the questioner to the OOo
User Group.  Very ofter we got feedback that they had tried the OOo User
Group and thought it was no good because it did not help them so they came
to us for help.  The tutorials website found out our success was because
how we wrote the tutorials.  The tutorials were written as simple steps.
At this time, even though I am fairly well knowledgeable with OOo and LOo,
I can not understand what the video is showing and I can not understand
what much of the Calc Guide, Chapter 3, Creating Charts and Graphs is
saying.  It would be helpful if instructions was in a simple step by step
format.  For example    1.  open a new spreadsheet   2.  In cell A1 type
June    3.  In cell B1 type the number 5   4.  in cell A2 write  etc
     Highlight (select) cells A1, A2, A3, B1, B2, B3             Click on
the chart icon (have a picture of the chart icon      There is a better way
to word what I just gave as an example.  The bottom line is that in some
way (maybe just a link to begin with) the documentation group, the video
group, the tutorials website should be "working together" (should be"be
coordinated").

Now that the corporation's self-interest does not seem to be a factor, and
there is two separate forks, it is time for the two forks to get back
together as one group so there is no duplication and waste of physical
energy and capital resources..  I see little or no value in the idea that
the two forks create competition that is good.  There is enough competition
within one group to stimulate creativity.   Now that a lot of things have
happened we might have learned how to handle differences of opinions within
one group.  Differences of opinions is what caused there to be the
tutorials website, the User Group, the video approach, and the document
team.  You might have already demonstrated how to work together with
different opinions by using links to "integrate" the different opinions.


On Mon, Dec 26, 2011 at 12:06 PM, Tom  wrote:

> Hi :)
> You can always view the emails through Nabble.  Navigate to the right
> thread
> or click the click in this post.  Errr, actually here is the link to the
> video again
> http://youtu.be/NcYwVHIN2lE?hd=1
>
> The documentation team might be interested in joining in with the video
> work
> Regards from
> Tom :)
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Chart-in-Calc-tp3606746p3613044.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Chart in Calc

[Walter Hildebrandt]

This happens the very first time I create a chart by clicking the Chart
icon and get both the chart for the first time and the Wizard.  I see no
choice on the wizard to make a correction and then click Finish.

On Mon, Dec 26, 2011 at 7:27 PM, Tom Davies  wrote:

> Hi :)
> The chart that doesn't get updated.  Is that the chart in Calc itself or
> is it after it has been copy&pasted to somewhere else, perhaps a different
> worksheet in Calc?  If you copy&paste then it embeds the object but you
> could use a dynamic link instead (DDE or something)
> Regards from
> Tom :)
>
>
> --- On Mon, 26/12/11, Walter Hildebrandt  wrote:
>
> From: Walter Hildebrandt 
> Subject: Re: [libreoffice-users] Re: Chart in Calc
> To: users@global.libreoffice.org
> Date: Monday, 26 December, 2011, 20:18
>
> Hi: Thank you for the link.  Yes, it would be an advantage if the
> documentation team works with the video people.  I am the original creator
> of the website Tutorial for OpenOffice.org.   I gave the website away and
> do not know who has control of the website now.  Anyhow I think it would be
> a huge advantage if the documentation team worked with the Tutorials for
> OpenOffice.org website.  At a time back when I was involved we were getting
> more questions than the User Group at OOo.  When a question was ask that
> the tutorials website could not ask, it referred the questioner to the OOo
> User Group.  Very ofter we got feedback that they had tried the OOo User
> Group and thought it was no good because it did not help them so they came
> to us for help.  The tutorials website found out our success was because
> how we wrote the tutorials.  The tutorials were written as simple steps.
> At this time, even though I am fairly well knowledgeable with OOo and LOo,
> I can not understand what the video is showing and I can not understand
> what much of the Calc Guide, Chapter 3, Creating Charts and Graphs is
> saying.  It would be helpful if instructions was in a simple step by step
> format.  For example1.  open a new spreadsheet   2.  In cell A1 type
> June3.  In cell B1 type the number 5   4.  in cell A2 write  etc
>  Highlight (select) cells A1, A2, A3, B1, B2, B3 Click on
> the chart icon (have a picture of the chart icon  There is a better way
> to word what I just gave as an example.  The bottom line is that in some
> way (maybe just a link to begin with) the documentation group, the video
> group, the tutorials website should be "working together" (should be"be
> coordinated").
>
> Now that the corporation's self-interest does not seem to be a factor, and
> there is two separate forks, it is time for the two forks to get back
> together as one group so there is no duplication and waste of physical
> energy and capital resources..  I see little or no value in the idea that
> the two forks create competition that is good.  There is enough competition
> within one group to stimulate creativity.   Now that a lot of things have
> happened we might have learned how to handle differences of opinions within
> one group.  Differences of opinions is what caused there to be the
> tutorials website, the User Group, the video approach, and the document
> team.  You might have already demonstrated how to work together with
> different opinions by using links to "integrate" the different opinions.
>
>
> On Mon, Dec 26, 2011 at 12:06 PM, Tom  wrote:
>
> > Hi :)
> > You can always view the emails through Nabble.  Navigate to the right
> > thread
> > or click the click in this post.  Errr, actually here is the link to the
> > video again
> > http://youtu.be/NcYwVHIN2lE?hd=1
> >
> > The documentation team might be interested in joining in with the video
> > work
> > Regards from
> > Tom :)
> >
> > --
> > View this message in context:
> >
> http://nabble.documentfoundation.org/Chart-in-Calc-tp3606746p3613044.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
> > --
> > For unsubscribe instructions e-mail to:
> users+h...@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
> --
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> Lis

Re: [libreoffice-users] Re: How to paste a function so Calc doesn't change addresses in it?

[Alan Boba]

On Mon, Dec 26, 2011 at 11:21 AM, Csanyi Pal  wrote:

> Alan Boba  writes:
>
> > On Mon, Dec 26, 2011 at 10:46 AM, Alan Boba  wrote:
>
> >> 2011/12/26 Csányi Pál 
>
> > constant column when formula is copied $B6. A formula containing this
> > reference will always us "B" as the column but the row will change if the
> > formula is copied to a different row.
>
> It works for the next raw, but how can I use this behavior when I want to
> copy to a different column?
>
> When I'm trying to copy to the next column:
>
> =HA(DARABÜRES('5.'.$AD6);"0";HA('5.'.$AD6="1";"-";HA("1"<'5.'.$AD6<"6";"+";"hamis")))
>
> It remains like this:
>
> =HA(DARABÜRES('5.'.$AD6);"0";HA('5.'.$AD6="1";"-";HA("1"<'5.'.$AD6<"6";"+";"hamis")))
>
> and the address $AD6 doesn't changed to $AD7, why?
>

I'm a bit lost by your question. Copying the first formula to another cell
_on_the_same_row_ should have exactly the result you've shown.

If the cell reference in the formula should change from $AD6 to $AD7 then
after copying the formula it must be pasted one row below the row it is
copied from. If the formula is in cell A1 and copied from there to cell B2
the cell reference in the formula will be updated from $AD6 to $AD7. Note
the destination I've given is on a different row and in a different column.
However only the row number would change because the column value is
preceded by "$". If the formula is pasted into a cell two rows lower then
the cell reference would change from $AD6 to $AD8 and so on.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Python info for a new learner

[webmaster for Kracked Press Productions]

I was wondering what Python development packages are best for FREE 
learning of Python on Windows XP/Vista laptop and Ubuntu 10.x desktop.


Since I have to recreate some simple software text utilities, the ones I 
has written in C++ years ago were lost, and was told that Python was 
easy to learn.  So I thought since Python was what the new code for LO 
is written in, there would be some views here.


I could pull out my thickly dust covered C++ books, and try to relearn 
all of the needed things in that language over again, or I could just 
use Python.  I will test out if it is easier to learn than C++.


So, I need FREE packages for editing environments, interpretor/compiler 
software, plus free PDF or other non-online documentation sources.  
Also, it would be nice to find some great free code "script" sites.  It 
would be easier to write what I need to, if I can find something close 
enough to what I need, and then do the edits to make it work for my 
needs.  FREE is the key.  I use Ubuntu, but I might like to have these 
utilities on my Windows based laptops, like the original ones.  So I 
need to have all the needed tools, libraries, etc., for both systems.


Any help?

I just order some used books, since it would cost too much to buy the 
new ones at 3 times the cost, when I do not know how far I will be going 
with Python programming.  Now I have to download the software to do the 
work.


You can contact me off-list at "webmas...@libreoffice-na.us", if you 
like.  One need is for software to compare word lists and merge lists.  
When you have over 600,000 words in one of the lists, you do not want to 
do it by hand, even if you only need to see if 30,40, or more, words are 
in that "rather large" word list.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Chart in Calc

[soumalya ray]

sorry for the late reply and thank you tom for posting the link.
after clicking the 'chart' icon,you are getting both the chart and the
wizard.in the wizard,there are four button at the bottom- back(greyed
out),next,finish,cancel.out of these four buttons,you should click the
finish button.the wizard will then disappear.
regards,

On 27 December 2011 06:05, Walter Hildebrandt  wrote:

> This happens the very first time I create a chart by clicking the Chart
> icon and get both the chart for the first time and the Wizard.  I see no
> choice on the wizard to make a correction and then click Finish.
>
>
> For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>


-- 
Dr soumalya ray   
MBBS,MD(PGT-C.Medicine),Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?

[Stefan Weigel]

Hi,

Am 26.12.2011 16:25, schrieb Csányi Pál:

> How can I copy/paste the function so so the addresses in the
> function remain the same as in the original cell?

The answer is easy and it is here:
http://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative

Stefan
:-)

-- 
LibreOffice - Die Freiheit nehm' ich mir!

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted