date:20130516

Re: [libreoffice-users] Re: file recovery

2013-05-16 Thread Jay Lozier


On Thu, 16 May 2013 21:22:51 -0400, John Cuda  wrote:


please help!

The file I was working on in libreoffice somehow got saved on all
three of my drives in a corrupted format. A 75 page writer doc
is opening up as a 7 page document, and ms word is unable to open it.
saying that the file has been damaged, or is saved in the wrong format.
I see that my auto recovery settings are set to save autorecovery
 data every 15 minutes. can you help me recover my file?

John



What is your OS and are you having other problems reading these drives?

The specific steps and file locations may be OS dependent.

--
Jay Lozier
jsloz...@gmail.com

--
To unsubscribe e-mail to: users+unsubscr...@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: file recovery

2013-05-16 Thread Steve Edmonds


Hi.
Does it look like the file has become much smaller.
You could try copying the file and changing the extension on the copy to 
.zip. Unzip the file and then see if you can find your bulk of text, may 
be in content.xml. If it seems to be there then that could be your last 
resort to use that and re-format it.

Steve
On 2013-05-17 13:22, John Cuda wrote:

please help!

The file I was working on in libreoffice somehow got saved on all
three of my drives in a corrupted format. A 75 page writer doc
is opening up as a 7 page document, and ms word is unable to open it.
saying that the file has been damaged, or is saved in the wrong format.
I see that my auto recovery settings are set to save autorecovery
  data every 15 minutes. can you help me recover my file?

John





--
To unsubscribe e-mail to: users+unsubscr...@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: Uninstall LibreOffice 4.0.2

2013-05-16 Thread Don C. Myers

Below is the method I've used for originally OpenOffice, and now
LibreOffice. This is for a 64 bit install. I've done 3 clean installs of
Ubuntu 13.04, and replaced the Ubuntu version of LibreOffice with the
Document Version of 4.0.3.3 on each machine without issue. This method
has never failed me:

Instructions for the 64 Bit Debian Version:
Download LibreOffice_4.0.3.3 to the desktop.
Right click on it and extract it to the desktop. This will give you the
folder LibreOffice_4.0.3.3_Linux_x86-64_deb

