Re: [libreoffice-users] how to do a if in calc?

[T. R. Valentine]

On 10 March 2016 at 18:10, Beau Thompson  wrote:
> Hi All,
> I have a question about a drop don box and a if
> k2 an k3 have names in it  k2 Beau k3 john
> m2 is drop down  $data.$K$2:$K$3
>
> I like to do a if in o2 that would be what ever name is not selected in m2
> thanks Beau

=IF(M2=K2,K3,K2)

-- 
T. R. Valentine
A rich heart may be under a poor coat.

-- 
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] Highlighting Writer Text in 5.0.4 crashes Writer.

[Steve Edmonds]

Found a repository for 5.0.5 on OBS, problem seems to have gone so must 
have been a problem with Opensuse provided 5.0.4.

Thanks for the checking and getting me to a stable version.
Steve

On 2016-03-11 07:40, Steve Edmonds wrote:

5.0.5 on win7 is ok.
Possibly this is a bug in the Opensuse version I am running.

Tried all the OpenGL and hardware acceleration settings to no avail.
Steve

On 2016-03-10 16:44, nasrin khaksar wrote:

hi.
what stable version did you use before?
i did not test 5.0.4 but tested 4.3.7, 5.0.5 and worked great for me.
i use 4.4.6 did you tested and also 5.0.5?
i heard from many users that 5.0.5 is great and stable.

On 3/10/16, Steve Edmonds  wrote:

Hi.
Just updated to 5.0.4 in Opensuse and find highlighting (selecting) 
text

in my manuals consistently crashes Writer, I can't practically edit my
manuals in 5.0.4.
Downgrading to 4.3 fixes the problem.

Not sure if this is Opensuse specific. Linked document is large (but I
couldn't select text to delete it).
Appreciate if someone could test before filing a bug report.
To repeat, go to chapter 4.9. Highlight from the previous paragraph to
the word after the heading.

es.
   4.9  RS-485 AND MODbus CONNECTION
RS

For me Writer crashes every time.
Thanks, Steve

File is too big for nabble (19MB), linked here.
https://drive.google.com/file/d/0ByFEFUXgJhGkTDY0UHB4OUpBRjQ/view?usp=sharing 




--
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

[libreoffice-users] how to do a if in calc?

[Beau Thompson]

Hi All,
I have a question about a drop don box and a if
k2 an k3 have names in it  k2 Beau k3 john
m2 is drop down  $data.$K$2:$K$3

I like to do a if in o2 that would be what ever name is not selected in m2
thanks Beau

--
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] LO 5.1 Presentation can't find system browser on OSX 10.11

[Marc Grober]

Aha - you nailed it on the head.  The person who built the document used
an internal file:// refernce, nd the inaccurate message popped up. When
I added a second link with the correct web URL it worked fine (though
strangely enough I could find no menu choice to allow editing the URL
that was previously there!)

On 3/10/16 12:08 AM, Stephan Bergmann wrote:
> On 03/10/2016 01:28 AM, Marc Grober wrote:
>> Clicking on a live link in a LO 5.1 Presentation results in the
>> following error message:
>>
>> "LibreOffice could not find a web browser on your system. Please check
>> your Desktop Preferences or install a web browser (for example, Firefox)
>> in the default location requested during the browser installation."
>>
>> In fact Firefox is set as default and doing a command click on a link
>> from Writer works fine.
>
> From looking at the code (shell/source/unix/exec/shellexec.cxx,
> sfx2/source/appl/openuriexternally.cxx) that error message can
> misleadingly be presented also when a browser /is/ found, but
> something else goes wrong when trying to open the hyperlink with the
> browser.
>
> Marc, what is the hyerlink's exact URL?  (In Impress, select the
> hyperlink---which is easier to do with the keyboard than with the
> mouse---, select "Insert > Hyperlink," and from the dialog that pops
> open copy the content of the "Target" field.  Alternatively, you can
> mail me the presentation file, and I'll have a look.)



-- 
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] Highlighting Writer Text in 5.0.4 crashes Writer.

[Steve Edmonds]

5.0.5 on win7 is ok.
Possibly this is a bug in the Opensuse version I am running.

Tried all the OpenGL and hardware acceleration settings to no avail.
Steve

On 2016-03-10 16:44, nasrin khaksar wrote:

hi.
what stable version did you use before?
i did not test 5.0.4 but tested 4.3.7, 5.0.5 and worked great for me.
i use 4.4.6 did you tested and also 5.0.5?
i heard from many users that 5.0.5 is great and stable.

On 3/10/16, Steve Edmonds  wrote:

Hi.
Just updated to 5.0.4 in Opensuse and find highlighting (selecting) text
in my manuals consistently crashes Writer, I can't practically edit my
manuals in 5.0.4.
Downgrading to 4.3 fixes the problem.

