[libreoffice-users] Identical footnote settings work in one file but not another

[Ken Heard]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I am using LO 4.3.3.2 with Debian wheezy.  In two odt documents I have
added a footnote.  In one case the number of the footnote at the
bottom of the page has a period after the number, but in the other
case there is no period there even though the settings for the
‘footnote‘ and ‘numbering 1’ styles in both cases are identical.

The settings which seem to me to matter for the ‘footnote’ style are:

Indents and spacing: Before text: 0.50 cm; After text: 0.00;
 First line -0.50 cm.

Outline and numbering:
Outline level: ‘Outline level 1’ or ‘Body text’, it does
not seem to matter in either case. If
‘body text' is used the bottom line shows
‘Numbering 1 : Level 1’.  If Outline
level 1’ is used, ‘Outline 1’ is added
to the bottom line.

Numbering style: ‘numbering 1’

The settings which seem to me to matter for the ‘numbering 1’ style are:

‘Position’ for all levels, the following settings on the right:
Tab stop
0.00 cm
Left
0.00 cm
0.50 cm

‘Options’ for all levels although only the first lever is used:
Number: 1, 2, 3, ...
Character Style: None
Show sublevels: 1
Separator before: none
Separator after: . (period)
Start at: 1

Something is obviously wrong.  Should I file a bug report?

Regards, Ken








-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.19 (GNU/Linux)

iEYEARECAAYFAlanTMMACgkQlNlJzOkJmTc/tgCfUYRds99AkNJLtXKH86uiQSEF
R3kAmwd3rvX2ZrnFRF1fwHsacv/+RJY2
=vaKi
-END PGP SIGNATURE-

-- 
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: question about the best version of libreoffice - MY God is better!

[Tom Davies]

Hi :)
Phil, i know you think you probably think you are just an atheist and
acting reasonably but this topic didn't arise in all the years that we
have seen Christian messages in various people's signatures.  The
discussion only arose after the only Islamic quote in all these years.

This has happened at a time when it's popular to attack Muslims for
their faith, and for the stereotypes pushed out by mainstream media to
demonise and vilify Muslims.

Ridiculing religions in general might seem reasonable but choosing to
do so right now, only after the first Islamic quote in a signature and
not in any of the previous several years of Christian quotes (and
hundreds of them) is Islamaphobic.

It has been good to see people on this mailing-list increasingly make
a stand against the increasing level of Islamaphobia in this thread -
even people who don't understand or don't agree with Islam.  In my
opinion standing with someone who seems to be being given a hard-time
by 'the mainstream' is FAR more impressive than just taking cheap
opportunistic pot-shots that are

LibreOffice and the OpenDocument Format are making a stand against the
mainstream and although the tide may be beginning to turn for us i am
sure we can all remember moments where mainstream-people have done or
said things, without even realising it, that are extremely pro-MSO and
their ever-changing, unreliable formats.


Please can we drop this topic and get on with the questions at hand?
Regards from
Tom :)



On 26 January 2016 at 04:37, Philip Rhoades  wrote:
> Virgil,
>
>
> On 2016-01-26 07:24, Virgil Arrington wrote:
>>
>> On 01/25/2016 01:40 PM, jomali wrote:
>>>
>>> Please note that the original message by Nasrin was on a topic germane to
>>> this list. One member with an excessively tender sore spot objected to
>>> something in Nasrin's signature that expressed his sincerely held faith.
>>> There was no intent on Nasrin's part to proselytize or to demean
>>> another's
>>> faith, as Phil's diatribe does.
>>
>>
>> I tend to agree about signature lines. They can contain all kinds of
>> things having nothing to do with LO. Sometimes they're funny;
>
>
>
> That would be fine . .
>
>
>> other
>> times they are informative about the writer. Phil's signature line
>> includes his address in Australia, which is informative, but has
>> nothing to do with LO. Nasrin's signature line includes a a few lines
>> about his Muslim faith,
>
>
>
> Another person with low general knowledge . . again I am not surprised . .
>
>
>> also informative but also having nothing to do
>> with LO.
>>
>> I pretty much ignore signature lines, and I can't possibly imagine
>> being offended by one, regardless of what it might say.
>>
>> a Christian who loves Muslims
>
>
>
> And there we have it - another person who has an agenda - they can't
> criticise someone else for proselytising their superstitious nonsense
> because they have their own superstitious nonsense . . a person who "loves"
> someone else but does not even know that the person they "love" is a "she"
> and not a "he" . . clueless . .
>
> P.
>
> --
> Philip Rhoades
>
> PO Box 896
> Cowra  NSW  2794
> Australia
> E-mail:  p...@pricom.com.au
>
> --
> 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] Identical footnote settings work in one file but not another

[Brian Barker]

At 10:30 27/01/2016 +0700, Ken Heard wrote:
One setting I could not find was to change the footnote anchor. Is 
it possible to use a symbol such as an asterisk instead of a number 
as the anchor?


Yes: select Character (and insert the required character) instead of 
Automatic in the Insert Footnote/Endnote dialogue.


Finally in Tools -> Footnotes I could not understand the purpose of 
the character styles for the text and footnote areas.


These set the style of the footnote anchor and the footnote number in 
the footnote itself.


Since however the defaults for these are "Footnote Anchor" and 
"Footnote Characters" respectively, perhaps I don't need to.


You can use these styles, or change these styles, or substitute others.

I trust this helps.

Brian Barker


--
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: difference between Excel and Calc

[Andreas Säger]

Am 26.01.2016 um 13:53 schrieb Ian McCarthy:
> Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've
> fallen over an incompatibility
> as spread sheet will be used by both tools is there a switch I can use.
>  The problem
> =CELL("filename",A1) in LO returns
> 'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15
> 
> where as in Excel the returned data is different
>  cant easily paste the excel result here but the terminal filename is in
> square brackets
> is there a way I can either spot which program I'm using and therefore
> switch the detection of the sheet name
> 
> using  LibreOffice 5.0.4.2
> 

=LEFT(CELL("FileName");8)="'file://"
returns TRUE in Calc and FALSE in Excel


-- 
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] is there a GOAL_SEEK function somewhere?

[Andreas Säger]

Am 26.01.2016 um 11:47 schrieb Larry Evans:
> I've checked that the value returned by the YIELD function:
> 
> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
> 
> can be gotten by using [Tools>Goal Seek...] and the PV function:
> 
> https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV
> 
> Is there some way I could use a something like a GOAL_SEEK function
> to implement my own version of YIELD?  IOW, without having to go
> through the answering of the [Goal Seek] dialog window requesting
> Formual cell, Target Value, and Variable cell?
> 
> TIA.
> 
> -regards,
> Larry
> 
> 

menu:Tools>Goal Seek ?


-- 
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: Help! Lost all file permissions after upgrading Libre Office in Win 7

[Andy12345]

Dear Stuart,

Thank you for this very prompt reply.

Tools -> Options -> Paths  entry for "Documents" is blank   and I can't 
edit it. (The others point to ok-looking appdata/roaming directories for 
the correct user)

For  My Documents,  Explorer -> Properties -> Security for all users / 
groups  is the same ie all users are set to Full Control, with 
everything Allowed except Special Permissions. However, again same for 
everyone, all the Allow are grey-ed out; I can't recall if this is 
normal or not. I can edit Deny, but I can't edit allow.

Hope this is diagnostic!

Andy

On 26/01/2016 12:55, V Stuart Foote [via Document Foundation Mail 
Archive] wrote:
> Launch as your normal user and have a look at the LibreOffice main 
> menu Tools -> Options -> Paths panel.  Is it pointing to expected 
> folder? Or, to folders of the administrators group member user you 
> used for the installation?
>
> If it is point to your user, but you can't edit--you may need to 
> change folder permissions using the OS Windows Explorer -> Properties 
> -> Security for the folder and take back ownership.  If pointing to 
> the admin account--you should be able to edit in the LibreOffice Paths 
> panel--or simply exit LibreOffice and delete/rename your corrupt user 
> profile.
>
>
>
> 
> If you reply to this email, your message will be added to the 
> discussion below:
> http://nabble.documentfoundation.org/Help-Lost-all-file-permissions-after-upgrading-Libre-Office-in-Win-7-tp4173055p4173058.html
>  
>
> To unsubscribe from Help! Lost all file permissions after upgrading 
> Libre Office in Win 7, click here 
> .
> NAML 
> 
>  
>





