Re: [libreoffice-users] Re: Styles and Formatting Not Working
At 15:22 22/02/2015 +1100, Tony Bray wrote: At 20:37 21/02/2015 -0500, Taang Zomi wrote: But the SAVE tool is still not dimmed after I saved anything. Just a suggestion with the Save button appearing not to dim after saving. Do you have "Allow to save document even when the document is not modified" selected under the LibreOffice > General Options? This sometimes means that the save button does not dim as you can still save again. Aha: well done; I'd missed that! (Surely this *always* means that the Save icon will not be greyed out?) I'm sure you are right that this is the questioner's problem (and solution). For the benefit of the questioner (who appears to be using Windows), this option is at Tools | Options... | LibreOffice | General | Document status | Allow to save document even when the document is not modified. 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] Styles and Formatting Not Working
At 20:27 21/02/2015 -0500, Taang Zomi wrote: Yes, the Styles and Formatting window does not appear. Right. You've still not answered most of the questions - including what operating system you are using. But you appears to be using Windows. So what happened, please, when you tried the various ideas suggested to retrieve the window? 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: Styles and Formatting Not Working
On 22/02/2015, at 12:37, Taang Zomi wrote: Just a suggestion with the Save button appearing not to dim after saving. Do you have "Allow to save document even when the document is not modified" selected under the LibreOffice > General Options? This sometimes means that the save button does not dim as you can still save again. Just a thought Tony Bray tony...@mac.com MacBook Pro 15 inch Mid 2009 2.8 GHz Intel Core 2 Duo, 4 GB RAM, Mac OS X 10.9.5. LibreOffice 4.2.6.3 Ubuntu 14.04, LibreOffice 4.3.? Acer 15 inch laptop, 4 GB RAM -- 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: Styles and Formatting Not Working
As you suggested, I uninstalled the 4.4.0.3 and then installed the 4.3.6.2. The Styles and Formatting window appears now. But the SAVE tool is still not dimmed after I saved anything. The same thing happened after I uninstalled the 4.3.6.2 and then installed the 4.3.5.2. That means, Styles and Formatting window appears, but the SAVE tool is still not dimmed after I saved anything. Sincerely, Taang Zomi On Fri, Feb 20, 2015 at 8:35 PM, Taang Zomi wrote: > Dear Tom, > > Thank you very much for your advice. I will install the former version. > > Taang Zomi > > On Fri, Feb 20, 2015 at 8:33 PM, Tom Davies wrote: > >> Hi :) >> I think best advice is to reinstall the 4.3.x to get back to familiar >> territory! >> >> Err, a new version has just been released in that branch so if you don't >> have your old installer then maybe download the newest release in the >> "Still" branch. >> >> It is possible to install it in parallel with your current version of >> LibreOfrfice but personally i would probably go for a normal proper >> install. >> Regards from >> Tom :) >> >> >> >> >> >> On 21 February 2015 at 01:29, Taang Zomi >> wrote: >> >>> Many, many years ago, I read somewhere that "when a misfortune >>> comes, it does not come alone; it is accompanied by its companions" or >>> to that effect. >>> >>> Today, I had another problem. It could be called the #4 problem. >>> >>> The Styles and Formatting (F11) under Format did not work. As I am >>> writing a book, and the deadline for submission of the manuscript is the >>> end of February, you can imagine how much I am frustrated. >>> >>> I used LibreOffice 4.3.5.2; Since February 19, 2015, I have used >>> LibreOffce 4.4.0.3. >>> >>> Taang Zomi >>> >> >> > -- 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] Styles and Formatting Not Working
Yes, the Styles and Formatting window does not appear. On Sat, Feb 21, 2015 at 12:10 AM, Brian Barker wrote: > At 20:29 20/02/2015 -0500, Taang Zomi wrote: > >> The Styles and Formatting (F11) under Format did not work. >> > > Er, do you mean that the Styles and Formatting window does not appear? Or > does it appear but then not function in some sense? Can you successfully > select the type of style using the buttons at the top of the Styles and > Formatting window? > > o What happens if you go to Format | Styles and Formatting? > o Or press F11? > o Or click the Styles and Formatting button in the Formatting toolbar? > o Or press Alt+O, Y? > o Or click the Styles and Formatting button in the LibreOffice sidebar? > > Have you restarted LibreOffice? > > Have you restarted your computer? > > Have you merely lost the window off the screen? Are you using Windows? > o When you press F11 (or whatever), does the LibreOffice title bar become > dimmed - indicating that another window (the one you have lost) has taken > focus? > o With the main title bar still dimmed, press Alt+Space and then M. > o Press any of the keyboard arrow keys once. > o Now move the mouse until the outline of the missing window is somewhere > central. > o Click the mouse. > > At 20:35 20/02/2015 -0500, Taang Zomi wrote: > >> I will install the former version. >> > > Isn't it a bit unlikely to be a bug in the later version? Wouldn't > millions of users then be asking the same question? > > 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 > > -- 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: LO Base Problem
Thanks Alex But I fear this is getting nowhere. As per your suggestion I built a new ODB file and it showed the same problem. i have run the MySQLcheck program and it confirms the DB is OK. Maybe it is a "funny" in Base itself??? And it may come right with the next release?? In itself the problem does not make my DB unusable and I must press on with it so I guess the best is to just put the RecordID number in by hand and keep a paper record of the last used number. Seems ridicules but I guess it's what we all call a "Workround". I really do appreciate your help and assistance nonetheless. With best wishes 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
[libreoffice-users] Re: making self-defined functions available for all spreadsheets
Am 21.02.2015 um 19:17 schrieb hw:
>
> Hi,
>
> how can I make a self-written function (i. e. a macro) available for all
> spreadsheets so that I can use this function for any spreadsheet I
> create or load and modify?
>
> Ideally, this should work with multiple users in that I'd like to deploy
> the macro(s) somewhere central for others to use.
>
Hi,
You have two choices:
1) Write an add-in package which is installable via the extension
manager. These functoons can have their own localized help pages and
function names. They appear in the function wizard just like a built-in
function. You can not write add-ins Basic code.
2) Quick and drity Basic functions without any integration can be stored
in the "Standard" library of the global macro name space ("My Macros").
This library is loaded automatically so the functions can be found at
any time.
2a) Since it is possible to call macro code from different languages,
you can write or re-use functions written in Java, Python or JavaScript
and write a Basic wrapper. The spreadsheet calls the Basic function
which itself calls the other script.
HTH
--
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] Fwd: The Save Tool could not be dimmed
Tom and Brian, Thank you very much for trying to help me. I have not yet found the solution, but I hope I will. Taang Zomi -- 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] making self-defined functions available for all spreadsheets
Hi, how can I make a self-written function (i. e. a macro) available for all spreadsheets so that I can use this function for any spreadsheet I create or load and modify? Ideally, this should work with multiple users in that I'd like to deploy the macro(s) somewhere central for others to use. -- 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: LO Base Problem
Le 20/02/2015 22:24, Ian Whitfield a écrit : > > FedSaints.Members OK > So, on the face of it, your data tables are consistent and error free (with regard to their definitions). The problem then, would appear to lie with your ODB file. Something, some setting, or control, is unhappy with the change in the RecordID field and its new definition. Ideally, you would compare the contents of the before and after ODB files, e.g. using a diff command on the unzipped files present in the ODBs. That would point to where things have changed, and possibly how you might correct the problem. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Styles and Formatting Not Working
Hi :) If the document's title-bar is dimming, indicating that the styles menu-pop-up is off-screen then trying to either; * set the screen display to a much higher resolution temporarily so that you can drag the errant pop-up back into the normally visible area - or - * rename your "User Profile" to "get back to factory defaults" https://wiki.documentfoundation.org/UserProfile I'm not sure how to force an off-screen window or pop-up to come back onto the screen tbh. Those are just things that i would try. Regard from Tom :) On 21 February 2015 at 05:10, Brian Barker wrote: > At 20:29 20/02/2015 -0500, Taang Zomi wrote: > >> The Styles and Formatting (F11) under Format did not work. >> > > Er, do you mean that the Styles and Formatting window does not appear? Or > does it appear but then not function in some sense? Can you successfully > select the type of style using the buttons at the top of the Styles and > Formatting window? > > o What happens if you go to Format | Styles and Formatting? > o Or press F11? > o Or click the Styles and Formatting button in the Formatting toolbar? > o Or press Alt+O, Y? > o Or click the Styles and Formatting button in the LibreOffice sidebar? > > Have you restarted LibreOffice? > > Have you restarted your computer? > > Have you merely lost the window off the screen? Are you using Windows? > o When you press F11 (or whatever), does the LibreOffice title bar become > dimmed - indicating that another window (the one you have lost) has taken > focus? > o With the main title bar still dimmed, press Alt+Space and then M. > o Press any of the keyboard arrow keys once. > o Now move the mouse until the outline of the missing window is somewhere > central. > o Click the mouse. > > At 20:35 20/02/2015 -0500, Taang Zomi wrote: > >> I will install the former version. >> > > Isn't it a bit unlikely to be a bug in the later version? Wouldn't > millions of users then be asking the same question? > > 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 > > -- 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] Trouble using the IF statement in a Writer table
That works like a charm, thanks Brian! -- Cheers, Patrick On Sat, 2015-02-21 at 11:00 +, Brian Barker wrote: > At 10:51 21/02/2015 +0100, Patrick Dijkgraaf wrote: > >I'm trying to use the IF statement in a Writer table, but it doesn't > >behave the way I expect. Probably I am doing something wrong. Can > >any of you help me? > > Only a limited range of functions is available in Writer tables and, > as far as I know, this does not include IF. > > >What I'm trying to achieve (in cell B1) is to print the value of > >cell A1 up to a maximum of 8. I thought the formula in cell B1 [ > >=IF(>8;8;) ]would to that: > > - If the value in cell A1 is larger than 8, print the number 8. > > - Otherwise, print the content of cell A1. > > You can achieve the effect you require using > =MIN|8 > > 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] Trouble using the IF statement in a Writer table
At 10:51 21/02/2015 +0100, Patrick Dijkgraaf wrote: I'm trying to use the IF statement in a Writer table, but it doesn't behave the way I expect. Probably I am doing something wrong. Can any of you help me? Only a limited range of functions is available in Writer tables and, as far as I know, this does not include IF. What I'm trying to achieve (in cell B1) is to print the value of cell A1 up to a maximum of 8. I thought the formula in cell B1 [ =IF(>8;8;) ]would to that: - If the value in cell A1 is larger than 8, print the number 8. - Otherwise, print the content of cell A1. You can achieve the effect you require using =MIN|8 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] Trouble using the IF statement in a Writer table
Hi all, I'm trying to use the IF statement in a Writer table, but it doesn't behave the way I expect. Probably I am doing something wrong. Can any of you help me? Example document: http://kwek.duckstad.net/IFstatement.odt What I'm trying to achieve (in cell B1) is to print the value of cell A1 up to a maximum of 8. I thought the formula in cell B1 woud to that: - If the value in cell A1 is larger than 8, print the number 8. - Otherwise, print the content of cell A1. But strangely enough, It always prints the content of cell A1, regardless of the value. Can anyone tell me what I'm doing wrong? Thanks in advance! -- Cheers, Patrick -- 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