Not sure if this is Opensuse specific. Linked document is large (but I
couldn't select text to delete it).
Appreciate if someone could test before filing a bug report.
To repeat, go to chapter 4.9. Highlight from the previous paragraph to
the word after the heading.

es.
   4.9  RS-485 AND MODbus CONNECTION
RS

For me Writer crashes every time.
Thanks, Steve

File is too big for nabble (19MB), linked here.
https://drive.google.com/file/d/0ByFEFUXgJhGkTDY0UHB4OUpBRjQ/view?usp=sharing


--
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] Highlighting Writer Text in 5.0.4 crashes Writer.

[Steve Edmonds]

Thanks for the checking, I use 4.3.7 as the stable.
Steve

On 2016-03-10 16:44, nasrin khaksar wrote:

hi.
what stable version did you use before?
i did not test 5.0.4 but tested 4.3.7, 5.0.5 and worked great for me.
i use 4.4.6 did you tested and also 5.0.5?
i heard from many users that 5.0.5 is great and stable.

On 3/10/16, Steve Edmonds  wrote:

Hi.
Just updated to 5.0.4 in Opensuse and find highlighting (selecting) text
in my manuals consistently crashes Writer, I can't practically edit my
manuals in 5.0.4.
Downgrading to 4.3 fixes the problem.

Not sure if this is Opensuse specific. Linked document is large (but I
couldn't select text to delete it).
Appreciate if someone could test before filing a bug report.
To repeat, go to chapter 4.9. Highlight from the previous paragraph to
the word after the heading.

es.
   4.9  RS-485 AND MODbus CONNECTION
RS

For me Writer crashes every time.
Thanks, Steve

File is too big for nabble (19MB), linked here.
https://drive.google.com/file/d/0ByFEFUXgJhGkTDY0UHB4OUpBRjQ/view?usp=sharing


--
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

[libreoffice-users] Re: File->Exit LibreOffice doens't work in 5.1.1 on Windows

[Urmas]

"Dries Feys":


Met vriendelijke groeten, Salutations distinguées, Kind Regards,


Please add "-- " (two hyphens and a space) in the beginning of your 
signature.

It is called "a tearline" and it makes your messages more easily to handle.



--
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] File->Exit LibreOffice doens't work in 5.1.1 on Windows

[Gilles Gravier]

Ah. Just saw. Duplicate of
https://bugs.documentfoundation.org/show_bug.cgi?id=92516 :)

Cheers,
Gilles.

On Thu, Mar 10, 2016 at 2:32 PM, Dries Feys  wrote:
> Works fine with me (win7 x64, Version: 5.1.1.3)
>
> Met vriendelijke groeten, Salutations distinguées, Kind Regards,
>
> DRIES FEYS
> CORPORATE SERVICES • Specialist Software Developer
>
> TVH GROUP NV
> Brabantstraat 15 • BE-8790 WAREGEM
> T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
> Watch our company movies on www.tvh.tv
>
>
>
> Business Innovation
> through
> Information Technology
> bi2t.tvh.com
>
>
> On 10 March 2016 at 14:19, Gilles Gravier  wrote:
>> Hi!
>> (resent now that I have subscribed)
>>
>> Strange bug. I launch 5.1.1.3 on Windows (7x64)... For example
>> LibreOffice Write. It opens. I click on File->Exit LibreOffice ...
>> NOTHING HAPPENS.
>>
>> If I click on the red cross top right corner of the window, it properly
>> closes it.
>> If I use the "Ctrl-Q" shortcut, it properly closes it.
>> Just the file->Exit LibreOffice menu doesn't.
>>
>> Doesn't happen on Ubuntu Linux... here closing method works.
>>
>> Do you get that behavior too?
>>
>> Thanks,
>> Gilles
>>
>> --
>> 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
>
> --
>
>
>  DISCLAIMER 
>
> http://www.tvh.com/glob/en/email-disclaimer
>
> "This message is delivered to all addressees subject to the conditions
> set forth in the attached disclaimer, which is an integral part of this
> message."



-- 
Gilles Gravier - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026

-- 
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] File->Exit LibreOffice doens't work in 5.1.1 on Windows

[Gilles Gravier]

Hi!

Strange bug. I launch 5.1.1.3 on Windows (7x64)... For example LibreOffice
Write. It opens. I click on File->Exit LibreOffice ... NOTHING HAPPENS.

If I click on the red cross top right corner of the window, it properly
closes it.
If I use the "Ctrl-Q" shortcut, it properly closes it.
Just the file->Exit LibreOffice menu doesn't.

Doesn't happen on Ubuntu Linux... here closing method works.

Do you get that behavior too?

-- 
Gilles Gravier - gil...@gravier.org
GSM : +33618347147 and +41794728437
Skype : ggravier | PGP Key : 0x8DE6D026


-- 
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] File->Exit LibreOffice doens't work in 5.1.1 on Windows

[Dries Feys]

Works fine with me (win7 x64, Version: 5.1.1.3)

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com
Watch our company movies on www.tvh.tv



Business Innovation
through
Information Technology
bi2t.tvh.com