--
View this message in context: 
http://nabble.documentfoundation.org/Help-Lost-all-file-permissions-after-upgrading-Libre-Office-in-Win-7-tp4173055p4173071.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] difference between Excel and Calc

[Brian Barker]

At 12:53 26/01/2016 +, Ian McCarthy wrote:
I'm porting a spread sheet from Excel to LibreOffice Calc and I've 
fallen over an incompatibility as spread sheet will be used by both 
tools is there a switch I can use. The problem =CELL("filename",A1) 
in LO returns 'file:///C:/Users/Ian 
Mac/Desktop/Accounts15-16.xls'#$Sep 15 whereas in Excel the returned 
data is different can't easily paste the excel result here but the 
terminal filename is in square brackets is there a way I can either 
spot which program I'm using and therefore switch the detection of 
the sheet name


Here's a thought: perhaps you don't need to. How are you intending to 
use the file name?


o If it is just for human perusal, either in the spreadsheet editing 
screen or printed output, it may not matter that the formats vary 
slightly. Humans are good at coping with such variations.


o If you need the file name or some part of it in a precise form for 
further processing in the spreadsheet, you may well already be 
editing it with formulae into the form you require. In that case, it 
should be fairly straightforward to construct a single formula that 
will extract the exact form you require regardless of which format is 
delivered by the CELL() function. There is always the IF() function ...


I trust this helps.

Brian Barker


--
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: question about the best version of libreoffice - MY God is better!

[Virgil Arrington]

Chill, Phil.

I can't believe the level of antagonism coming through your keyboard. 
I'm "clueless" for not knowing Nasrin's gender? Harsh, man. While I have 
many contacts with Muslims from around the world, I had never heard the 
name Nasrin before and recalled nothing in her emails that betrayed her 
gender.


If choosing to love people, regardless of my knowledge of their gender, 
is an agenda, then I suppose I have an agenda. I'm genuinely surprised 
that my decision to love a Muslim I've never met upsets you so much that 
you feel it necessary to accuse me of having "low general knowledge" and 
being "clueless." Where does such a miserable world view come from?


I won't use the LO list to advance my views of Christianity. I use other 
lists for that, where it is admittedly more appropriate. But, I reserve 
the right to come to the defense of another who has been unfairly 
attacked for what she happened to put in her signature line. (I'll 
blindly accept your assertion that Nasrin is female.)  I felt your 
attack unwarranted and unworthy of a gentlemen, regardless of your 
religious views.


Sorry, Tom, I had to respond to Phil, and I felt I had to do it on list.

I'll let it go, now.

Virgil


On 01/25/2016 11:37 PM, Philip Rhoades wrote:

Virgil,


On 2016-01-26 07:24, Virgil Arrington wrote:

On 01/25/2016 01:40 PM, jomali wrote:
Please note that the original message by Nasrin was on a topic 
germane to

this list. One member with an excessively tender sore spot objected to
something in Nasrin's signature that expressed his sincerely held 
faith.
There was no intent on Nasrin's part to proselytize or to demean 
another's

faith, as Phil's diatribe does.


I tend to agree about signature lines. They can contain all kinds of
things having nothing to do with LO. Sometimes they're funny;



That would be fine . .



other
times they are informative about the writer. Phil's signature line
includes his address in Australia, which is informative, but has
nothing to do with LO. Nasrin's signature line includes a a few lines
about his Muslim faith,



Another person with low general knowledge . . again I am not surprised 
. .




also informative but also having nothing to do
with LO.

I pretty much ignore signature lines, and I can't possibly imagine
being offended by one, regardless of what it might say.

a Christian who loves Muslims



And there we have it - another person who has an agenda - they can't 
criticise someone else for proselytising their superstitious nonsense 
because they have their own superstitious nonsense . . a person who 
"loves" someone else but does not even know that the person they 
"love" is a "she" and not a "he" . . clueless . .


P.




--
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: Help! Lost all file permissions after upgrading Libre Office in Win 7

[Andy12345]

Some more information . If I try to open an .odt file in File Explorer 
with Libre Office, I get "locked for editing by unknown user." I can 
however open the file with Wordpad (though this is no use for editing.)  
I can save a new file to one of the problem directories with Wordpad, 
and also re-open it with wordpad. However, if I try to open the new file 
with Libro Office, I can't.

Hope this makes more sense to someone than it does to me!

Andy

On 26/01/2016 12:55, V Stuart Foote [via Document Foundation Mail 
Archive] wrote:
> Launch as your normal user and have a look at the LibreOffice main 
> menu Tools -> Options -> Paths panel.  Is it pointing to expected 
> folder? Or, to folders of the administrators group member user you 
> used for the installation?
>
> If it is point to your user, but you can't edit--you may need to 
> change folder permissions using the OS Windows Explorer -> Properties 
> -> Security for the folder and take back ownership.  If pointing to 
> the admin account--you should be able to edit in the LibreOffice Paths 
> panel--or simply exit LibreOffice and delete/rename your corrupt user 
> profile.
>
>
>
> 
> If you reply to this email, your message will be added to the 
> discussion below:
> http://nabble.documentfoundation.org/Help-Lost-all-file-permissions-after-upgrading-Libre-Office-in-Win-7-tp4173055p4173058.html
>  
>
> To unsubscribe from Help! Lost all file permissions after upgrading 
> Libre Office in Win 7, click here 
> .
> NAML 
> 
>  
>





--
View this message in context: 
http://nabble.documentfoundation.org/Help-Lost-all-file-permissions-after-upgrading-Libre-Office-in-Win-7-tp4173055p4173079.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: [calc] is there a GOAL_SEEK function somewhere?

[Larry Evans]

On 01/26/2016 07:18 AM, Andreas Säger wrote:
> Am 26.01.2016 um 11:47 schrieb Larry Evans:
>> I've checked that the value returned by the YIELD function:
>>
>> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
>>
>> can be gotten by using [Tools>Goal Seek...] and the PV function:
>>
>> https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV
>>
>> Is there some way I could use a something like a GOAL_SEEK function
>> to implement my own version of YIELD?  IOW, without having to go
>> through the answering of the [Goal Seek] dialog window requesting
>> Formual cell, Target Value, and Variable cell?
>>
>> TIA.
>>
>> -regards,
>> Larry
>>
>>
> 
> menu:Tools>Goal Seek ?
> 
> 
As mentioned in my message, I've used that from the UI.
What I want is to call some function, GOAL_SEEK, from within
a macro.  Sorry I wasn't clearer.  I'm guessing
YIELD *must* be implemented using some such function, and
I was hoping a macro could somehow get access to that function
even though there's no GOAL_SEEK function in the published
set of functions.

Hope that's clearer.

-regards,
Larry



-- 
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: question about the best version of libreoffice - MY God is better!

[Paul Steyn]

Well said, Tom.

On Tue, 26 Jan 2016 12:29:54 +
Tom Davies  wrote:

