Re: [libreoffice-users] If Cell Contains String True
On Thu, Feb 21, 2013 at 1:43 PM, Joel Madero wrote:
> What I have:
>
> A|B
> comment|regression check
> regression|
> regression,BSA,i10n|
> BLANK|
> BLANK|
> regression|
> regression,bibisected|
> BSA|
> BSA|
> cleanup0407|
>
> If that's not clear those are A1:B10, where | splits A and B columns. B
> column is empty other than B1 which has header "regression check"
>
> I need a formula which will be true if the word "regression" is in A at all
> (so in the above example A2, A3,A5,A6 would all be true).
>
If I'm understanding what you want I think this function will give the
results you're looking for
=NOT(ISERROR( SEARCH("regression",A2)))
SEARCH() is case insensitive so finds the word no matter the capitalization
ISERROR() accounts for empty cells and cells with numbers that cause
SEARCH() to fail
NOT() causes the result to be TRUE when ISERROR() returns FALSE because the
nested SEARCH() is TRUE
--
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] calc: method to subdivide individual cells
On Wed, Feb 13, 2013 at 8:14 PM, pete b. wrote: > Does calc have some kind of method to subdivide individual cells? > > > Subdivide how? Using what criteria? For a cell or cells containing text it/they can be subdivided using the "Data / Text to Columns..." menu choice. -- 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] Libre Office listed in petition to promote the use of free software in our schools
On Fri, Dec 28, 2012 at 11:42 AM, Tom Davies wrote: > > > Hi :) > I thought a few people on the Users List might be interested in this > petition. > > Apparently you need to create a whitehouse.gov account to sign Petitions > which would probably put me off signing. On the other hand having a chance > to kinda vote on single issues seems like a good thing. Hmm, a tough > choice. > Regards from > Tom :) > > > > > > > From: Immanuel Giulea > >To: disc...@documentfoundation.org; market...@global.libreoffice.org; > market...@us.libreoffice.org > >Sent: Friday, 28 December 2012, 15:01 > >Subject: [libreoffice-marketing] Libre Office listed in petition to > promote the use of free software in our schools > > > >Hello all, > > > >>From my readings of the mailing lists in the last few weeks, it seems > that > >adoption of LibreOffice in North America (especially US) has been a > >challenge. > > > >Today, I found a petition addressed to the White House that includes > >LibreOffice. > > > https://petitions.whitehouse.gov/petition/promote-use-free-software-our-schools-libre-office-gimp-gnu-cash-and-other-gpl-software-which-cost/T1xGw1fZ > > > >The deadline is three weeks away and they need 23,000 more signatures. > >Nothing is impossible through the power of social networks. > >I've already shared the petition to several G+ groups. > >Perhaps some posts from TDF core team on twitter and Facebook will help > >this initiative. > > > >Just a thought. > > > > > >Cheers from Montreal, Canada > > > >Immanuel Giulea > > > >-- > >Unsubscribe instructions: E-mail to marketing+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/marketing/ > >All messages sent to this list will be publicly archived and cannot be > deleted > > > > > > > > > I would sign but... The petition begins by castigating issues with proprietary software. My belief is that while those issues may be important they aren't a consideration for the great majority of computer users. In addition I find it much easier to support causes that don't cultivate fud but instead focus on the benefits of a proposed action. Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011 -- 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: Labels custom format
On Fri, Sep 21, 2012 at 11:43 AM, Don C. Myers wrote: > > Maybe the table style labels for OTT 2 here will work for you. > http://www.worldlabel.com/Pages/openoffice-template.htm > > On 09/21/2012 11:13 AM, Alan Boba wrote: > > Peter, how do you control vertical height of the table frames? I just had > difficulties creating labels myself. Very laborious for me using frames and > sections. I tried tables shortly after starting the frame/section method > but just couldn't find any way to specify the height of individual cells in > the tables so abandoned it and went back to frames and sections. > > Very helpful! Thank you. And it leads to resolving my question of controlling row height too. Somehow I kept overlooking the "row" property when right clicking the table and instead only saw "table". There are no row height attributes in the table dialog. However in the row property dialog the row height is an editable attribute. Just what I needed to find. Again thank you. -- 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: Labels custom format
On Fri, Sep 21, 2012 at 10:30 AM, Peter Hillier-Brook wrote: > > you might also want to look at creating your label template(s) with a > table, rather than the curious frame based system used currently by > LibreOffice. It's what I do and it is very successful. I find that I have > more accurate control over the layout with this method. > > Peter, how do you control vertical height of the table frames? I just had difficulties creating labels myself. Very laborious for me using frames and sections. I tried tables shortly after starting the frame/section method but just couldn't find any way to specify the height of individual cells in the tables so abandoned it and went back to frames and sections. -- 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] [3.4.4/Windows] How to move cell with mouse?
On Wed, Jan 11, 2012 at 7:45 PM, Gilles wrote: > Hello, > > I want to move cell A1 to A2 with the mouse: > > This stumped me for ages, then I found the solution. 1. Move cell pointer to desired cell 2. Press Ctrl 3. Click on desired cell (note: Click, not Click and hold) 4. Release Ctrl 5. Click and hold to drag highlighted cell to new destination :-) -- 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: How to paste a function so Calc doesn't change addresses in it?
On Dec 27, 2011 8:42 AM, "Csanyi Pal" wrote:
>
> Alan Boba writes:
>
> > 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
>
> >> 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.
>
> My question abowe is about that that if one want to copy a formula into
> a cell say one raw lower, then addresses in formula would change without
> '$' prefix but wouldn't change (again, without '$' prefix) if the same
> formula want to copy into a cell that is in the same raw. I hope I'm
> clear now. (Sorry for my English.)
>
> > 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.
>
> All right, I understand You perfectly. Thanks for the explanation!
>
> --
> Regards, Pal
>
You're welcome. Glad I was able to help.
--
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: How to paste a function so Calc doesn't change addresses in it?
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
Re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?
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/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
>> Posting guidelines + more: http://wiki.**documentfoundation.org/**
>> Netiquette <http://wiki.documentfoundation.org/Netiquette>
>> List archive:
>> http://listarchives.**libreoffice.org/global/users/<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
Re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?
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/
> List archive:
> http://listarchives.**libreoffice.org/global/users/