Run the following terminal commands to install it:
1. sudo apt-get remove libreoffice*.*
2. sudo dpkg -i ~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/*.deb
3. sudo dpkg -i
~/Desktop/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration/libreoffice4.0-debian-menus_4.0.3-3_all.deb

4. Drag Icons from Dash to the Unity Launcher Bar if using Unity.

Don

On 05/16/2013 07:31 PM, CVAlkan wrote:

Hi Steve:

No, none of the modules run (--writer, calc, etc.)

There's apparently some older ubuntu menu integration stuff still on the
machine - possibly even leftover from my 3.6 installation.

Frank

--
View this message in context:
http://nabble.documentfoundation.org/Uninstall-LibreOffice-4-0-2-tp4056552p4056557.html
Sent from the Users mailing list archive at Nabble.com.

--
To unsubscribe e-mail to: users+unsubscr...@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: file recovery

2013-05-16 Thread John Cuda

please help!

The file I was working on in libreoffice somehow got saved on all 
three of my drives in a corrupted format. A 75 page writer doc 
is opening up as a 7 page document, and ms word is unable to open it. 
saying that the file has been damaged, or is saved in the wrong format.
I see that my auto recovery settings are set to save autorecovery
 data every 15 minutes. can you help me recover my file?

John


-- 
To unsubscribe e-mail to: users+unsubscr...@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] Uninstall LibreOffice 4.0.2

2013-05-16 Thread Tim Lloyd

Hi, my debian knowledge is limited but this issue has been raised in the 
past. Can you try:


sudo apt-get remove libreoffice*( is that the right command to 
remove everything?)
then do your first part again (the stuff in the ...tar.gz) and see what 
you get


What do you end up with? I can't find the previous email but I am sure 
someone suggested you don't need to do the 2nd part. And I am almost 
positive you don't need to do *.deb


Cheers
On 05/17/2013 08:29 AM, CVAlkan wrote:

Hi:

I uninstalled my 3.6 LibreOffice a few weeks ago when I discovered that the
Ubuntu Software Center had an "official" version of the new 4.0.2. I'm using
a 64 bit version of Ubuntu 12.04 LTS by the way.

I've had a slew of problems with that release and don't have the time to
fool with it, so I uninstalled all of the LibreOffice stuff - again using
the Ubuntu Software Center - in order to try the separately downloaded 4.0.3
version from the Libre Office site.

Everything went well for the first part (the stuff in
LibreOffice_4.0.3_Linux_x86-64_deb.tar.gz). When I attempted the second part
(in the desktop-integration), I got the following message:

~/Downloads/LibreOffice_4/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration$
sudo dpkg -i *.deb
dpkg: regarding libreoffice4.0-debian-menus_4.0.3-3_all.deb containing
libreoffice-debian-menus:
  libreoffice-core conflicts with libreoffice-unbundled
   libreoffice-debian-menus provides libreoffice-unbundled and is to be
installed.
dpkg: error processing libreoffice4.0-debian-menus_4.0.3-3_all.deb
(--install):
  conflicting packages - not installing libreoffice-debian-menus
Errors were encountered while processing:
  libreoffice4.0-debian-menus_4.0.3-3_all.deb

I tried opening libreoffice4.0-debian-menus_4.0.3-3_all.deb in the Ubuntu
Software Center, but got the message "Conflicts with the installed package
'libreoffice-core".

Now I have no LibreOffice at all. I had thought of trying to reinstall 3.6,
but figured that might only make things worse.

I suspect I need to rid the machine entirely of anything related to
LibreOffice (although it's annoying that uninstalling everything from the
place I installed it didn't do that).

Can anyone help? Thanks a bunch...




--
View this message in context: 
http://nabble.documentfoundation.org/Uninstall-LibreOffice-4-0-2-tp4056552.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@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: Uninstall LibreOffice 4.0.2

2013-05-16 Thread CVAlkan

Hi Steve:

No, none of the modules run (--writer, calc, etc.)

There's apparently some older ubuntu menu integration stuff still on the
machine - possibly even leftover from my 3.6 installation.

Frank



--
View this message in context: 
http://nabble.documentfoundation.org/Uninstall-LibreOffice-4-0-2-tp4056552p4056557.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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] Uninstall LibreOffice 4.0.2

2013-05-16 Thread Steve Edmonds


Hi.
If you open a terminal/konsole/command prompt and type libreoffice 
--writer and press return, does libreoffice start.


If it does you may just have to add some start items to your menu.

Steve

On 2013-05-17 10:29, CVAlkan wrote:

Hi:

I uninstalled my 3.6 LibreOffice a few weeks ago when I discovered that the
Ubuntu Software Center had an "official" version of the new 4.0.2. I'm using
a 64 bit version of Ubuntu 12.04 LTS by the way.

I've had a slew of problems with that release and don't have the time to
fool with it, so I uninstalled all of the LibreOffice stuff - again using
the Ubuntu Software Center - in order to try the separately downloaded 4.0.3
version from the Libre Office site.

Everything went well for the first part (the stuff in
LibreOffice_4.0.3_Linux_x86-64_deb.tar.gz). When I attempted the second part
(in the desktop-integration), I got the following message:

~/Downloads/LibreOffice_4/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration$
sudo dpkg -i *.deb
dpkg: regarding libreoffice4.0-debian-menus_4.0.3-3_all.deb containing
libreoffice-debian-menus:
  libreoffice-core conflicts with libreoffice-unbundled
   libreoffice-debian-menus provides libreoffice-unbundled and is to be
installed.
dpkg: error processing libreoffice4.0-debian-menus_4.0.3-3_all.deb
(--install):
  conflicting packages - not installing libreoffice-debian-menus
Errors were encountered while processing:
  libreoffice4.0-debian-menus_4.0.3-3_all.deb

I tried opening libreoffice4.0-debian-menus_4.0.3-3_all.deb in the Ubuntu
Software Center, but got the message "Conflicts with the installed package
'libreoffice-core".

Now I have no LibreOffice at all. I had thought of trying to reinstall 3.6,
but figured that might only make things worse.

I suspect I need to rid the machine entirely of anything related to
LibreOffice (although it's annoying that uninstalling everything from the
place I installed it didn't do that).

Can anyone help? Thanks a bunch...




--
View this message in context: 
http://nabble.documentfoundation.org/Uninstall-LibreOffice-4-0-2-tp4056552.html
Sent from the Users mailing list archive at Nabble.com.




--
To unsubscribe e-mail to: users+unsubscr...@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] Uninstall LibreOffice 4.0.2

2013-05-16 Thread CVAlkan

Hi:

I uninstalled my 3.6 LibreOffice a few weeks ago when I discovered that the
Ubuntu Software Center had an "official" version of the new 4.0.2. I'm using
a 64 bit version of Ubuntu 12.04 LTS by the way.

I've had a slew of problems with that release and don't have the time to
fool with it, so I uninstalled all of the LibreOffice stuff - again using
the Ubuntu Software Center - in order to try the separately downloaded 4.0.3
version from the Libre Office site.

Everything went well for the first part (the stuff in
LibreOffice_4.0.3_Linux_x86-64_deb.tar.gz). When I attempted the second part
(in the desktop-integration), I got the following message:

~/Downloads/LibreOffice_4/LibreOffice_4.0.3.3_Linux_x86-64_deb/DEBS/desktop-integration$
sudo dpkg -i *.deb
dpkg: regarding libreoffice4.0-debian-menus_4.0.3-3_all.deb containing
libreoffice-debian-menus:
 libreoffice-core conflicts with libreoffice-unbundled
  libreoffice-debian-menus provides libreoffice-unbundled and is to be
installed.
dpkg: error processing libreoffice4.0-debian-menus_4.0.3-3_all.deb
(--install):
 conflicting packages - not installing libreoffice-debian-menus
Errors were encountered while processing:
 libreoffice4.0-debian-menus_4.0.3-3_all.deb

I tried opening libreoffice4.0-debian-menus_4.0.3-3_all.deb in the Ubuntu
Software Center, but got the message "Conflicts with the installed package
'libreoffice-core".

Now I have no LibreOffice at all. I had thought of trying to reinstall 3.6,
but figured that might only make things worse.

I suspect I need to rid the machine entirely of anything related to
LibreOffice (although it's annoying that uninstalling everything from the
place I installed it didn't do that).

Can anyone help? Thanks a bunch...




--
View this message in context: 
http://nabble.documentfoundation.org/Uninstall-LibreOffice-4-0-2-tp4056552.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Carl Paulsen

That wouldn't change anything.  The existing semi-colon would be treated 
as just text in the field contents, so it would show up where it is in 
the field as well as the formula one.  If you already have semi-colons 
in the fields at the end of the text, then they wouldn't be needed in my 
case.  But I didn't have them and didn't want to add them.

On 5/16/13 3:28 PM, mcmurchy1917-libreoff...@yahoo.co.uk wrote:

Just a quick question. What happens if any of the fields already contains a
semi-colon?

Iain

On Thursday 16 May 2013 10:23:23 Carl Paulsen wrote:

Hi Tom.

Well, not quite.  In my particular case this formula worked.  But with
some off-list input from smarter brains than mine, I realize it wouldn't
work under many situations.

It turns out the formula would need to change a bit, otherwise what I
did would leave a trailing semi-colon where column X is blank.  In fact,
it's a tricky situation b/c a semi-colon is needed after U3 if U3 has a
value AND any of the others has a value, otherwise not. Then, if V3 has
a value and any of the other later cells has a value, there should be
another semi-colon.  Etc. etc.  In the last case, a semi-colon should
follow W3 only if there's a value in X3.

I've tried a bunch of formulas and the closest I've come is the following:

=A13&IF(NOT(ISBLANK(A13))AND(NOT(ISBLANK(B13)))OR(NOT(ISBLANK(C13)))OR(NOT(I
SBLANK(D13))),";","")&B13&IF(NOT(ISBLANK(B13))AND(NOT(ISBLANK(C13)))OR(NOT(I
SBLANK(D13))),";","")&C13&IF(NOT(ISBLANK(C13))AND(NOT(ISBLANK(D13))),";","")
&D13

But that clearly doesn't work.  Note I'm working in a test sheet and am
using different cells.  This formula leaves leading semi-colons under a
number of situations and double semi-colons under others. I'm not
entirely sure CASE would work any better here though.

Anyone want to help out, great.  But it's a pretty specialized
situation, so I understand if not.

Carl

On 5/16/13 3:02 AM, Tom Davies wrote:

Hi :)
WoooHooo!!  Nicely done! :)  Is this whole thread solved now?
COngrats of so!
Regards from
Tom :)

 --
 --
 *From:* Carl Paulsen 
 *To:* users@global.libreoffice.org
 *Sent:* Thursday, 16 May 2013, 1:44
 *Subject:* Re: [libreoffice-users] "Case" function equivalent in Calc

 At long last I got this to work.  Syntax is "ISBLANK" and not

 "ISEMPTY"
 - aaa.  My Filemaker days are getting in my way.  Replace
 all "isempty" below with "ISBLANK" and it works perfectly now.

 Carl

 On 5/15/13 6:38 PM, Carl Paulsen wrote:

 > So in the absence of a Case function, here's what I've done so

 far as

 > a calculated solution.  Note that the data I want to concatenate

 is in

 > cells U3, V3, W3, and X3.  In Y3, I put the following:

 >
 > =U3 & IF(NOT(isempty(U3)),";","") & V3 &

 IF(NOT(isempty(V3)),";","") &

 > W3 & IF(NOT(isempty(W3)),";","") & X3

 >
 > The idea is that I put together U3, a semicolon if U3 isn't

 empty (and

 > nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a

 > semicolon if W3 isn't empty, and X3.  If any of the cells is empty,
 > nothing will be added until the next cell that has data.
 >
 > Unfortunately, I'm getting a #NAME? error.  I'm assuming some

 kind of

 > syntax error.  Any words of wisdom?

 >
 > Thanks a ton all.
 > Carl
 >
 > On 5/15/13 5:13 PM, Dan Lewis wrote:
 >> On 05/15/2013 04:16 PM, Carl Paulsen wrote:
 >>> Anyone know if there is an equivalent to the Filemaker Pro "Case"
 >>> function?  It's kinda like the "IF" function but is simpler to
 >>> concatenate multiple conditions. It basically says If

 something is

 >>> true then do what is specified, if the next thing is, then do

 that,

 >>> if the next thing is true, do that, etc.

 >>>
 >>> Here's what I need to do.  Take 4 columns and concatenate with a
 >>> semi-colon between the values, but not string together two
 >>> semi-colons consecutively.  Like:
 >>>
 >>> PhoneEmailMail -> Phone;Email;Mail
 >>> Phone  Mail -> Phone;Mail
 >>>
 >>>Mail -> Mail
 >>>
 >>>  EmailMail -> Email;Mail
 >>>
 >>> So semi-colons only occur if there's a value present and not

 at all

 >>> if there's only one value present.

 >>> I hope that makes sense and displays correctly.
 >>>
 >>> Carl
 >>>
 >>  I just checked the available functions in Calc. The "Case"
 >>
 >> function does not appear among them. "Case When" is available

 in Base

 >> database queries though.

 >>
 >> --Dan

--

Carl Paulsen

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Dave Liesse

Here's a formula that works.  It's ugly, but it works.

=MID(SUBSTITUTE(SUBSTITUTE(";"&A1&";"&B1&";"&C1&";"&D1&";",";;",";"),";;",";"),2,LEN(SUBSTITUTE(SUBSTITUTE(";"&A1&";"&B1&";"&C1&";"&D1&";",";;",";"),";;",";"))-2)

The thing to do in a case like this is to break the problem down into 
sections.  There are many ways to approach this specific question, but 
here's my thought process.

1.  Go ahead and concatenate all the cells and worry later about whether 
or not they contain data.  Insert semicolons between values.

2.  Include a semicolon at the beginning and end of the string to 
accommodate the next two steps (in case the first or last cell is empty).

3.  Where two semicolons are consecutive, eliminate one of them.

4.  Eliminate the semicolons at the beginning and end of the string.

After that, I break the functions down to simplify construction of the 
monster.

A.  =MID([string],2,LEN([string]-2)
This strips the beginning and ending semicolons.

B.  =SUBSTITUTE([string],";;",";")
This replaces every instance of two semicolons with a single 
one.  Unfortunately, the function is not recursive, so if there are 
three in a row it will only make one replacement.  This why the final 
formula has two instances of the SUBSTITUTE function.

C.  [string] is the concatenation of everything.

Hope this helps!

Dave

On 5/16/2013 07:23, Carl Paulsen wrote:

Hi Tom.

Well, not quite.  In my particular case this formula worked.  But with 
some off-list input from smarter brains than mine, I realize it 
wouldn't work under many situations.

It turns out the formula would need to change a bit, otherwise what I 
did would leave a trailing semi-colon where column X is blank.  In 
fact, it's a tricky situation b/c a semi-colon is needed after U3 if 
U3 has a value AND any of the others has a value, otherwise not. Then, 
if V3 has a value and any of the other later cells has a value, there 
should be another semi-colon.  Etc. etc.  In the last case, a 
semi-colon should follow W3 only if there's a value in X3.

I've tried a bunch of formulas and the closest I've come is the 
following:

=A13&IF(NOT(ISBLANK(A13))AND(NOT(ISBLANK(B13)))OR(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),";","")&B13&IF(NOT(ISBLANK(B13))AND(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),";","")&C13&IF(NOT(ISBLANK(C13))AND(NOT(ISBLANK(D13))),";","")&D13 

But that clearly doesn't work.  Note I'm working in a test sheet and 
am using different cells.  This formula leaves leading semi-colons 
under a number of situations and double semi-colons under others. I'm 
not entirely sure CASE would work any better here though.

Anyone want to help out, great.  But it's a pretty specialized 
situation, so I understand if not.

Carl

On 5/16/13 3:02 AM, Tom Davies wrote:

Hi :)
WoooHooo!!  Nicely done! :)  Is this whole thread solved now? 
COngrats of so!

Regards from
Tom :)

*From:* Carl Paulsen 
*To:* users@global.libreoffice.org
*Sent:* Thursday, 16 May 2013, 1:44
*Subject:* Re: [libreoffice-users] "Case" function equivalent in 
Calc

At long last I got this to work.  Syntax is "ISBLANK" and not
"ISEMPTY"
- aaa.  My Filemaker days are getting in my way.  
Replace

all "isempty" below with "ISBLANK" and it works perfectly now.

Carl

On 5/15/13 6:38 PM, Carl Paulsen wrote:
> So in the absence of a Case function, here's what I've done so
far as
> a calculated solution.  Note that the data I want to concatenate
is in
> cells U3, V3, W3, and X3.  In Y3, I put the following:
>
> =U3 & IF(NOT(isempty(U3)),";","") & V3 &
IF(NOT(isempty(V3)),";","") &
> W3 & IF(NOT(isempty(W3)),";","") & X3
>
> The idea is that I put together U3, a semicolon if U3 isn't
empty (and
> nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a
> semicolon if W3 isn't empty, and X3.  If any of the cells is 
empty,

> nothing will be added until the next cell that has data.
>
> Unfortunately, I'm getting a #NAME? error.  I'm assuming some
kind of
> syntax error.  Any words of wisdom?
>
> Thanks a ton all.
> Carl
>
>
>
> On 5/15/13 5:13 PM, Dan Lewis wrote:
>> On 05/15/2013 04:16 PM, Carl Paulsen wrote:
>>> Anyone know if there is an equivalent to the Filemaker Pro 
"Case"

>>> function?  It's kinda like the "IF" function but is simpler to
>>> concatenate multiple conditions. It basically says If
something is
>>> true then do what is specified, if the next thing is, then do
that,
>>> if the next thing is true, do that, etc.
>>>
>>> Here's what I need to do.  Take 4 columns and concatenate with a
>>> semi-colon between the values, but not string together two
>>> semi-colons consecutively.  Like:
>>>
>>> PhoneEmailMail -> Phone;Email;Mail
>>> Phone

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread mcmurchy1917-libreoffice

Just a quick question. What happens if any of the fields already contains a 
semi-colon?

Iain

On Thursday 16 May 2013 10:23:23 Carl Paulsen wrote:
> Hi Tom.
> 
> Well, not quite.  In my particular case this formula worked.  But with
> some off-list input from smarter brains than mine, I realize it wouldn't
> work under many situations.
> 
> It turns out the formula would need to change a bit, otherwise what I
> did would leave a trailing semi-colon where column X is blank.  In fact,
> it's a tricky situation b/c a semi-colon is needed after U3 if U3 has a
> value AND any of the others has a value, otherwise not. Then, if V3 has
> a value and any of the other later cells has a value, there should be
> another semi-colon.  Etc. etc.  In the last case, a semi-colon should
> follow W3 only if there's a value in X3.
> 
> I've tried a bunch of formulas and the closest I've come is the following:
> 
> =A13&IF(NOT(ISBLANK(A13))AND(NOT(ISBLANK(B13)))OR(NOT(ISBLANK(C13)))OR(NOT(I
> SBLANK(D13))),";","")&B13&IF(NOT(ISBLANK(B13))AND(NOT(ISBLANK(C13)))OR(NOT(I
> SBLANK(D13))),";","")&C13&IF(NOT(ISBLANK(C13))AND(NOT(ISBLANK(D13))),";","")
> &D13
> 
> But that clearly doesn't work.  Note I'm working in a test sheet and am
> using different cells.  This formula leaves leading semi-colons under a
> number of situations and double semi-colons under others. I'm not
> entirely sure CASE would work any better here though.
> 
> Anyone want to help out, great.  But it's a pretty specialized
> situation, so I understand if not.
> 
> Carl
> 
> On 5/16/13 3:02 AM, Tom Davies wrote:
> > Hi :)
> > WoooHooo!!  Nicely done! :)  Is this whole thread solved now?
> > COngrats of so!
> > Regards from
> > Tom :)
> > 
> > --
> > --
> > *From:* Carl Paulsen 
> > *To:* users@global.libreoffice.org
> > *Sent:* Thursday, 16 May 2013, 1:44
> > *Subject:* Re: [libreoffice-users] "Case" function equivalent in Calc
> > 
> > At long last I got this to work.  Syntax is "ISBLANK" and not
> > "ISEMPTY"
> > - aaa.  My Filemaker days are getting in my way.  Replace
> > all "isempty" below with "ISBLANK" and it works perfectly now.
> > 
> > Carl
> > 
> > On 5/15/13 6:38 PM, Carl Paulsen wrote:
> > > So in the absence of a Case function, here's what I've done so
> > 
> > far as
> > 
> > > a calculated solution.  Note that the data I want to concatenate
> > 
> > is in
> > 
> > > cells U3, V3, W3, and X3.  In Y3, I put the following:
> > > 
> > > =U3 & IF(NOT(isempty(U3)),";","") & V3 &
> > 
> > IF(NOT(isempty(V3)),";","") &
> > 
> > > W3 & IF(NOT(isempty(W3)),";","") & X3
> > > 
> > > The idea is that I put together U3, a semicolon if U3 isn't
> > 
> > empty (and
> > 
> > > nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a
> > > semicolon if W3 isn't empty, and X3.  If any of the cells is empty,
> > > nothing will be added until the next cell that has data.
> > > 
> > > Unfortunately, I'm getting a #NAME? error.  I'm assuming some
> > 
> > kind of
> > 
> > > syntax error.  Any words of wisdom?
> > > 
> > > Thanks a ton all.
> > > Carl
> > > 
> > > On 5/15/13 5:13 PM, Dan Lewis wrote:
> > >> On 05/15/2013 04:16 PM, Carl Paulsen wrote:
> > >>> Anyone know if there is an equivalent to the Filemaker Pro "Case"
> > >>> function?  It's kinda like the "IF" function but is simpler to
> > >>> concatenate multiple conditions. It basically says If
> > 
> > something is
> > 
> > >>> true then do what is specified, if the next thing is, then do
> > 
> > that,
> > 
> > >>> if the next thing is true, do that, etc.
> > >>> 
> > >>> Here's what I need to do.  Take 4 columns and concatenate with a
> > >>> semi-colon between the values, but not string together two
> > >>> semi-colons consecutively.  Like:
> > >>> 
> > >>> PhoneEmailMail -> Phone;Email;Mail
> > >>> Phone  Mail -> Phone;Mail
> > >>> 
> > >>>Mail -> Mail
> > >>>  
> > >>>  EmailMail -> Email;Mail
> > >>> 
> > >>> So semi-colons only occur if there's a value present and not
> > 
> > at all
> > 
> > >>> if there's only one value present.
> > >>> I hope that makes sense and displays correctly.
> > >>> 
> > >>> Carl
> > >>> 
> > >>  I just checked the available functions in Calc. The "Case"
> > >> 
> > >> function does not appear among them. "Case When" is available
> > 
> > in Base
> > 
> > >> database queries though.
> > >> 
> > >> --Dan
> > 
> > Carl Paulsen
> > 
> > 8 Hamilton Street
> > 
> > Dover, NH 03820
> > 
> > (603) 749-2310

-- 
To unsubs

[libreoffice-users] Reminder - Public QA Call Tomorrow at 1300 UTC

2013-05-16 Thread Joel Madero

Hi All,

Just a friendly reminder that we do have a public call tomorrow for QA. The
agenda can be found here:

https://wiki.documentfoundation.org/QA/Meetings/2013/May_17

Also I think we're going to experiment with something new this time, going
to do a google+ hangout along with our normal talkyoo setup. I will call
talkyoo from google hangout, anyone who wants to join on hangout please
make sure to add me on Google+ and let me know you want an invite - I may
do video but not sure yet :)


Warm Regards,
Joel

-- 
*Joel Madero*
LibreOffice QA Volunteer
jmadero@gmail.com

-- 
To unsubscribe e-mail to: users+unsubscr...@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: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Carl Paulsen

Hi Tom.

Well, not quite.  In my particular case this formula worked.  But with 
some off-list input from smarter brains than mine, I realize it wouldn't 
work under many situations.

It turns out the formula would need to change a bit, otherwise what I 
did would leave a trailing semi-colon where column X is blank.  In fact, 
it's a tricky situation b/c a semi-colon is needed after U3 if U3 has a 
value AND any of the others has a value, otherwise not. Then, if V3 has 
a value and any of the other later cells has a value, there should be 
another semi-colon.  Etc. etc.  In the last case, a semi-colon should 
follow W3 only if there's a value in X3.

I've tried a bunch of formulas and the closest I've come is the following:

=A13&IF(NOT(ISBLANK(A13))AND(NOT(ISBLANK(B13)))OR(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),";","")&B13&IF(NOT(ISBLANK(B13))AND(NOT(ISBLANK(C13)))OR(NOT(ISBLANK(D13))),";","")&C13&IF(NOT(ISBLANK(C13))AND(NOT(ISBLANK(D13))),";","")&D13

But that clearly doesn't work.  Note I'm working in a test sheet and am 
using different cells.  This formula leaves leading semi-colons under a 
number of situations and double semi-colons under others. I'm not 
entirely sure CASE would work any better here though.

Anyone want to help out, great.  But it's a pretty specialized 
situation, so I understand if not.

Carl

On 5/16/13 3:02 AM, Tom Davies wrote:

Hi :)
WoooHooo!!  Nicely done! :)  Is this whole thread solved now?  
COngrats of so!

Regards from
Tom :)

*From:* Carl Paulsen 
*To:* users@global.libreoffice.org
*Sent:* Thursday, 16 May 2013, 1:44
*Subject:* Re: [libreoffice-users] "Case" function equivalent in Calc

At long last I got this to work.  Syntax is "ISBLANK" and not
"ISEMPTY"
- aaa.  My Filemaker days are getting in my way.  Replace
all "isempty" below with "ISBLANK" and it works perfectly now.

Carl

On 5/15/13 6:38 PM, Carl Paulsen wrote:
> So in the absence of a Case function, here's what I've done so
far as
> a calculated solution.  Note that the data I want to concatenate
is in
> cells U3, V3, W3, and X3.  In Y3, I put the following:
>
> =U3 & IF(NOT(isempty(U3)),";","") & V3 &
IF(NOT(isempty(V3)),";","") &
> W3 & IF(NOT(isempty(W3)),";","") & X3
>
> The idea is that I put together U3, a semicolon if U3 isn't
empty (and
> nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a
> semicolon if W3 isn't empty, and X3.  If any of the cells is empty,
> nothing will be added until the next cell that has data.
>
> Unfortunately, I'm getting a #NAME? error.  I'm assuming some
kind of
> syntax error.  Any words of wisdom?
>
> Thanks a ton all.
> Carl
>
>
>
> On 5/15/13 5:13 PM, Dan Lewis wrote:
>> On 05/15/2013 04:16 PM, Carl Paulsen wrote:
>>> Anyone know if there is an equivalent to the Filemaker Pro "Case"
>>> function?  It's kinda like the "IF" function but is simpler to
>>> concatenate multiple conditions. It basically says If
something is
>>> true then do what is specified, if the next thing is, then do
that,
>>> if the next thing is true, do that, etc.
>>>
>>> Here's what I need to do.  Take 4 columns and concatenate with a
>>> semi-colon between the values, but not string together two
>>> semi-colons consecutively.  Like:
>>>
>>> PhoneEmailMail -> Phone;Email;Mail
>>> Phone  Mail -> Phone;Mail
>>>Mail -> Mail
>>>  EmailMail -> Email;Mail
>>>
>>> So semi-colons only occur if there's a value present and not
at all
>>> if there's only one value present.
>>> I hope that makes sense and displays correctly.
>>>
>>> Carl
>>  I just checked the available functions in Calc. The "Case"
>> function does not appear among them. "Case When" is available
in Base
>> database queries though.
>>
>> --Dan
>>
>
>

-- 

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310

-- 
To unsubscribe e-mail to: users+unsubscr...@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

--

Carl Paulsen

8 Hamilton Street

Dover, NH 03820

(603) 749-2310

--
To unsubscribe e-mail to: users+unsubscr...@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:

Re: [libreoffice-users] deploy java macro with document

2013-05-16 Thread Andrew Douglas Pitonyak


On 05/16/2013 03:03 AM, Vieri wrote:

--- On Wed, 5/15/13, Andrew Douglas Pitonyak  wrote:


If you do make this work, I am interested to hear about it.

Hi,

It actually works but unpacking/repacking the zip file with your jar isn't enough. You 
will get a "general I/O error".
After unzipping the odt archive and placing my .jar package within 
/Scripts/java/MYMACRO/ I then had to edit the META-INF\manifest.xml and 
set:

  
  

Then zip it up and rename it.

Vieri



Thank you, I really appreciate the update!

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@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] computer & network pictures

2013-05-16 Thread Kracked_P_P---webmaster


On 05/16/2013 05:49 AM, HdV wrote:

On 2013-05-16 09:11:03 Mihamina Rakotomandimby wrote:

Hi all,

My collegues asked me to draw a network & server topology.
They would like more "sexy" pictucres than rectangles and circles:

Would you have a Drawing template to have nice "computer & network
pictures"?

Example:
http://www.fr3d.org/blog/wp-content/uploads/2006/10/network-current.png

You can use any picture you want. What I do is add all pictures I like for a
specific topic to a Draw file and add gluepoints to them. From that file I 
select
the image I need and copy it to the file I am working on. If you add the
gluepoints wisely, then you can resize and reposition the image and the
connectors will just follow it. You can even define what direction the
connectors should prefer. To bad Draw won't allow you to do this in a more
elegant way, but for me using template file works OK.

P.S. I would advise you to make your images transparent before copying them to
the template file. That way you can use them on any background in future use.

P.P.S. Search the intenet for Visio stencils or other image collections you
like. I don't have a URL handy right now, but Googling for "Cisco Systems
Corporate Iconography" will point you in the right direction.

HTH

Grx HdV



To be honest, there are a lot of free clipart sites out there that has 
free computer and network related pictures/graphics.  I have not looked 
for these in a few years, but I had to do a project like your image and 
found all I needed on those free clipart sites.






--
To unsubscribe e-mail to: users+unsubscr...@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: inquiry from hungary

2013-05-16 Thread Pedro

Hi

Here is your answer in Hungarian :)

https://help.libreoffice.org/Common/Basic_Fonts/hu

Hope this helps ;)



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

-- 
To unsubscribe e-mail to: users+unsubscr...@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] inquiry from hungary

2013-05-16 Thread marta333

Kérem, mondják meg, hogy lehet beállitani a 12-es alapállapotu betüméretet
14es alapállapotra?

l want to know how can l set up the base letter size 12 to base letter
size 14
so that l should not set up the letter size whenver l start a new
document!

Thanks.

-- 
To unsubscribe e-mail to: users+unsubscr...@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] computer & network pictures

2013-05-16 Thread HdV

On 2013-05-16 09:11:03 Mihamina Rakotomandimby wrote:
> Hi all,
> 
> My collegues asked me to draw a network & server topology.
> They would like more "sexy" pictucres than rectangles and circles:
> 
> Would you have a Drawing template to have nice "computer & network
> pictures"?
> 
> Example:
> http://www.fr3d.org/blog/wp-content/uploads/2006/10/network-current.png

You can use any picture you want. What I do is add all pictures I like for a 
specific topic to a Draw file and add gluepoints to them. From that file I 
select 
the image I need and copy it to the file I am working on. If you add the 
gluepoints wisely, then you can resize and reposition the image and the 
connectors will just follow it. You can even define what direction the 
connectors should prefer. To bad Draw won't allow you to do this in a more 
elegant way, but for me using template file works OK.

P.S. I would advise you to make your images transparent before copying them to 
the template file. That way you can use them on any background in future use.

P.P.S. Search the intenet for Visio stencils or other image collections you 
like. I don't have a URL handy right now, but Googling for "Cisco Systems 
Corporate Iconography" will point you in the right direction.

HTH

Grx HdV

-- 
To unsubscribe e-mail to: users+unsubscr...@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 unprotect readonly parts of a document?

2013-05-16 Thread Tom Davies

Hi :)
@ Alan.  Normally a greyed area like that indicates it is a Table of Contents 
or index or something.  Uusually the right-click menu gives more options such 
as "update ToC".  I'm not sure what has gone wrong with this one.  Hopefully 
others  ... 


@ Anne
Try 
Tools - Options - Internet - "Browser Plugin"
and UNtick the box to prevent ODF documents from opening up in your 
web-browser.  Quite a few people get the plugin for Firefox or whatever, 
thinking it would be great and then regret it

Regards from
Tom :)  





>
> From: anne-ology 
>To: Alan Stern  
>Cc: users@global.libreoffice.org 
>Sent: Thursday, 16 May 2013, 0:18
>Subject: Re: [libreoffice-users] How to unprotect readonly parts of a document?
> 
>
>       When I click on this URL, a HTML document appears based from LO -
>            with only 1 line.
>
>       I can delete, add, ... to this line.
>
>       Hopefully someone else will understand your question and will come
>to your aid -
>           as for me, your question is beyond me.
>
>       BTW - attachments are not allowed on this list  ;-)
>
>
>
>On Wed, May 15, 2013 at 3:13 PM, Alan Stern wrote:
>
>On Wed, 15 May 2013, Alan Stern wrote:
>>
>> > I'm having trouble with LibreOffice 3.6.  A file I was given contains
>> > regions that are readonly, and I can't figure out how to unprotect them
>> > in order to edit them.
>> >
>> > The usual advice in the archives is to use the Format -> Sections menu
>> > option.  That doesn't work here; the Sections line in the Format menu
>> > is grayed out.  Other advice is to save the file in .odt format and
>> > then open the result.  That doesn't work either.
>> >
>> > Attached to this email is a very short document (in .odt format)
>> > exhibiting the problem.  It's just one line of text saying:
>> >
>> >       Normal (9) Normal again.
>> >
>> > The "(9)" region shows up in gray and can't be edited.  Can anybody
>> > help?
>>
>> Evidently this mailing list doesn't like attachments.  I have stored
>> the demo document at:
>>
>>        http://www.rowland.harvard.edu/~stern/readonly-demo.odt
>>
>> Alan Stern
>>
>>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@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
>
>
>
-- 
To unsubscribe e-mail to: users+unsubscr...@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] deploy java macro with document

2013-05-16 Thread Vieri



--- On Thu, 5/16/13, Tom Davies  wrote:

> I thought macros were automatically embedded in documents?
> 
> How do you get a macro in a document or do you have to send
> it as a separate file?  

It depends on the macro type.
Basic, beanshell are directly embedded,
The other types aren't (at least that's the case for Java).

Vieri


-- 
To unsubscribe e-mail to: users+unsubscr...@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] computer & network pictures

2013-05-16 Thread Gabriel Risterucci

You can always browse openclipart.org; I believe you would find the nice
pics you need here.

-- 
Cley Faye
http://cleyfaye.net


2013/5/16 Mihamina Rakotomandimby 

> Hi all,
>
> My collegues asked me to draw a network & server topology.
> They would like more "sexy" pictucres than rectangles and circles:
>
> Would you have a Drawing template to have nice "computer & network
> pictures"?
>
> Example:
> http://www.fr3d.org/blog/wp-**content/uploads/2006/10/**
> network-current.png
>
>
>
> --
> RMA.
>
> --
> To unsubscribe e-mail to: 
> users+unsubscribe@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
>

-- 
To unsubscribe e-mail to: users+unsubscr...@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] computer & network pictures

2013-05-16 Thread Mihamina Rakotomandimby


Hi all,

My collegues asked me to draw a network & server topology.
They would like more "sexy" pictucres than rectangles and circles:

Would you have a Drawing template to have nice "computer & network 
pictures"?


Example:
http://www.fr3d.org/blog/wp-content/uploads/2006/10/network-current.png



--
RMA.

--
To unsubscribe e-mail to: users+unsubscr...@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] deploy java macro with document

2013-05-16 Thread Vieri


--- On Wed, 5/15/13, Andrew Douglas Pitonyak  wrote:

> If you do make this work, I am interested to hear about it.

Hi,

It actually works but unpacking/repacking the zip file with your jar isn't 
enough. You will get a "general I/O error".
After unzipping the odt archive and placing my .jar package within 
/Scripts/java/MYMACRO/ I then had to edit the META-INF\manifest.xml and 
set:

 
 

Then zip it up and rename it.

Vieri


-- 
To unsubscribe e-mail to: users+unsubscr...@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

[Solved]?? Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread Tom Davies

Hi :)
WoooHooo!!  Nicely done! :)  Is this whole thread solved now?  COngrats of so!
Regards from 
Tom :)  






>
> From: Carl Paulsen 
>To: users@global.libreoffice.org 
>Sent: Thursday, 16 May 2013, 1:44
>Subject: Re: [libreoffice-users] "Case" function equivalent in Calc
> 
>
>At long last I got this to work.  Syntax is "ISBLANK" and not "ISEMPTY" 
>- aaa.  My Filemaker days are getting in my way.  Replace 
>all "isempty" below with "ISBLANK" and it works perfectly now.
>
>Carl
>
>
>On 5/15/13 6:38 PM, Carl Paulsen wrote:
>> So in the absence of a Case function, here's what I've done so far as 
>> a calculated solution.  Note that the data I want to concatenate is in 
>> cells U3, V3, W3, and X3.  In Y3, I put the following:
>>
>> =U3 & IF(NOT(isempty(U3)),";","") & V3 & IF(NOT(isempty(V3)),";","") & 
>> W3 & IF(NOT(isempty(W3)),";","") & X3
>>
>> The idea is that I put together U3, a semicolon if U3 isn't empty (and 
>> nothing if it is), V3 and a semicolon if V3 isn't empty, W3 and a 
>> semicolon if W3 isn't empty, and X3.  If any of the cells is empty, 
>> nothing will be added until the next cell that has data.
>>
>> Unfortunately, I'm getting a #NAME? error.  I'm assuming some kind of 
>> syntax error.  Any words of wisdom?
>>
>> Thanks a ton all.
>> Carl
>>
>>
>>
>> On 5/15/13 5:13 PM, Dan Lewis wrote:
>>> On 05/15/2013 04:16 PM, Carl Paulsen wrote:
 Anyone know if there is an equivalent to the Filemaker Pro "Case" 
 function?  It's kinda like the "IF" function but is simpler to 
 concatenate multiple conditions. It basically says If something is 
 true then do what is specified, if the next thing is, then do that, 
 if the next thing is true, do that, etc.

 Here's what I need to do.  Take 4 columns and concatenate with a 
 semi-colon between the values, but not string together two 
 semi-colons consecutively.  Like:

 Phone     Email     Mail -> Phone;Email;Mail
 Phone                  Mail -> Phone;Mail
                            Mail -> Mail
               Email    Mail -> Email;Mail

 So semi-colons only occur if there's a value present and not at all 
 if there's only one value present.
 I hope that makes sense and displays correctly.

 Carl
>>>      I just checked the available functions in Calc. The "Case" 
>>> function does not appear among them. "Case When" is available in Base 
>>> database queries though.
>>>
>>> --Dan
>>>
>>
>>
>
>-- 
>
>Carl Paulsen
>
>8 Hamilton Street
>
>Dover, NH 03820
>
>(603) 749-2310
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@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
>
>
>
-- 
To unsubscribe e-mail to: users+unsubscr...@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: file recovery

Re: [libreoffice-users] Re: file recovery

Re: [libreoffice-users] Re: Uninstall LibreOffice 4.0.2

[libreoffice-users] Re: file recovery

Re: [libreoffice-users] Uninstall LibreOffice 4.0.2

[libreoffice-users] Re: Uninstall LibreOffice 4.0.2

Re: [libreoffice-users] Uninstall LibreOffice 4.0.2

[libreoffice-users] Uninstall LibreOffice 4.0.2

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

[libreoffice-users] Reminder - Public QA Call Tomorrow at 1300 UTC

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

Re: [libreoffice-users] deploy java macro with document

Re: [libreoffice-users] computer & network pictures

[libreoffice-users] Re: inquiry from hungary

[libreoffice-users] inquiry from hungary

Re: [libreoffice-users] computer & network pictures

Re: [libreoffice-users] How to unprotect readonly parts of a document?

Re: [libreoffice-users] deploy java macro with document

Re: [libreoffice-users] computer & network pictures

[libreoffice-users] computer & network pictures

Re: [libreoffice-users] deploy java macro with document

[Solved]?? Re: [libreoffice-users] "Case" function equivalent in Calc

24 matches

Site Navigation

Mail list logo

Footer information