> Hi :)
> Phil, i know you think you probably think you are just an atheist and
> acting reasonably but this topic didn't arise in all the years that we
> have seen Christian messages in various people's signatures.  The
> discussion only arose after the only Islamic quote in all these years.
> 
> This has happened at a time when it's popular to attack Muslims for
> their faith, and for the stereotypes pushed out by mainstream media to
> demonise and vilify Muslims.
> 
> Ridiculing religions in general might seem reasonable but choosing to
> do so right now, only after the first Islamic quote in a signature and
> not in any of the previous several years of Christian quotes (and
> hundreds of them) is Islamaphobic.
> 
> It has been good to see people on this mailing-list increasingly make
> a stand against the increasing level of Islamaphobia in this thread -
> even people who don't understand or don't agree with Islam.  In my
> opinion standing with someone who seems to be being given a hard-time
> by 'the mainstream' is FAR more impressive than just taking cheap
> opportunistic pot-shots that are
> 
> LibreOffice and the OpenDocument Format are making a stand against the
> mainstream and although the tide may be beginning to turn for us i am
> sure we can all remember moments where mainstream-people have done or
> said things, without even realising it, that are extremely pro-MSO and
> their ever-changing, unreliable formats.
> 
> 
> Please can we drop this topic and get on with the questions at hand?
> Regards from
> Tom :)
> 
> 
> 
> On 26 January 2016 at 04:37, Philip Rhoades 
> wrote:
> > Virgil,
> >
> >
> > On 2016-01-26 07:24, Virgil Arrington wrote:  
> >>
> >> On 01/25/2016 01:40 PM, jomali wrote:  
> >>>
> >>> Please note that the original message by Nasrin was on a topic
> >>> germane to this list. One member with an excessively tender sore
> >>> spot objected to something in Nasrin's signature that expressed
> >>> his sincerely held faith. There was no intent on Nasrin's part to
> >>> proselytize or to demean another's
> >>> faith, as Phil's diatribe does.  
> >>
> >>
> >> I tend to agree about signature lines. They can contain all kinds
> >> of things having nothing to do with LO. Sometimes they're funny;  
> >
> >
> >
> > That would be fine . .
> >
> >  
> >> other
> >> times they are informative about the writer. Phil's signature line
> >> includes his address in Australia, which is informative, but has
> >> nothing to do with LO. Nasrin's signature line includes a a few
> >> lines about his Muslim faith,  
> >
> >
> >
> > Another person with low general knowledge . . again I am not
> > surprised . .
> >
> >  
> >> also informative but also having nothing to do
> >> with LO.
> >>
> >> I pretty much ignore signature lines, and I can't possibly imagine
> >> being offended by one, regardless of what it might say.
> >>
> >> a Christian who loves Muslims  
> >
> >
> >
> > And there we have it - another person who has an agenda - they can't
> > criticise someone else for proselytising their superstitious
> > nonsense because they have their own superstitious nonsense . . a
> > person who "loves" someone else but does not even know that the
> > person they "love" is a "she" and not a "he" . . clueless . .
> >
> > P.
> >
> > --
> > Philip Rhoades
> >
> > PO Box 896
> > Cowra  NSW  2794
> > Australia
> > E-mail:  p...@pricom.com.au
> >
> > --
> > 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: question about the best version of libreoffice - MY God is better!

[Philip Rhoades]

Virgil,


On 2016-01-27 01:19, Virgil Arrington wrote:

Chill, Phil.

I can't believe the level of antagonism coming through your keyboard.
I'm "clueless" for not knowing Nasrin's gender? Harsh, man. While I
have many contacts with Muslims from around the world, I had never
heard the name Nasrin before and recalled nothing in her emails that
betrayed her gender.

If choosing to love people, regardless of my knowledge of their
gender, is an agenda, then I suppose I have an agenda. I'm genuinely
surprised that my decision to love a Muslim I've never met upsets you
so much that you feel it necessary to accuse me of having "low general
knowledge" and being "clueless." Where does such a miserable world
view come from?



Just observation - you believe in sky fairies and supporting others who 
are attacked for proselytising their sky fairies because an attack on 
one sky fairy is an attack on all sky fairies . .




I won't use the LO list to advance my views of Christianity.



Good - and others should not use it to advance their superstitions 
either.




I use
other lists for that, where it is admittedly more appropriate. But, I
reserve the right to come to the defense of another who has been
unfairly attacked for what she happened to put in her signature line.
(I'll blindly accept your assertion that Nasrin is female.)  I felt
your attack unwarranted and unworthy of a gentlemen, regardless of
your religious views.



Well if you weren't clueless (which is not consistent with you believing 
in fairy stories) you would have realised by now that I don't have any 
and that I don't approve of others proselytising on this list . .


P.


Sorry, Tom, I had to respond to Phil, and I felt I had to do it on 
list.


I'll let it go, now.

Virgil


On 01/25/2016 11:37 PM, Philip Rhoades wrote:

Virgil,


On 2016-01-26 07:24, Virgil Arrington wrote:

On 01/25/2016 01:40 PM, jomali wrote:
Please note that the original message by Nasrin was on a topic 
germane to
this list. One member with an excessively tender sore spot objected 
to
something in Nasrin's signature that expressed his sincerely held 
faith.
There was no intent on Nasrin's part to proselytize or to demean 
another's

faith, as Phil's diatribe does.


I tend to agree about signature lines. They can contain all kinds of
things having nothing to do with LO. Sometimes they're funny;



That would be fine . .



other
times they are informative about the writer. Phil's signature line
includes his address in Australia, which is informative, but has
nothing to do with LO. Nasrin's signature line includes a a few lines
about his Muslim faith,



Another person with low general knowledge . . again I am not surprised 
. .




also informative but also having nothing to do
with LO.

I pretty much ignore signature lines, and I can't possibly imagine
being offended by one, regardless of what it might say.

a Christian who loves Muslims



And there we have it - another person who has an agenda - they can't 
criticise someone else for proselytising their superstitious nonsense 
because they have their own superstitious nonsense . . a person who 
"loves" someone else but does not even know that the person they 
"love" is a "she" and not a "he" . . clueless . .


P.



--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au

--
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: Help! Lost all file permissions after upgrading Libre Office in Win 7

[V Stuart Foote]

Andy,

Have you cleared your user profile and allowed it to rebuild?

https://wiki.documentfoundation.org/UserProfile

That really is the first step.

Otherwise, seems like a problem with the registered temp folder.

Here is a clip of a correctly configured Tools -> Options -> Paths panel for
LO 5.1.0 (would be same on Vista, 7, 8, 8.1 and 10).


 

If clearing your user profile does not resolve--Next step is to do a
complete uninstallation, and clean install. 

1. Remove (or rename)  all of the LO User profile's, e.g.
C:\Users\\AppData\Roaming\LibreOffice
2. Login as an administrator's group member, and  uninstall LibreOffice.
3. Clean the Windows registry: 
   HKEY_LOCAL_MACHINE\SOFTWARE\The Document Foundation
   HKEY_CURRENT_USER\SOFTWARE\The Document Foundation  (for all users) 
4. launch a command prompt, change directory to your download, and with CLI
issue command "msiexec.exe /i LibreOffice_4.4.7.2_Win_x86.msi /L*v
installLog.txt"  This will log the installation should there still be
issues.
5. Log out and back in as your user. Launch LibreOffice to check  if that
resolved the path issues.

Stuart




--
View this message in context: 
http://nabble.documentfoundation.org/Help-Lost-all-file-permissions-after-upgrading-Libre-Office-in-Win-7-tp4173055p4173085.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: [calc] is there a GOAL_SEEK function somewhere?

[Larry Evans]

On 01/26/2016 08:42 AM, Larry Evans wrote:
> On 01/26/2016 07:18 AM, Andreas Säger wrote:
>> Am 26.01.2016 um 11:47 schrieb Larry Evans:
>>> I've checked that the value returned by the YIELD function:
>>>
>>> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD
>>>
>>> can be gotten by using [Tools>Goal Seek...] and the PV function:
>>>
>>> https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV
>>>
>>> Is there some way I could use a something like a GOAL_SEEK function
>>> to implement my own version of YIELD?  IOW, without having to go
>>> through the answering of the [Goal Seek] dialog window requesting
>>> Formual cell, Target Value, and Variable cell?
>>>
>>> TIA.
>>>
>>> -regards,
>>> Larry
>>>
>>>
>>
>> menu:Tools>Goal Seek ?
>>
>>
> As mentioned in my message, I've used that from the UI.
> What I want is to call some function, GOAL_SEEK, from within
> a macro.  Sorry I wasn't clearer.  I'm guessing
> YIELD *must* be implemented using some such function, and
> I was hoping a macro could somehow get access to that function
> even though there's no GOAL_SEEK function in the published
> set of functions.
> 
> Hope that's clearer.
> 
> -regards,
> Larry
> 

I want something along the lines of:

Sub GSeek()
With Worksheets("Sheet1")
.Range("H18").GoalSeek _
Goal:=.Range("H32").Value, _
ChangingCell:=.Range("G18")
End With
End Sub

shown here:

http://stackoverflow.com/questions/18139322/goal-seek-macro-with-goal-as-a-formula

Would that code work in libreoffice?





-- 
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: question about the best version of libreoffice - MY God is better!

[Philip Rhoades]

Tom,


On 2016-01-26 23:29, Tom Davies wrote:

