Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Stefan Weigel
Hi, Am 30.11.2014 um 23:37 schrieb Carlo Strata: ... so this is an Excel problem because it behaves differently with respect to its own help...?!!! Not really. Excel states, that you must apply the first parameter and you must not leave it empty. (It´s required.) If you follow this,

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Stefan Weigel
Hi, Am 30.11.2014 um 23:37 schrieb Carlo Strata: ... so this is an Excel problem because it behaves differently with respect to its own help...?!!! Not really. Excel states, that you must apply the first parameter and you must not leave it empty. (It´s required.) If you follow this,

Re: [libreoffice-users] PDF export checking whether the file is locked (opened) by another program before starting exporting over it

2014-12-01 Thread Rob Jasper
Op 1 dec. 2014, om 06:35 heeft Brian Barker het volgende geschreven: At 19:56 30/11/2014 +0100, Jaroslaw Staniek wrote: On Sunday, 30 November 2014, Brian Barker wrote: At 13:55 30/11/2014 +0100, Jaroslaw Staniek wrote: Google for acrobat reader file locking and you'd notice that this

Re: [libreoffice-users] PDF export checking whether the file is locked (opened) by another program before starting exporting over it

2014-12-01 Thread Brian Barker
At 11:55 01/12/2014 +0100, Rob Jasper wrote: Op 1 dec. 2014, om 06:35 heeft Brian Barker het volgende geschreven: At 19:56 30/11/2014 +0100, Jaroslaw Staniek wrote: On Sunday, 30 November 2014, Brian Barker wrote: At 13:55 30/11/2014 +0100, Jaroslaw Staniek wrote: Google for acrobat reader

Re: [libreoffice-users] PDF export checking whether the file is locked (opened) by another program before starting exporting over it

2014-12-01 Thread Jaroslaw Staniek
I am grateful for the discussion, I think many bits are now clear. I see the topic is drifting to level of personal preferences: whether you're used to locking and if the locking is natural (because you deal with it for years) or superficial and usability burden. I am acknowledging tools like the

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Carlo Strata
From what I remember, in Excel the formula does not yield an error or something like that, but a numerical result!!! The original formula is (I translate the functions from Italian to English named ones):

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Brian Barker
At 14:04 01/12/2014 +0100, Carlo Strata wrote: I suppose (!) there is an addition to the two behaviors (Err:511 and #N/A, respectively from LO and Excel) described by Luuk: Excel evaluate only the part it calculate and not the entire formula or lose the internal #N/A in calculations. I cannot

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Stefan Weigel
Am 01.12.2014 um 14:58 schrieb Brian Barker: Excel needs comma separators instead of semi-colons, of course very much depending on locale, of course ;-) Stefan :-D -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Carlo Strata
Thank you very much Brian. Have a nice evening, Carlo ing. Carlo Strata - via Botticelli 1/4 30031 Dolo - VE Italia - Italy - tel. +39.041.822.0665 cell. +39.347.85.69.824 Skype carlo.strata Google carlo.strata.69 - carlo.str...@tiscali.it PEC: carlo.str...@ingpec.eu Il 01/12/2014 14:58,

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Brian Barker
At 17:00 01/12/2014 +0100, Stefan Weigel wrote: Am 01.12.2014 um 14:58 schrieb Brian Barker: Excel needs comma separators instead of semi-colons, of course very much depending on locale, of course ;-) Aaargh! Sorry: I hadn't realised that - though it's obvious when you think about it ...

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Luuk
On 1-12-2014 14:58, Brian Barker wrote: At 14:04 01/12/2014 +0100, Carlo Strata wrote: I suppose (!) there is an addition to the two behaviors (Err:511 and #N/A, respectively from LO and Excel) described by Luuk: Excel evaluate only the part it calculate and not the entire formula or lose the

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Luuk
On 1-12-2014 09:18, Stefan Weigel wrote: Hi, Am 30.11.2014 um 23:37 schrieb Carlo Strata: ... so this is an Excel problem because it behaves differently with respect to its own help...?!!! Not really. Excel states, that you must apply the first parameter and you must not leave it empty.

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Luuk
On 1-12-2014 20:14, Luuk wrote: On 1-12-2014 14:58, Brian Barker wrote: At 14:04 01/12/2014 +0100, Carlo Strata wrote: I suppose (!) there is an addition to the two behaviors (Err:511 and #N/A, respectively from LO and Excel) described by Luuk: Excel evaluate only the part it calculate and not

[libreoffice-users] Linux Users - Sphinx use

2014-12-01 Thread charles meyer
I hope it's OK to post about Linux here? If not, my apologies. I was curious if any Linux users have used the Sphinx application and how well it's worked? Thanks so much. Charles. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Linux Users - Sphinx use

2014-12-01 Thread Andrew Douglas Pitonyak
Can you be more specific? Numerous packages named Sphinx, could not begin to guess which. Perhaps I am simply not well informed. My best guess is this: https://pypi.python.org/pypi/sphinxcontrib-libreoffice On 12/01/2014 11:19 PM, charles meyer wrote: I hope it's OK to post about Linux