Re: [libreoffice-users] Calc - Multiple font effects in a single cell

Hi :)
It's a bit like moving everthing back up to the internet or big server machines and making desktop 
machines more like 'dumb'-terminals and calling the whole thing a bright new name ("The Cloud")as 
though it was something new.

Regards from
Tom :)  





> ________________________________
> From: Viral Orpe <viral.orpe@yahoo.com>
> To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
> Sent: Friday, 19 October 2012, 15:17
> Subject: Re: [libreoffice-users] Calc - Multiple font effects in a single cell
>
> Hi MiguelAngel,
>
> That's cool. 
>
> Just this last weekend I spent a lot of time trying to do exactly that -
> using shell script - reading line by line and then extracting the alphanums
> from a csv.
>
> This is way too fast and easy. Thanks,It won't address the "Multiple font effects in a single 
> cell" issue. (Right?)
>
>
> BTW, I do not understand one thing. 
>
> imo, from ease point of view the world moved from scripts to spreadsheets etc 
>
> applications and now everybody wants to program them!?   
>  
> Thanks,
> Regards,
> Viral Orpe :)
> ---------------------------------------------------------------------------------------------------
>
> Processor  : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz
> Memory     : 4GB, DDR3 
> OS            : Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686)
> LibreOffice : LibreOffice 3.4.3  OOO340m1 (Build:302)
>
> ---------------------------------------------------------------------------------------------------
>
>
>
> ________________________________
> From: MiguelAngel <mariosv@miguelangel.mobi>
> To: users@global.libreoffice.org 
> Sent: Friday, October 19, 2012 3:24 PM
> Subject: Re: [libreoffice-users] Calc - Multiple font effects in a single cell
>
> El 19/10/12 10:00, david_lynch escribió:
> >    I want to have a cell in Calc with multiple font effects, which
> > characters get which font depends on the values in other cells. An example:
> >
> > A1 abcdefg
> > A2 3
> > A3 5
> > I want to be able to program Calc so that characters A2 to A3  (3 to 5)
> > of A1 are strikeout, so A1 looks like
> > abcdefg     with "cde" in strikeout.
> >
> > I know I can get this effect be editing A1 manually, but that not
> > possible with the large number of cells I want to edit in this manner.
> >
> > Can anyone tell me a way to do this, please? I'm willing to program this
> > in basic if it's the only way.
> >
> > David Lynch
>
> Maybe the function MID() is what you are looking for?
>
> =MID("abcdefg";A2;A3-A2+1)
>
> Menu/Help/LibreOffice help (F1) - Index tab - search term: MID.
> "
> MID
> Returns a text string of a text. The parameters specify the starting 
> position and the number of characters.
> Syntax
> MID("Text"; Start; Number)
> Text is the text containing the characters to extract.
> Start is the position of the first character in the text to extract.
> Number specifies the number of characters in the part of the text.
> Example
> =MID("office";2;2) returns ff.
> "
>
> -- 
> 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
> -- 
> 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
-- 
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