Hi :)
Phil, i know you think you probably think you are just an atheist and
acting reasonably but this topic didn't arise in all the years that we
have seen Christian messages in various people's signatures.  The
discussion only arose after the only Islamic quote in all these years.



It certainly was not the first - but it should be the last.



This has happened at a time when it's popular to attack Muslims for
their faith, and for the stereotypes pushed out by mainstream media to
demonise and vilify Muslims.

Ridiculing religions in general might seem reasonable but choosing to
do so right now, only after the first Islamic quote in a signature and
not in any of the previous several years of Christian quotes (and
hundreds of them) is Islamaphobic.



No, superstitionphobic . .



It has been good to see people on this mailing-list increasingly make
a stand against the increasing level of Islamaphobia in this thread -
even people who don't understand or don't agree with Islam.  In my
opinion standing with someone who seems to be being given a hard-time
by 'the mainstream' is FAR more impressive than just taking cheap
opportunistic pot-shots that are



People should not be proselytising on this list - period.  To hijack my 
intention as "Islamaphobia" is childish . .




LibreOffice and the OpenDocument Format are making a stand against the
mainstream and although the tide may be beginning to turn for us i am
sure we can all remember moments where mainstream-people have done or
said things, without even realising it, that are extremely pro-MSO and
their ever-changing, unreliable formats.



OK, but I don't what that has to do with the legitimacy of people 
proselytising on a technical list.




Please can we drop this topic and get on with the questions at hand?



Sure - but I will still respond as I originally did if I come across 
more proselytising (by anyone) . . it is inappropriate and offensive and 
should not be condoned or encouraged.


P.



Regards from
Tom :)



On 26 January 2016 at 04:37, Philip Rhoades  wrote:

Virgil,


On 2016-01-26 07:24, Virgil Arrington wrote:


On 01/25/2016 01:40 PM, jomali wrote:


Please note that the original message by Nasrin was on a topic 
germane to
this list. One member with an excessively tender sore spot objected 
to
something in Nasrin's signature that expressed his sincerely held 
faith.

There was no intent on Nasrin's part to proselytize or to demean
another's
faith, as Phil's diatribe does.



I tend to agree about signature lines. They can contain all kinds of
things having nothing to do with LO. Sometimes they're funny;




That would be fine . .



other
times they are informative about the writer. Phil's signature line
includes his address in Australia, which is informative, but has
nothing to do with LO. Nasrin's signature line includes a a few lines
about his Muslim faith,




Another person with low general knowledge . . again I am not surprised 
. .




also informative but also having nothing to do
with LO.

I pretty much ignore signature lines, and I can't possibly imagine
being offended by one, regardless of what it might say.

a Christian who loves Muslims




And there we have it - another person who has an agenda - they can't
criticise someone else for proselytising their superstitious nonsense
because they have their own superstitious nonsense . . a person who 
"loves"
someone else but does not even know that the person they "love" is a 
"she"

and not a "he" . . clueless . .

P.

--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au

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



--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au

--
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] is there a GOAL_SEEK function somewhere?

[Larry Evans]

On 01/26/2016 09:02 AM, Larry Evans wrote:
> On 01/26/2016 08:42 AM, Larry Evans wrote:
>> On 01/26/2016 07:18 AM, Andreas Säger wrote:
>>> Am 26.01.2016 um 11:47 schrieb Larry Evans:
 I've checked that the value returned by the YIELD function:

 https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD

 can be gotten by using [Tools>Goal Seek...] and the PV function:

 https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV

 Is there some way I could use a something like a GOAL_SEEK function
 to implement my own version of YIELD?  IOW, without having to go
 through the answering of the [Goal Seek] dialog window requesting
 Formual cell, Target Value, and Variable cell?

 TIA.

 -regards,
 Larry


>>>
>>> menu:Tools>Goal Seek ?
>>>
>>>
>> As mentioned in my message, I've used that from the UI.
>> What I want is to call some function, GOAL_SEEK, from within
>> a macro.  Sorry I wasn't clearer.  I'm guessing
>> YIELD *must* be implemented using some such function, and
>> I was hoping a macro could somehow get access to that function
>> even though there's no GOAL_SEEK function in the published
>> set of functions.
>>
>> Hope that's clearer.
>>
>> -regards,
>> Larry
>>
> 
> I want something along the lines of:
> 
> Sub GSeek()
> With Worksheets("Sheet1")
> .Range("H18").GoalSeek _
> Goal:=.Range("H32").Value, _
> ChangingCell:=.Range("G18")
> End With
> End Sub
> 
> shown here:
> 
> http://stackoverflow.com/questions/18139322/goal-seek-macro-with-goal-as-a-formula
> 
> Would that code work in libreoffice?
> 
> 
Some one else had a similar question:

https://forum.openoffice.org/en/forum/viewtopic.php?f=45=4331=0

I'm studying that to see if that will help.
However, apparently, the code in the above GSeek won't work in
libreoffice :(




-- 
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: question about the best version of libreoffice - MY God is better!

[Tom Davies]

Hi :)
I feel really bad now, that you seem to be forced into defending
yourself.  And Virgil needing to defend himself doubtless with others
on all sides feeling more and more pushed into defending their views
or beliefs.

A belief-system that defines all other's beliefs as being
"superstitions" sounds alarmingly intolerant to me.  Anyone who thinks
that everyone who disagrees with their own belief is "clueless" seems
to me to be scarily arrogant, to me.  But that is just my own personal
belief and i'd probably defend individuals who felt the need to
postulate alternatives, in a discussion (but preferably not on this
mailing list because, as we all seem to agree, this is probably not
the place for it).

As someone, who i believe was amazing, once said "An eye for an eye
and the whole world goes blind".

Regards from
Tom :)



On 26 January 2016 at 14:57, Philip Rhoades  wrote:
> Virgil,
>
>
> On 2016-01-27 01:19, Virgil Arrington wrote:
>>
>> Chill, Phil.
>>
>> I can't believe the level of antagonism coming through your keyboard.
>> I'm "clueless" for not knowing Nasrin's gender? Harsh, man. While I
>> have many contacts with Muslims from around the world, I had never
>> heard the name Nasrin before and recalled nothing in her emails that
>> betrayed her gender.
>>
>> If choosing to love people, regardless of my knowledge of their
>> gender, is an agenda, then I suppose I have an agenda. I'm genuinely
>> surprised that my decision to love a Muslim I've never met upsets you
>> so much that you feel it necessary to accuse me of having "low general
>> knowledge" and being "clueless." Where does such a miserable world
>> view come from?
>
>
>
> Just observation - you believe in sky fairies and supporting others who are
> attacked for proselytising their sky fairies because an attack on one sky
> fairy is an attack on all sky fairies . .
>
>
>> I won't use the LO list to advance my views of Christianity.
>
>
>
> Good - and others should not use it to advance their superstitions either.
>
>
>> I use
>> other lists for that, where it is admittedly more appropriate. But, I
>> reserve the right to come to the defense of another who has been
>> unfairly attacked for what she happened to put in her signature line.
>> (I'll blindly accept your assertion that Nasrin is female.)  I felt
>> your attack unwarranted and unworthy of a gentlemen, regardless of
>> your religious views.
>
>
>
> Well if you weren't clueless (which is not consistent with you believing in
> fairy stories) you would have realised by now that I don't have any and that
> I don't approve of others proselytising on this list . .
>
> P.
>
>
>
>> Sorry, Tom, I had to respond to Phil, and I felt I had to do it on list.
>>
>> I'll let it go, now.
>>
>> Virgil
>>
>>
>> On 01/25/2016 11:37 PM, Philip Rhoades wrote:
>>>
>>> Virgil,
>>>
>>>
>>> On 2016-01-26 07:24, Virgil Arrington wrote:

 On 01/25/2016 01:40 PM, jomali wrote:
>
> Please note that the original message by Nasrin was on a topic germane
> to
> this list. One member with an excessively tender sore spot objected to
> something in Nasrin's signature that expressed his sincerely held
> faith.
> There was no intent on Nasrin's part to proselytize or to demean
> another's
> faith, as Phil's diatribe does.


 I tend to agree about signature lines. They can contain all kinds of
 things having nothing to do with LO. Sometimes they're funny;
