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

-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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

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

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

[libreoffice-users] Re: difference between Excel and Calc

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 >

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

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

[libreoffice-users] Re: Help! Lost all file permissions after upgrading Libre Office in Win 7

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

Re: [libreoffice-users] difference between Excel and Calc

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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

[libreoffice-users] Re: Help! Lost all file permissions after upgrading Libre Office in Win 7

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

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

[libreoffice-users] Re: Help! Lost all file permissions after upgrading Libre Office in Win 7

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

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

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:

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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"

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

Re: [libreoffice-users] Re: LibreOffice Base and MySQL

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

Re: [libreoffice-users] Re: LibreOffice Base and MySQL

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

[libreoffice-users] Re: LibreOffice Base and MySQL

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

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

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?

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

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

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

[libreoffice-users] Re: LibreOffice Base and MySQL

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

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

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

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

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 +

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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

Re: [libreoffice-users] Re: difference between Excel and Calc

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)

Re: [libreoffice-users] difference between Excel and Calc

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

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

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

Re: [libreoffice-users] difference between Excel and Calc

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

[libreoffice-users] Re: difference between Excel and Calc

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:

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

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

[libreoffice-users] Re: Help! Lost all file permissions after upgrading Libre Office in Win 7

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

[libreoffice-users] Help! Lost all file permissions after upgrading Libre Office in Win 7

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

[libreoffice-users] difference between Excel and Calc

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

[libreoffice-users] [calc] is there a GOAL_SEEK function somewhere?

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

Re: [libreoffice-users] Re: question about the best version of libreoffice - MY God is better!

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