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 <[email protected]>
>To: "[email protected]" <[email protected]>
>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 <[email protected]>
>To: [email protected]
>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: [email protected]
>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: [email protected]
>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: [email protected]
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