>>>
>>>
>>>
>>> That would be fine . .
>>>
>>>
 other
 times they are informative about the writer. Phil's signature line
 includes his address in Australia, which is informative, but has
 nothing to do with LO. Nasrin's signature line includes a a few lines
 about his Muslim faith,
>>>
>>>
>>>
>>> Another person with low general knowledge . . again I am not surprised .
>>> .
>>>
>>>
 also informative but also having nothing to do
 with LO.

 I pretty much ignore signature lines, and I can't possibly imagine
 being offended by one, regardless of what it might say.

 a Christian who loves Muslims
>>>
>>>
>>>
>>> And there we have it - another person who has an agenda - they can't
>>> criticise someone else for proselytising their superstitious nonsense
>>> because they have their own superstitious nonsense . . a person who "loves"
>>> someone else but does not even know that the person they "love" is a "she"
>>> and not a "he" . . clueless . .
>>>
>>> P.
>>>
>
> --
> Philip Rhoades
>
> PO Box 896
> Cowra  NSW  2794
> Australia
> E-mail:  p...@pricom.com.au
>
> --
> 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: question about the best version of libreoffice - MY God is better!

[Felmon Davis]

On Wed, 27 Jan 2016, Philip Rhoades wrote:

Sure - but I will still respond as I originally did if I come across more 
proselytising (by anyone) . . it is inappropriate and offensive and should 
not be condoned or encouraged.


by one standard definition of 'proselytize'/'proselytise' your last 
several posts are guilty of it.


I thought 'signatures' were generally off-topic. though I'd keep my 
mouth shut, I admit though I'd be wrought up if someone advocated 
Microsoft Word! but a 'blessing' from 'sky fairies'? some must have a 
terrible time in flu season with all the 'God bless you!' in the air!


anyway, I agree: stop the proselytizing!

(well, except in 'signatures' where it doesn't count).

f.



On 26 January 2016 at 04:37, Philip Rhoades  wrote:



Virgil,


On 2016-01-26 07:24, Virgil Arrington wrote:


On 01/25/2016 01:40 PM, jomali wrote:


Please note that the original message by Nasrin was on a topic germane 
to

this list. One member with an excessively tender sore spot objected to
something in Nasrin's signature that expressed his sincerely held faith.
There was no intent on Nasrin's part to proselytize or to demean
another's
faith, as Phil's diatribe does.



I tend to agree about signature lines. They can contain all kinds of
things having nothing to do with LO. Sometimes they're funny;




That would be fine . .



other
times they are informative about the writer. Phil's signature line
includes his address in Australia, which is informative, but has
nothing to do with LO. Nasrin's signature line includes a a few lines
about his Muslim faith,




Another person with low general knowledge . . again I am not surprised . .



also informative but also having nothing to do
with LO.

I pretty much ignore signature lines, and I can't possibly imagine
being offended by one, regardless of what it might say.

a Christian who loves Muslims




And there we have it - another person who has an agenda - they can't
criticise someone else for proselytising their superstitious nonsense
because they have their own superstitious nonsense . . a person who 
"loves"

someone else but does not even know that the person they "love" is a "she"
and not a "he" . . clueless . .

P.

--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au

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






--
Felmon Davis

--
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: question about the best version of libreoffice - MY God is better!

[Philip Rhoades]

Virgil,


On 2016-01-27 01:19, Virgil Arrington wrote:

Chill, Phil.

I can't believe the level of antagonism coming through your keyboard.
I'm "clueless" for not knowing Nasrin's gender? Harsh, man. While I
have many contacts with Muslims from around the world, I had never
heard the name Nasrin before and recalled nothing in her emails that
betrayed her gender.

If choosing to love people, regardless of my knowledge of their
gender, is an agenda, then I suppose I have an agenda. I'm genuinely
surprised that my decision to love a Muslim I've never met upsets you
so much that you feel it necessary to accuse me of having "low general
knowledge" and being "clueless." Where does such a miserable world
view come from?



Just observation - you believe in sky fairies and supporting others who 
are attacked for proselytising their sky fairies because an attack on 
one sky fairy is an attack on all sky fairies . .




I won't use the LO list to advance my views of Christianity.



Good - and others should not use it to advance their superstitions 
either.




I use
other lists for that, where it is admittedly more appropriate. But, I
reserve the right to come to the defense of another who has been
unfairly attacked for what she happened to put in her signature line.
(I'll blindly accept your assertion that Nasrin is female.)  I felt
your attack unwarranted and unworthy of a gentlemen, regardless of
your religious views.



Well if you weren't clueless (which is not consistent with you believing 
in fairy stories) you would have realised by now that I don't have any 
and that I don't approve of others proselytising on this list . .


P.


Sorry, Tom, I had to respond to Phil, and I felt I had to do it on 
list.


I'll let it go, now.

Virgil


On 01/25/2016 11:37 PM, Philip Rhoades wrote:

Virgil,


On 2016-01-26 07:24, Virgil Arrington wrote:

On 01/25/2016 01:40 PM, jomali wrote:
Please note that the original message by Nasrin was on a topic 
germane to
this list. One member with an excessively tender sore spot objected 
to
something in Nasrin's signature that expressed his sincerely held 
faith.
There was no intent on Nasrin's part to proselytize or to demean 
another's

faith, as Phil's diatribe does.


I tend to agree about signature lines. They can contain all kinds of
things having nothing to do with LO. Sometimes they're funny;



That would be fine . .



other
times they are informative about the writer. Phil's signature line
includes his address in Australia, which is informative, but has
nothing to do with LO. Nasrin's signature line includes a a few lines
about his Muslim faith,



Another person with low general knowledge . . again I am not surprised 
. .




also informative but also having nothing to do
with LO.

I pretty much ignore signature lines, and I can't possibly imagine
being offended by one, regardless of what it might say.

a Christian who loves Muslims



And there we have it - another person who has an agenda - they can't 
criticise someone else for proselytising their superstitious nonsense 
because they have their own superstitious nonsense . . a person who 
"loves" someone else but does not even know that the person they 
"love" is a "she" and not a "he" . . clueless . .


P.



--
Philip Rhoades

PO Box 896
Cowra NSW   2794
Australia
Web:  http://philiprhoades.org
E-mail:  p...@philiprhoades.org

--
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: LibreOffice Base and MySQL

[Ian "Witty" Whitfield]

On 01/24/2016 10:04 AM, Hank Alper wrote:

Hi Ian,
I frequently import Calc Spreadsheets into my MySQL database using
phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
import.Specifically, it offers a Browse option. Locate the Calc file you
wish to import.by browsing to it in your file system.
It also asks for the type of file you wish to import. One of the options is
ODF spreadsheet.That's the format of Calc, isn't it ?
No need to convert to CSV File.
Hank


Thanks Hank

But no luck!! I tried to import my ODS Spreadsheet file from LibraOffice 
and got the following error...


/"You attempted to load file with unsupported compression 
(application/zip).
Either support for it is not implemented or disabled by your 
configuration"./


The file is NOT compressed or Zipped and opens perfectly in LO Calc!!

So still a problem - but I appreciate the pointer.

Best regards

IanW
Pretoria RSA

--
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: LibreOffice Base and MySQL

[Jaroslaw Staniek]

On 26 January 2016 at 12:42, Ian "Witty" Whitfield  wrote:

> On 01/24/2016 10:04 AM, Hank Alper wrote:
>
>> Hi Ian,
>> I frequently import Calc Spreadsheets into my MySQL database using
>> phpMyAdmin.. My version of
>> ​​
>> phpMyAdmin asks to locate the File you wish to
>> import.Specifically, it offers a Browse option. Locate the Calc file you
>> wish to import.by browsing to it in your file system.
>> It also asks for the type of file you wish to import. One of the options
>> is
>> ODF spreadsheet.That's the format of Calc, isn't it ?
>> No need to convert to CSV File.
>> Hank
>>
>> Thanks Hank
>
> But no luck!! I tried to import my ODS Spreadsheet file from LibraOffice
> and got the following error...
>
> /"You attempted to load file with unsupported compression
> (application/zip).
> Either support for it is not implemented or disabled by your
> configuration"./
>
> The file is NOT compressed or Zipped and opens perfectly in LO Calc!!
>
> So still a problem - but I appreciate the pointer.
>

​ODF files are compressed archives of XML files (that's why they, like
MSOOXML, are not the best containers for larger data, but this is off
topic)​. I guess you're getting the error because the web server handling
the Admin isn't fully set up. The devil is in the detail...

Hank's suggestion looks good -- apps supporting ODS would be much better
than underspecified CSV, so such
​
phpMyAdmin's import may work. However there's possible issue that such
tools need to be supplied with _range information_ of data that has to be
imported from ODS.
In absence of such, the only is guessing or heuristics, like we have in
Kexi's ODS->Table importer, by the way. If there are more possible ranges,
manual intervention may be needed, such as moving data to a simpler,
separate sheet, and that would degrade the whole automation. Sure, for
one-time import this isn't a big deal.

I am writing this to note that we sometimes lack specialized but popular
standards for exchanging data or schema.


> Best regards
>
> IanW
> Pretoria RSA
>
>
> --
> 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
>



-- 
regards, Jaroslaw Staniek

KDE:
: A world-wide network of software engineers, artists, writers, translators
: and facilitators committed to Free Software development - http://kde.org
Calligra Suite:
: A graphic art and office suite - http://calligra.org
Kexi:
: A visual database apps builder - http://calligra.org/kexi
Qt Certified Specialist:
: http://www.linkedin.com/in/jstaniek

-- 
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: LibreOffice Base and MySQL

[Alexander Thurgood]

Le 24/01/2016 09:04, Hank Alper a écrit :

Hi Hank,


> Hi Ian,
> I frequently import Calc Spreadsheets into my MySQL database using
> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
> import.Specifically, it offers a Browse option. Locate the Calc file you
> wish to import.by browsing to it in your file system.
> It also asks for the type of file you wish to import. One of the options is
> ODF spreadsheet.That's the format of Calc, isn't it ?
> No need to convert to CSV File.

The "rub" in this useful solution is that it does indeed depend on the
version of phpmyadmin supplied with your distro.

Ian is using PCLinuxOS or PCLOS, and judging from his reply to you, it
would appear that the version supplied with that distro doesn't have the
import from ODS functionality.


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

[libreoffice-users] COUNTIF() with more than one conditions

[csanyipal]

Hi,

in a range I have characters: "H", "K", "Sze", "Cs", "P" so so in each cell
there is just one of these characters.

I want to count howmany cells are in a range that contains either of these
characters.

Can I do this in a more elegant way than by using this function bellow?

=COUNTIF(C152:C228;"=H")+COUNTIF(C153:C229;"=K")+COUNTIF(C154:C230;"=Sze")+COUNTIF(C155:C231;"=Cs")+COUNTIF(C156:C232;"=P")




-
Best Regards from
Pál
--
View this message in context: 
http://nabble.documentfoundation.org/COUNTIF-with-more-than-one-conditions-tp4173143.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] Re: question about the best version of libreoffice - MY God is better!

[Bob Holtzman]

On Tue, Jan 26, 2016 at 12:29:54PM +, Tom Davies wrote:
> Hi :)
> Phil, i know you think you probably think you are just an atheist and
> acting reasonably but this topic didn't arise in all the years that we
> have seen Christian messages in various people's signatures.  The
> discussion only arose after the only Islamic quote in all these years.
> 
> This has happened at a time when it's popular to attack Muslims for
> their faith, and for the stereotypes pushed out by mainstream media to
> demonise and vilify Muslims.