On 10 March 2016 at 14:19, Gilles Gravier  wrote:
> Hi!
> (resent now that I have subscribed)
>
> Strange bug. I launch 5.1.1.3 on Windows (7x64)... For example
> LibreOffice Write. It opens. I click on File->Exit LibreOffice ...
> NOTHING HAPPENS.
>
> If I click on the red cross top right corner of the window, it properly
> closes it.
> If I use the "Ctrl-Q" shortcut, it properly closes it.
> Just the file->Exit LibreOffice menu doesn't.
>
> Doesn't happen on Ubuntu Linux... here closing method works.
>
> Do you get that behavior too?
>
> Thanks,
> Gilles
>
> --
> 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

-- 


 DISCLAIMER 

http://www.tvh.com/glob/en/email-disclaimer

"This message is delivered to all addressees subject to the conditions
set forth in the attached disclaimer, which is an integral part of this
message."

-- 
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] File->Exit LibreOffice doens't work in 5.1.1 on Windows

[Gilles Gravier]

Hi!
(resent now that I have subscribed)

Strange bug. I launch 5.1.1.3 on Windows (7x64)... For example
LibreOffice Write. It opens. I click on File->Exit LibreOffice ...
NOTHING HAPPENS.

If I click on the red cross top right corner of the window, it properly
closes it.
If I use the "Ctrl-Q" shortcut, it properly closes it.
Just the file->Exit LibreOffice menu doesn't.

Doesn't happen on Ubuntu Linux... here closing method works.

Do you get that behavior too?

Thanks,
Gilles

-- 
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] LO 5.1 Presentation can't find system browser on OSX 10.11

[Piet van Oostrum]

Stephan Bergmann wrote:

 > On 03/10/2016 01:28 AM, Marc Grober wrote:
 > > Clicking on a live link in a LO 5.1 Presentation results in the
 > > following error message:
 > >
 > > "LibreOffice could not find a web browser on your system. Please check
 > > your Desktop Preferences or install a web browser (for example, Firefox)
 > > in the default location requested during the browser installation."
 > >
 > > In fact Firefox is set as default and doing a command click on a link
 > > from Writer works fine.
 > 
 >  From looking at the code (shell/source/unix/exec/shellexec.cxx, 
 > sfx2/source/appl/openuriexternally.cxx) that error message can 
 > misleadingly be presented also when a browser /is/ found, but something 
 > else goes wrong when trying to open the hyperlink with the browser.

This happens, for example with a link like "htp://www", i.e. a wrong 
protocol identifier.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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: Calc as a Flat File Database

[Alex Thurgood]

Le 09/03/2016 10:43, Ian Whitfield a écrit :


Hi Ian,

> Database and re-designing your Forms etc. This has happened repeatedly
> with the embedded engine and also with the MySQL engine.

I'm sorry, but crashing and subsequent corruption of an ODB file that
links to a mysql database does not lead to dataloss of the linked mysql
db, or at least it shouldn't if you know how to manage your mysql db. At
worst, you can mess up your forms, lose your query definitions and
report setups, but that's about it. Yes, with embedded hsqldb, dataloss
is a known problem, but not with an external database.


> As far as I'm concerned there is basic unstability in Base itself which
> makes it unusable on a day-to-day basis!!
> This was why I was wanting to try another route.

> I tried Kexi but it is still to early in its development to be reliable.
> I wanted to try Glom but it is unavailable on my OpSys (PClinuxOS).
> So I was hoping to try a simpler option of Calc plus a Form.

Why not separate out your forms from the ODB file if you are concerned
about the stability of the ODB file itself ? It is perfectly possible,
you can still link to a mysql db and you won't have the issues of
screwing up your ODB just because the power goes off, or your network
goes down, or some other life-event that seems to befall computer users
on a daily basis.


You could look at Dabo (a python based UI interface to mysql dbs), or
webforms using Ruby, Rails, or PHP. They all require some kind of effort
to obtain a "usable" solution. Even the MySQL UI admin tool has a simple
Form view mode, where you can enter data in what looks like a form -
sophisticated it isn't, but it works !


Alex


-- 
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] LO 5.1 Presentation can't find system browser on OSX 10.11

[Stephan Bergmann]

On 03/10/2016 01:28 AM, Marc Grober wrote:

Clicking on a live link in a LO 5.1 Presentation results in the
following error message:

"LibreOffice could not find a web browser on your system. Please check
your Desktop Preferences or install a web browser (for example, Firefox)
in the default location requested during the browser installation."

In fact Firefox is set as default and doing a command click on a link
from Writer works fine.


From looking at the code (shell/source/unix/exec/shellexec.cxx, 
sfx2/source/appl/openuriexternally.cxx) that error message can 
misleadingly be presented also when a browser /is/ found, but something 
else goes wrong when trying to open the hyperlink with the browser.


Marc, what is the hyerlink's exact URL?  (In Impress, select the 
hyperlink---which is easier to do with the keyboard than with the 
mouse---, select "Insert > Hyperlink," and from the dialog that pops 
open copy the content of the "Target" field.  Alternatively, you can 
mail me the presentation file, and I'll have a look.)


--
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