I haven't seen anything in the mainstream media that demonises and
vilifys Muslims. Only in right wing rags. Cite(s) please.

-- 
Bob Holtzman
A man is a man who will fight with a sword or
conquer Mt. Everest in snow. But the bravest of all
owns a '34 Ford and tries for six thousand in low.

-- 
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] Identical footnote settings work in one file but not another

[anne-ology]

   I would suspicion you've uncovered a bug  ;-)



From: Ken Heard 
Date: Tue, Jan 26, 2016 at 4:39 AM
Subject: [libreoffice-users] Identical footnote settings work in one file
but not another
To: LibreOffice Users 


I am using LO 4.3.3.2 with Debian wheezy.  In two odt documents I have
added a footnote.  In one case the number of the footnote at the
bottom of the page has a period after the number, but in the other
case there is no period there even though the settings for the
‘footnote‘ and ‘numbering 1’ styles in both cases are identical.

The settings which seem to me to matter for the ‘footnote’ style are:

Indents and spacing: Before text: 0.50 cm; After text: 0.00;
 First line -0.50 cm.

Outline and numbering:
Outline level: ‘Outline level 1’ or ‘Body text’, it does
not seem to matter in either case. If
‘body text' is used the bottom line shows
‘Numbering 1 : Level 1’.  If Outline
level 1’ is used, ‘Outline 1’ is added
to the bottom line.

Numbering style: ‘numbering 1’

The settings which seem to me to matter for the ‘numbering 1’ style are:

‘Position’ for all levels, the following settings on the right:
Tab stop
0.00 cm
Left
0.00 cm
0.50 cm

‘Options’ for all levels although only the first lever is used:
Number: 1, 2, 3, ...
Character Style: None
Show sublevels: 1
Separator before: none
Separator after: . (period)
Start at: 1

Something is obviously wrong.  Should I file a bug report?

Regards, Ken


This
email has been sent from a virus-free computer protected by Avast.
www.avast.com

<#DDB4FAA8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

-- 
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: LibreOffice Base and MySQL

[Andreas Säger]

Am 24.01.2016 um 09:04 schrieb Hank Alper:
> Hi Ian,
> I frequently import Calc Spreadsheets into my MySQL database using
> phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to
> import.Specifically, it offers a Browse option. Locate the Calc file you
> wish to import.by browsing to it in your file system.
> It also asks for the type of file you wish to import. One of the options is
> ODF spreadsheet.That's the format of Calc, isn't it ?
> No need to convert to CSV File.
> Hank
> 

Open the spreadsheet document. Ensure that your data are organized as a
normalized list where numbers are numbers, dates are dates and times are
times. Quite often and for no reason, Excel sheets are poisoned with
text data which makes them rather useless. If you can not distinguish
the data types in a spreadsheet, there is no hope anyway.

Copy the normalized list of valid data including any header row.
In the Base document which is connected to your MySQLDB click the _icon_
of a target table where you want to append the spreadsheet data and paste.
A wizard pops up where you can map the fields of the clipboard data to
the fields of your database table.

This may raise 3 types of errors:
-- referencial integrity errors
-- not nullable errors
-- wrong data type errors
Each of these error types can be answered with "Cancel" or "Ignore". The
ignore option will try to import as much as possible without raising the
same error again.

Some helpful spreadsheet formulas to test spreadsheet data for consisteency:

> =MAX(LEN(column))[Ctrl+Shift+Enter] returns the max. length of a text column.
> =COUNTBLANK(column) counts blanks.
> =COUNTA(column) counts any values
> =COUNT(column) counts numbers
> =COUNTA(column)=COUNT(column) TRUE if there are only numbers.
> =AND(ROWS(COLUMN)=COUNT(column);COUNTA(column)=COUNT(column) TRUE if there 
> are only numbers and now blanks.
> =MIN/MAX(column) min and max values of a column
> =N(MATCH(value;column;0)) returns 0 if value does not occur in some other 
> table's column (test referencial integrity).
> =COUNTIF(value;same_column)>1 returns TRUE if there are duplicates in the 
> same column.

=MATCH(value ; other_list ; 0) tests referencial integrity against
another table.


-- 
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] COUNTIF() with more than one conditions

[Cley Faye]

What I would do is to add a column, fill it with AND() statement to mark
row to add or not, hide it, then use a COUNTIF() using this column as a
condition.

As far as I know, the COUNTIFS() function should do the job but for some
reason I have difficulties to make it works right now :\ you might want to
look into it.

-- 
Cley Faye
http://cleyfaye.net

2016-01-26 20:20 GMT+01:00 csanyipal :

> Hi,
>
> in a range I have characters: "H", "K", "Sze", "Cs", "P" so so in each cell
> there is just one of these characters.
>
> I want to count howmany cells are in a range that contains either of these
> characters.
>
> Can I do this in a more elegant way than by using this function bellow?
>
>
> =COUNTIF(C152:C228;"=H")+COUNTIF(C153:C229;"=K")+COUNTIF(C154:C230;"=Sze")+COUNTIF(C155:C231;"=Cs")+COUNTIF(C156:C232;"=P")
>
>
>
>
> -
> Best Regards from
> Pál
> --
> View this message in context:
> http://nabble.documentfoundation.org/COUNTIF-with-more-than-one-conditions-tp4173143.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
>

-- 
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] Identical footnote settings work in one file but not another

[Mirosław Zalewski]

How about Tools -> Footnotes/Endnotes... ? Are settings there the same
in both documents?
-- 
Best regards
Mirosław Zalewski

-- 
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: question about the best version of libreoffice - MY God is better!

[Felmon Davis]

On Tue, 26 Jan 2016, Bob Holtzman wrote:


On Tue, Jan 26, 2016 at 12:29:54PM +, Tom Davies wrote:

Hi :)
Phil, i know you think you probably think you are just an atheist and
acting reasonably but this topic didn't arise in all the years that we
have seen Christian messages in various people's signatures.  The
discussion only arose after the only Islamic quote in all these years.

This has happened at a time when it's popular to attack Muslims for
their faith, and for the stereotypes pushed out by mainstream media to
demonise and vilify Muslims.


I haven't seen anything in the mainstream media that demonises and
vilifys Muslims. Only in right wing rags. Cite(s) please.


perhaps offlist?

interested individuals could ask to be copied.

f.

--
Felmon Davis


--
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: difference between Excel and Calc

[Ian McCarthy]

On 1/26/2016 1:17 PM, Andreas Säger wrote:

Am 26.01.2016 um 13:53 schrieb Ian McCarthy:

Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've
fallen over an incompatibility
as spread sheet will be used by both tools is there a switch I can use.
  The problem
=CELL("filename",A1) in LO returns
'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15

where as in Excel the returned data is different
  cant easily paste the excel result here but the terminal filename is in
square brackets
is there a way I can either spot which program I'm using and therefore
switch the detection of the sheet name

using  LibreOffice 5.0.4.2


=LEFT(CELL("FileName");8)="'file://"
returns TRUE in Calc and FALSE in Excel


Just fallen down another Excel/Calc wormhole - indirect addresses 
formats are different on Excel its 'sheetFred'!$C:$C
 where are its 'sheetFred'.$C:$C in Calc fortunatley the above test 
works for this just as well. :-)


--
Cheers Ian Mac - Ian D McCarthy
 
 Cronkshaw Fold

 Off Alden RdTel +44 (0) 1706 218614
 Helmshore   Fax +44 (0) 1706 215143
 Rossendale BB4 4AQ  Mobile  +44 (0) 7976 773843
 United Kingdom  Email   i...@cronkshaw.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] difference between Excel and Calc

[Tom Davies]

Hi :)
Isn't there a setting to change the way cells are addressed in Calc?
Something like;
Tools - Options - Calc
errr, somewhere in there?  I think you have to be in Calc to get those
options.
Regards from
Tom :)



On Tuesday, 26 January 2016, Ian McCarthy  wrote:

> On 1/26/2016 1:17 PM, Andreas Säger wrote:
>
>> Am 26.01.2016 um 13:53 schrieb Ian McCarthy:
>>
>>> Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've
>>> fallen over an incompatibility
>>> as spread sheet will be used by both tools is there a switch I can use.
>>>   The problem
>>> =CELL("filename",A1) in LO returns
>>> 'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15
>>>
>>> where as in Excel the returned data is different
>>>   cant easily paste the excel result here but the terminal filename is in
>>> square brackets
>>> is there a way I can either spot which program I'm using and therefore
>>> switch the detection of the sheet name
>>>
>>> using  LibreOffice 5.0.4.2
>>>
>>> =LEFT(CELL("FileName");8)="'file://"
>> returns TRUE in Calc and FALSE in Excel
>>
>>
>> Just fallen down another Excel/Calc wormhole - indirect addresses formats
> are different on Excel its 'sheetFred'!$C:$C
>  where are its 'sheetFred'.$C:$C in Calc fortunatley the above test works
> for this just as well. :-)
>
> --
> Cheers Ian Mac - Ian D McCarthy
>   Cronkshaw Fold
>  Off Alden RdTel +44 (0) 1706 218614
>  Helmshore   Fax +44 (0) 1706 215143
>  Rossendale BB4 4AQ  Mobile  +44 (0) 7976 773843
>  United Kingdom  Email   i...@cronkshaw.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
>

-- 
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: COUNTIF() with more than one conditions

[m.a.riosv]

Or if you have active regular expression (Menu/Tools/Options/LibreOffice
calc/Calculation)

=COUNTIF(C152:C228;"=H|K|Sze|Cs|P") 

Inner help.

|Finds the terms that occur before the "|" and also finds the terms that
occur after the "|". For example, "this|that" finds "this" and "that".

Miguel Ángel.




--
View this message in context: 
http://nabble.documentfoundation.org/COUNTIF-with-more-than-one-conditions-tp4173143p4173159.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] difference between Excel and Calc

[Remy Gauthier]

Hi,
Some of the configurations you are referring to are done via the
regional settings (at least in the version of Excel I use): this means
that your separator may not always be the "!" in Excel (I have seen the
"." as well). When I need to have compatible workbooks (Excel and
Calc), I have a configuration page where there is a named cell (I
usually call it "SEP") that contains the formula (assuming "Sheet1"
exists):
=IF(ISERROR(INDIRECT("Sheet1.A1"));"!";".")
Then, when you need to dynamically build an address and extract the
content of the cell, you would use something like:
=INDIRECT("Sheet_Name"&"Cell_Address")
or
=INDIRECT(CONCATENATE("Sheet_Name";SEP;"Cell_Address"))
For the CELL("Filename") function, the only consistent element about it
is the "#" used as separator in the filename. You can place this
formula in a cell on your configuration sheet, and name the cell
APP_IS_EXCEL:
=IF(ISERROR(FIND("#",CELL("Filename"))),"Excel","Calc")="Excel"
Then you can use constructs like this:
=IF(APP_IS_EXCEL;something_for_excel;something_for_calc)
Also remember that when the workbook is not saved, Calc returns the
sheet name preceded by a "''#" (such as ""#$Sheet1), whereas Excel
returns a blank.
I hope this helps.
Rémy Gauthier.
Le mardi 26 janvier 2016 à 23:32 +, Tom Davies a écrit :
> Hi :)
> Isn't there a setting to change the way cells are addressed in Calc?
> Something like;
> Tools - Options - Calc
> errr, somewhere in there?  I think you have to be in Calc to get
> those
> options.
> Regards from
> Tom :)
> 
> 
> 
> On Tuesday, 26 January 2016, Ian McCarthy  wrote:
> 
> > On 1/26/2016 1:17 PM, Andreas Säger wrote:
> > 
> > > Am 26.01.2016 um 13:53 schrieb Ian McCarthy:
> > > 
> > > > Hi I'm porting a spread sheet from Excel to LibreOffice Calc
> > > > and I've
> > > > fallen over an incompatibility
> > > > as spread sheet will be used by both tools is there a switch I
> > > > can use.
> > > >   The problem
> > > > =CELL("filename",A1) in LO returns
> > > > 'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15
> > > > 
> > > > where as in Excel the returned data is different
> > > >   cant easily paste the excel result here but the terminal
> > > > filename is in
> > > > square brackets
> > > > is there a way I can either spot which program I'm using and
> > > > therefore
> > > > switch the detection of the sheet name
> > > > 
> > > > using  LibreOffice 5.0.4.2
> > > > 
> > > > =LEFT(CELL("FileName");8)="'file://"
> > > returns TRUE in Calc and FALSE in Excel
> > > 
> > > 
> > > Just fallen down another Excel/Calc wormhole - indirect addresses
> > > formats
> > are different on Excel its 'sheetFred'!$C:$C
> >  where are its 'sheetFred'.$C:$C in Calc fortunatley the above test
> > works
> > for this just as well. :-)
> > 
> > --
> > Cheers Ian Mac - Ian D McCarthy
> >   Cronkshaw Fold
> >  Off Alden RdTel +44 (0) 1706 218614
> >  Helmshore   Fax +44 (0) 1706 215143
> >  Rossendale BB4 4AQ  Mobile  +44 (0) 7976 773843
> >  United Kingdom  Email   i...@cronkshaw.com
> > 
> > 
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscrib
> > e/
> > 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: difference between Excel and Calc

[m.a.riosv]

Yes there are two Tom

Menu/Tools/Options/LibreOffice calc/Formula - Formula Options - Formula
syntax.

and another one in

Menu/Tools/Options/LibreOffice calc/Formula - Detailed calculation settings
- Custom - Details - Reference syntax.

Miguel Ángel.



--
View this message in context: 
http://nabble.documentfoundation.org/difference-between-Excel-and-Calc-tp4173065p4173160.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] Identical footnote settings work in one file but not another

[Ken Heard]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 2016-01-27 03:35, Mirosław Zalewski wrote:

> How about Tools -> Footnotes/Endnotes... ? Are settings there the
> same in both documents?

No they were not.  In Tools -> Footnotes/Endnotes for one of the
documents there was no period in the ‘After’ space. Putting the period
there gave me the results I wanted..

It then occurred to me that I may not need to use an Outline/Numbering
style in footnotes; so I removed it from the Footnotes paragraph style
in both documents.  Sure enough, there was no change; I did not need
it.  To format the footnote the way I want it all I have to do is set
the ‘Indents and spacing’ option in the footnote paragraph style to
Before text: 0.50 cm; After text: 0.00; First line -0.50 cm.

I then did what I should have done before posting to the list -- open
the Footnotes entries in the LibreOffice help.  Mostly what I needed
to know was there.

I also discovered that there is a page style called Footnote.  I
really wonder whether I need to use it because there is a Footnotes
tab in the page style used for the whole page including the settings
for the line between the body text and the footnote text.

One setting I could not find was to change the footnote anchor.  Is it
possible to use a symbol such as an asterisk instead of a number as
the anchor?

Finally in Tools -> Footnotes I could not understand the purpose of
the character styles for the text and footnote areas.  Since however
the defaults for these are ‘Footnote Anchor’ and ‘Footnote Characters’
respectively, perhaps I don’t need to.

Thanks very much for the help.

Ken



-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.19 (GNU/Linux)

iEYEARECAAYFAlaoOb4ACgkQlNlJzOkJmTcVuQCfeZ4MzOuhQQXecZK8By6mRJvD
B74An0MOVux2wo0mWng6TETIIAERL7sy
=qdRg
-END PGP SIGNATURE-

-- 
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: Help! Lost all file permissions after upgrading Libre Office in Win 7

[V Stuart Foote]

Launch as your normal user and have a look at the LibreOffice main menu Tools
-> Options -> Paths panel.  Is it pointing to expected folder? Or, to
folders of the administrators group member user you used for the
installation?

If it is point to your user, but you can't edit--you may need to change
folder permissions using the OS Windows Explorer -> Properties -> Security
for the folder and take back ownership.  If pointing to the admin
account--you should be able to edit in the LibreOffice Paths panel--or
simply exit LibreOffice and delete/rename your corrupt user profile.





--
View this message in context: 
http://nabble.documentfoundation.org/Help-Lost-all-file-permissions-after-upgrading-Libre-Office-in-Win-7-tp4173055p4173058.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] Help! Lost all file permissions after upgrading Libre Office in Win 7

[Andy12345]

I just upgraded Libre Office to Version: 4.4.7.2 in Win 7 Home Premium and it
has wrecked all my file permissions.  I can no longer save files ( "You do
not have permission to save here, do you want to save in Documents
instead?") or open them. 

The problem may have come from the fact that you can't run an msi file
elevated, so I had to log on as an admin user to run the msi, and the admin
user does not own the documents of the non-admin user.  Whatever, it is a
big mess. 

Please, please, how do I get my permissions back?

Thank you

Andy




--
View this message in context: 
http://nabble.documentfoundation.org/Help-Lost-all-file-permissions-after-upgrading-Libre-Office-in-Win-7-tp4173055.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] difference between Excel and Calc

[Ian McCarthy]

Hi I'm porting a spread sheet from Excel to LibreOffice Calc and I've 
fallen over an incompatibility

as spread sheet will be used by both tools is there a switch I can use.
 The problem
=CELL("filename",A1) in LO returns
'file:///C:/Users/Ian Mac/Desktop/Accounts15-16.xls'#$Sep 15

where as in Excel the returned data is different
 cant easily paste the excel result here but the terminal filename is 
in square brackets
is there a way I can either spot which program I'm using and therefore 
switch the detection of the sheet name


using  LibreOffice 5.0.4.2

--
Cheers Ian Mac


--
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] [calc] is there a GOAL_SEEK function somewhere?

[Larry Evans]

I've checked that the value returned by the YIELD function:

https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD

can be gotten by using [Tools>Goal Seek...] and the PV function:

https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV

Is there some way I could use a something like a GOAL_SEEK function
to implement my own version of YIELD?  IOW, without having to go
through the answering of the [Goal Seek] dialog window requesting
Formual cell, Target Value, and Variable cell?

TIA.

-regards,
Larry


-- 
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: question about the best version of libreoffice - MY God is better!

[Dries Feys]

Amen
https://en.wikipedia.org/wiki/Amen

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 26 January 2016 at 13:29, Tom Davies  wrote:
> Hi :)
> Phil, i know you think you probably think you are just an atheist and
> acting reasonably but this topic didn't arise in all the years that we
> have seen Christian messages in various people's signatures.  The
> discussion only arose after the only Islamic quote in all these years.
>
> This has happened at a time when it's popular to attack Muslims for
> their faith, and for the stereotypes pushed out by mainstream media to
> demonise and vilify Muslims.
>
> Ridiculing religions in general might seem reasonable but choosing to
> do so right now, only after the first Islamic quote in a signature and
> not in any of the previous several years of Christian quotes (and
> hundreds of them) is Islamaphobic.
>
> It has been good to see people on this mailing-list increasingly make
> a stand against the increasing level of Islamaphobia in this thread -
> even people who don't understand or don't agree with Islam.  In my
> opinion standing with someone who seems to be being given a hard-time
> by 'the mainstream' is FAR more impressive than just taking cheap
> opportunistic pot-shots that are
>
> LibreOffice and the OpenDocument Format are making a stand against the
> mainstream and although the tide may be beginning to turn for us i am
> sure we can all remember moments where mainstream-people have done or
> said things, without even realising it, that are extremely pro-MSO and
> their ever-changing, unreliable formats.
>
>
> Please can we drop this topic and get on with the questions at hand?
> Regards from
> Tom :)
>
>
>
> On 26 January 2016 at 04:37, Philip Rhoades  wrote:
>> Virgil,
>>
>>
>> On 2016-01-26 07:24, Virgil Arrington wrote:
>>>
>>> On 01/25/2016 01:40 PM, jomali wrote:

 Please note that the original message by Nasrin was on a topic germane to
 this list. One member with an excessively tender sore spot objected to
 something in Nasrin's signature that expressed his sincerely held faith.
 There was no intent on Nasrin's part to proselytize or to demean
 another's
 faith, as Phil's diatribe does.
>>>
>>>
>>> I tend to agree about signature lines. They can contain all kinds of
>>> things having nothing to do with LO. Sometimes they're funny;
>>
>>
>>
>> That would be fine . .
>>
>>
>>> other
>>> times they are informative about the writer. Phil's signature line
>>> includes his address in Australia, which is informative, but has
>>> nothing to do with LO. Nasrin's signature line includes a a few lines
>>> about his Muslim faith,
>>
>>
>>
>> Another person with low general knowledge . . again I am not surprised . .
>>
>>
>>> also informative but also having nothing to do
>>> with LO.
>>>
>>> I pretty much ignore signature lines, and I can't possibly imagine
>>> being offended by one, regardless of what it might say.
>>>
>>> a Christian who loves Muslims
>>
>>
>>
>> And there we have it - another person who has an agenda - they can't
>> criticise someone else for proselytising their superstitious nonsense
>> because they have their own superstitious nonsense . . a person who "loves"
>> someone else but does not even know that the person they "love" is a "she"
>> and not a "he" . . clueless . .
>>
>> P.
>>
>> --
>> Philip Rhoades
>>
>> PO Box 896
>> Cowra  NSW  2794
>> Australia
>> E-mail:  p...@pricom.com.au
>>
>> --
>> 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

-- 


 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: