Re: [libreoffice-users] CALC - How to count blank cells?
El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells? From: MiguelAngel mari...@miguelangel.mobi Date: 7/4/12 3:44 AM To: users@global.libreoffice.org El 04/07/12 5:16, dave wagner escribió: I have a small range of cells (less than 100) in which I need to count the cells that are blank. What is the best way to do this? I was trying something like =COUNTIF(C11:C103,(CELL(Type,b))).But that just did not work. Thanks to all who helps me with this simple problem. =SUMPRODUCT(ISBLANK(C11:C103)) Miguel Ángel. In a related (I think) question, what formula could be used to identify the last row in a spreadsheet with data in it? It's a similar situation as the OP, in which new data is inserted as a new row at the bottom of the sheet. I want another worksheet to be able to pick up certain fields from the last row of data, but haven't been able to figure out how to locate which row is last (with data). A1=a A2=b A3=c A4=d What I'm looking for is a formula that would tell me, in the above data, that row 4 is the last one with data. Thanks for any help! I know that this is not what you asked for exactly, but coupled with CELL() or COUNTBLANK() function, might allow you to establish the row number in your situation. The following allows me to get the last value of the column (F) in sheet1 (used in my case in a summary table that lists the final value in a column that lists the running balance of my bank account)... =OFFSET($'sheet1'.$F$6,COUNTA($'sheet1'.$F$6:$'sheet1'.$F$9633)-1,0) Assumes the range $F$6: to $F$9633 has continuous data - essentially it returns the number of rows/cells with data, so will not work if your array or range has blanks (unless the number is static or can be predicted). So in your example... COUNTA(A1:A1000) will return 4, knowing that you start from A1 allows you to extrapolate that the last row is A4. =SUMPRODUCT(MAX(NOT(iSBLANK(c11:c999))*ROW(c11:c999))) give the number of the last row with data in the range. Miguel Ángel. -- For unsubscribe instructions e-mail to: users+h...@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 - How to count blank cells?
Am 09.07.2012 10:22, MiguelAngel wrote: El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells? From: MiguelAngel mari...@miguelangel.mobi Date: 7/4/12 3:44 AM To: users@global.libreoffice.org El 04/07/12 5:16, dave wagner escribió: I have a small range of cells (less than 100) in which I need to count the cells that are blank. What is the best way to do this? I was trying something like =COUNTIF(C11:C103,(CELL(Type,b))).But that just did not work. Thanks to all who helps me with this simple problem. =SUMPRODUCT(ISBLANK(C11:C103)) Miguel Ángel. In a related (I think) question, what formula could be used to identify the last row in a spreadsheet with data in it? It's a similar situation as the OP, in which new data is inserted as a new row at the bottom of the sheet. I want another worksheet to be able to pick up certain fields from the last row of data, but haven't been able to figure out how to locate which row is last (with data). A1=a A2=b A3=c A4=d What I'm looking for is a formula that would tell me, in the above data, that row 4 is the last one with data. Thanks for any help! I know that this is not what you asked for exactly, but coupled with CELL() or COUNTBLANK() function, might allow you to establish the row number in your situation. The following allows me to get the last value of the column (F) in sheet1 (used in my case in a summary table that lists the final value in a column that lists the running balance of my bank account)... =OFFSET($'sheet1'.$F$6,COUNTA($'sheet1'.$F$6:$'sheet1'.$F$9633)-1,0) Assumes the range $F$6: to $F$9633 has continuous data - essentially it returns the number of rows/cells with data, so will not work if your array or range has blanks (unless the number is static or can be predicted). So in your example... COUNTA(A1:A1000) will return 4, knowing that you start from A1 allows you to extrapolate that the last row is A4. =SUMPRODUCT(MAX(NOT(iSBLANK(c11:c999))*ROW(c11:c999))) give the number of the last row with data in the range. Miguel Ángel. And all these tricks are completely obsolete if you know how to navigate, expand and edit spreadsheet ranges with a couple of keystrokes. By the way: If you would use a database in the first place the editor of your data would not even need to know that. -- For unsubscribe instructions e-mail to: users+h...@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] [3.5.3.2/Calc]Multiply percentage with fraction?
Hello The C1 column contains percentages, eg. 1,80% while C2 contains rational numbers, eg. 0,70. I need to multiple C1 x C2, but Calc displays #NAME?. What should I do to perform this operation? Thank you. -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Multiply-percentage-with-fraction-tp3994438.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] [3.5.3.2/Calc]Multiply percentage with fraction?
Gilles wrote: Hello The C1 column contains percentages, eg. 1,80% while C2 contains rational numbers, eg. 0,70. I need to multiple C1 x C2, but Calc displays #NAME?. What should I do to perform this operation? Thank you. -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Multiply-percentage-with-fraction-tp3994438.html Sent from the Users mailing list archive at Nabble.com. This is what I did. I right clicked the A of column A and selected Format cells. I selected percentage. Then I used this procedure to format Column B as a number with 2 decimal places. I entered 1.25 in cell A1 (1.25%) and entered 80 in cell B1 (80.00). In cell C1 I entered =A1*B1. Cell C1 shows 1 as the answer. I'm not sure what the error is, but I will suggest something. Have you formatted your C1 and C2 columns correctly? I noticed another thing. When I format both columns as text and enter 1.25% in A1 and 80.00 in B1, I still get 1 as my answer. --Dan -- For unsubscribe instructions e-mail to: users+h...@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] LibreOffice won't save settings
I'm running LibreOffice 3.5.4.2, BuildID: 350m1(Build:2) on Kubuntu 10.04. I love the program, but it will not save any of my customization settings. For example, I've recorded macros and then placed them on a toolbar, but the next time I open the program, they are not on the toolbar. Similarly, I've checked Enable experimental features, but subsequent boots of the program do not have that feature enabled. Any suggestions gratefully appreciated. If it were Microsoft Office, I would think I should delete the file with the saved user settings so that the program re-creates it. But a) it's not Microsoft Office (for which I am profoundly grateful), and b) I don't know whether LibreOffice has a file that would correspond with that or where it might be. Thanks in advance. -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-won-t-save-settings-tp3994487.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: [3.5.3.2/Calc]Multiply percentage with fraction?
It worked for me, = 1.26 In the multiply C1 by C2 cell you must have hit the function icon and not the equals icon. This would Sum the two in the absence of any chosen function. Tink. -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Multiply-percentage-with-fraction-tp3994438p3994492.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] LibreOffice won't save settings
On 09/07/2012 at 17:24, Don d...@law.pace.edu wrote: I'm running LibreOffice 3.5.4.2, BuildID: 350m1(Build:2) on Kubuntu 10.04. I love the program, but it will not save any of my customization settings. For example, I've recorded macros and then placed them on a toolbar, but the next time I open the program, they are not on the toolbar. Similarly, I've checked Enable experimental features, but subsequent boots of the program do not have that feature enabled. Any suggestions gratefully appreciated. It looks like permissions problem - i.e. files that LibreOffice tries to modify does not have write permission for user that LibreOffice runs like. Have you upgraded lately? AFAIR there was some bug in LO 3.5.x Debian packages that caused migrated settings to be owned by root. This would fit perfectly to your case, but I may not remember correctly. b) I don't know whether LibreOffice has a file that would correspond with that or where it might be. That would be ~/.config/libreoffice/ You are interested mostly in ~/.config/libreoffice/3/user/registrymodifications.xcu file. You can try to run that command from terminal: soffice -env:UserInstallation=file:///tmp/lo/ This will create new LO config directory in /tmp/ (it will be removed in next boot). Check if setting changes are written (just close LO and run that command again, so LO will read settings). If so, then it apparently is problem with your config dir (path above). You may try to remove it (or rename) and run LO again - it will recreate all settings from scratch. But it may be quite some work if you tend to customize your LO heavy. If above command will still produce LO that does not remember it's settings, then your LO build is broken. You should upgrade/downgrade it. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@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 won't save settings
Miroslaw, Thanks for getting back to me so quickly. I think I'm up to date on the program since the first things I do every day are to use the Kpackage Manager update feature and then run sudo apt-get update. Do you know which files I would need to change the permissions on? That seems from your message the simplest approach to try at this point. Don -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-won-t-save-settings-tp3994487p3994498.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] updated list of KPP English dictionaries for LO
Dear webmaster-Kracked_P_P, I just downloaded and installed the KPP 2012 dictionaries. I found that after I installed them either the descriptions and/or the dates/version numbers had not been updated properly so that it is difficult or impossible to tell which version is installed. (In the case of the Canadian and British dictionaries the descriptions seem to be the same as the previous versions.) Could this please be corrected. The descriptionsshown are: American English spelling hyphenation thesaurus - tech/FOSS terms a... 2012.06.24 KPP British English spelling, hyphen, thesaurus, 638k word list 2011.11.09 KPP Canadian English Spell Checking, Hyphen, Thesaurus - 638k word list 2.0.0 KPP P.S. Other dictionaries have a flag or some kind of icon identifying them. Canadian, British, and American flags would be helpful to identify these dictionaries. On 12-07-07 07:40 AM, webmaster-Kracked_P_P wrote: I created a page for the KPP dictionaries, out of the NA-DVD folders. http://libreoffice-na.us/KPP-dictionaries/dictionary.html I have 3 updated dictionaries. The British dictionary now go to 639,116, the Canadian goes to 639,112. The American English one is now 773,407 words. All three dictionaries now include missing words, including open source and FOSS terms. The American English includes a lot more. In a bit, I will be updating the Extension Center with the new versions of the dictionaries. I have to decide how I am going to deal with the page[s] I have there first. I will not be updating the smaller word lists though. The new URL/page will, for now, list all of the KPP dictionaries, old and new. The current 3.5.x NA-DVD dictionary page reflects the updates and will not include the 638K versions, since the 639K version are the updates for the British and Canadian dictionaries. Next week, hopefully, 3.5.5 will be out and then I will create a 3.5.5 version ISO file to upload to the servers for downloading. That will be the one that will have the new dictionaries and the up-to-date documentation list. Impress has a full set of chapters for 3.5.x. Getting Started has Chapters 1-9 except 5 and 7 for 3.5.x. Draw has Chapters 1-3 for 3.5.x. I wish someone would help the documentation writers to get a set of chapters for BASE. There has been no additions since January, and that was a draft file. -- Udvarias Ur This letter was generated and sent from Thunderbird on Ubuntu Linux. -- For unsubscribe instructions e-mail to: users+h...@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] updated list of KPP English dictionaries for LO
You are correct. I forgot to update the internal reference for the files. Will work on that issue soon. Have caught a bug over the weekend, so it will not be today. The real update was some missing words that should have been included in the first place. I once had a spell checking dictionary that the authors forgot to add the word dictionary to their list. On 07/09/2012 12:16 PM, Udvarias Ur wrote: Dear webmaster-Kracked_P_P, I just downloaded and installed the KPP 2012 dictionaries. I found that after I installed them either the descriptions and/or the dates/version numbers had not been updated properly so that it is difficult or impossible to tell which version is installed. (In the case of the Canadian and British dictionaries the descriptions seem to be the same as the previous versions.) Could this please be corrected. The descriptionsshown are: American English spelling hyphenation thesaurus - tech/FOSS terms a... 2012.06.24 KPP British English spelling, hyphen, thesaurus, 638k word list 2011.11.09 KPP Canadian English Spell Checking, Hyphen, Thesaurus - 638k word list 2.0.0 KPP P.S. Other dictionaries have a flag or some kind of icon identifying them. Canadian, British, and American flags would be helpful to identify these dictionaries. On 12-07-07 07:40 AM, webmaster-Kracked_P_P wrote: I created a page for the KPP dictionaries, out of the NA-DVD folders. http://libreoffice-na.us/KPP-dictionaries/dictionary.html I have 3 updated dictionaries. The British dictionary now go to 639,116, the Canadian goes to 639,112. The American English one is now 773,407 words. All three dictionaries now include missing words, including open source and FOSS terms. The American English includes a lot more. In a bit, I will be updating the Extension Center with the new versions of the dictionaries. I have to decide how I am going to deal with the page[s] I have there first. I will not be updating the smaller word lists though. The new URL/page will, for now, list all of the KPP dictionaries, old and new. The current 3.5.x NA-DVD dictionary page reflects the updates and will not include the 638K versions, since the 639K version are the updates for the British and Canadian dictionaries. Next week, hopefully, 3.5.5 will be out and then I will create a 3.5.5 version ISO file to upload to the servers for downloading. That will be the one that will have the new dictionaries and the up-to-date documentation list. Impress has a full set of chapters for 3.5.x. Getting Started has Chapters 1-9 except 5 and 7 for 3.5.x. Draw has Chapters 1-3 for 3.5.x. I wish someone would help the documentation writers to get a set of chapters for BASE. There has been no additions since January, and that was a draft file. -- For unsubscribe instructions e-mail to: users+h...@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: [3.5.3.2/Calc]Multiply percentage with fraction?
Am 09.07.2012 14:54, Dan wrote: Have you formatted your C1 and C2 columns correctly? The OP gets the #NAME error. What is a correctly formatted cell? Can you demonstrate us a single case where any formatting attribute has any influence on the cell value? -- For unsubscribe instructions e-mail to: users+h...@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: [3.5.3.2/Calc]Multiply percentage with fraction?
Andreas Säger wrote: Am 09.07.2012 14:54, Dan wrote: Have you formatted your C1 and C2 columns correctly? The OP gets the #NAME error. What is a correctly formatted cell? Can you demonstrate us a single case where any formatting attribute has any influence on the cell value? Probably not, but neither have you made any suggestions nor asked any questions. So, the OP does not receive any benefit from you either. Probably more to the point, Gillas, would you please tell us what you did to get the #Name error? What formula did you use? --Dan -- For unsubscribe instructions e-mail to: users+h...@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 won't save settings
On Mon, 9 Jul 2012 09:12:46 -0700 (PDT) Don d...@law.pace.edu wrote about [libreoffice-users] Re: LibreOffice won't save settings: Miroslaw, Thanks for getting back to me so quickly. I think I'm up to date on the program since the first things I do every day are to use the Kpackage Manager update feature and then run sudo apt-get update. Do you know which files I would need to change the permissions on? That seems from your message the simplest approach to try at this point. Don -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-won-t-save-settings-tp3994487p3994498.html Sent from the Users mailing list archive at Nabble.com. Hi Don, I don't use Kubuntu but will give an answer that SHOULD work. I occasionally run chown on my entire ~/ folder (/home/user/) just to avoid any problem with permissions caused by backup/restore, upgrades, and additions. chown -R username:users /home/user/ the -R ensures recursion through all that users sub-directories Tom -- “What we do for ourselves dies with us. What we do for others and the world remains and is immortal.” Albert Pine Tom Taylor - retired penguin AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2 openSUSE 12.1x86_64openSUSE 12.2x86_64 KDE 4.7.2, FF 7.0 KDE 4.8.4, FF 13.0 claws-mail 3.8.0 registered linux user 263467 linxt-At-comcast-DoT-net -- For unsubscribe instructions e-mail to: users+h...@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 won't save settings
On 09/07/2012 at 18:12, Don d...@law.pace.edu wrote: Do you know which files I would need to change the permissions on? As I said, give ~/.config/libreoffice/3/user/registrymodifications.xcu a try. All changes are written to that file. It tends to grow in size over time. I believe changes should be redistributed over appropriate files over time, but for some reason they seem to not be. But personally I would start from second command to ensure that problem lies in permissions/configuration and not LO package itself. -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@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] Outline woes
Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach myself how it works, the more confused I get. Could somebody give me a simple step by step process to create the following outline in an existing document, addressing the the different types of styles involved? I would be very greatful. Thanks. - Andrew A. D. Rahn IV, ARA RAHN LAND Inc. Accredited Rural Appraiser Montana Certified General Appraiser Montana Licensed Real Estate Salesperson P.O. Box 1013 Bozeman, Montana 59771 406-580-6882 -- View this message in context: http://nabble.documentfoundation.org/Outline-woes-tp3994527.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Outline woes
Hi, Rahn Land schrieb: Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach myself how it works, the more confused I get. Could somebody give me a simple step by step process to create the following outline in an existing document, addressing the the different types of styles involved? I would be very greatful. Thanks. It is confusing and you are not the only one who struggle with it. You have to distinguish between 1. Numbering headings by automatic 2. Numbering headings by manipulating styles 3. Not numbering headings, but making a list. So please first tell, whether you want to number your headings or making a list. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@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: Outline woes
I think I want to number headings by manipulating styles, but I am not sure. I don't understand the distinctions between the three. I want an outline system that uses styles, so that I can easily change or modify the format of multiple headings at once. I want it automatic in the sense that if I create a new heading, the other headings are automatically re-numbered (or lettered). Does that help clarify? Thanks. - Andrew A. D. Rahn IV, ARA RAHN LAND Inc. Accredited Rural Appraiser Montana Certified General Appraiser Montana Licensed Real Estate Salesperson P.O. Box 1013 Bozeman, Montana 59771 406-580-6882 -- View this message in context: http://nabble.documentfoundation.org/Outline-woes-tp3994527p3994538.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Outline woes
Hi On 10/07/12 6:40 AM, Rahn Land wrote: Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach myself how it works, the more confused I get. Could somebody give me a simple step by step process to create the following outline in an existing document, addressing the the different types of styles involved? I would be very greatful. Thanks. Highlight the text you want this numbering to apply to. Select the text format drop down (on left of font) and pick more, the styles dialogue opens. Select list styles from the icons. You can make a new style or say double click Numbering 5. Right click numbering 5 and modify. Under outline tab I think you want lower left, select it. Under options tab select each level on the left and change the Start at back to 1. Select OK. Select each block of text to lower 1 level, as all will be at the top level, and with the pop up bullets and numbering tool select the Demote 1 level with subpoints. Demote the text to the required subpoint as needed. Confusing, don't know why the subpoints don't start numbering from 1. Steve - Andrew A. D. Rahn IV, ARA RAHN LAND Inc. Accredited Rural Appraiser Montana Certified General Appraiser Montana Licensed Real Estate Salesperson P.O. Box 1013 Bozeman, Montana 59771 406-580-6882 -- View this message in context: http://nabble.documentfoundation.org/Outline-woes-tp3994527.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 won't save settings
You have a macro and a toolbar button. Where is the macro stored? Globally or in a document? Where is the modified toolbar stored? Globally or in a document? -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-won-t-save-settings-tp3994487p3994541.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] Outline woes
Hi Andy, OOo and derivatives like LO cannot do outlining. What LO does is an outline formatting with the Navigator, which is useless for outlining. Those who use outlining intensively will confirm that (see link below). It has been an issue for more than 10 years now. Use a real outliner; I use Pages '09 (cost about 14,95 Euro) on Mac. M$ also has outliners, but they cost more than double that of Pages. There are also some open-source outliners. Most of them export the finished documents into all word processor file types for the final formatting and printing. For more information see issue Outline View (aka MS Word): https://issues.apache.org/ooo/show_bug.cgi?id=3959. I hope LO developers have another attitude to this show-stopper for most advanced and technical writers needing an outliner in LO. Otherwise we outliner users will not be able to use LO any more. Dreiel Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach myself how it works, the more confused I get. Could somebody give me a simple step by step process to create the following outline in an existing document, addressing the the different types of styles involved? I would be very greatful. Thanks. - Andrew A. D. Rahn IV, ARA RAHN LAND Inc. Accredited Rural Appraiser Montana Certified General Appraiser Montana Licensed Real Estate Salesperson P.O. Box 1013 Bozeman, Montana 59771 406-580-6882 -- View this message in context: http://nabble.documentfoundation.org/Outline-woes-tp3994527.html Sent from the Users mailing list archive at Nabble.com. -- lllact...@gmx.net _ - banking establishments are more dangerous than standing armies - http://www.britannica.com/presidents/article-9116907 - Thomas Jefferson _ -- For unsubscribe instructions e-mail to: users+h...@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] Can't install Libre
This is the first time I've had any trouble installing Libre. I'm getting an installation error, 2755, 110 if I download the main file, and a 1305 error if I try to install from the torrent file. I'm using Windows 7 Home, just reinstalled it in the last week. I've not had any problems with any other installations, including other .msi files. Thank you in advance Sincerely, Robert Ruff -- For unsubscribe instructions e-mail to: users+h...@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] Can't install Libre
Hi, A quick search indicates that the folder where you store the installation file is encrypted. Try to set that folder to be not encrypted and start again. Cheers, Leif Lodahl Den 09/07/2012 23.06 skrev Jay Lozier jsloz...@gmail.com: Robert, On 07/09/2012 04:37 PM, Robert Ruff wrote: This is the first time I've had any trouble installing Libre. I'm getting an installation error, 2755, 110 if I download the main file, and a 1305 error if I try to install from the torrent file. I'm using Windows 7 Home, just reinstalled it in the last week. I've not had any problems with any other installations, including other .msi files. Thank you in advance Sincerely, Robert Ruff Check the file hash to make sure you have a clean download. A overlooked Windows installer issue is if you have a previous version of LO or OO and Quickstarter is open/running. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@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: [3.5.3.2/Calc]Multiply percentage with fraction?
Thanks everyone for the help. Turns out the error was due to my using a . instead of , as decimal separator. This works for me... =$C4 * 0,845 ... while this doesn't =$C4 * 0.845. -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Multiply-percentage-with-fraction-tp3994438p3994566.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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: Outline woes
Hi, Rahn Land schrieb: I think I want to number headings by manipulating styles, but I am not sure. I don't understand the distinctions between the three. I want an outline system that uses styles, so that I can easily change or modify the format of multiple headings at once. I want it automatic in the sense that if I create a new heading, the other headings are automatically re-numbered (or lettered). Does that help clarify? Yes, that is clear now. 1. If you have assigned any kind of numbering already, then right click on the heading and choose item NumberingBullets. If you see the button Remove enabled, click on it to remove the numbering. Those are list numberings and cannot be used together with outline numbering. 2. Assign the style Heading 1 for chapters, Heading 2 for Subchapters and Heading 3 for sections to those headings. You will find these styles for quick access in the drop-down list in the toolbar. But you can use the styleformatting dialog as well, for example if you need deeper outlining. 3. Goto Tools Outline numbering. On dialog page 'Numbering' on the left side click on a level. 1 is for chapters, 2 for subchapters and 3 for sections. Make sure that the field 'Paragraph style' has the according style. In the field 'Number' choose the type of number, which you will use for that level. Whether the value in the field 'sublevels' need to be maximal depends on the desired numbering style. Look at the preview. Use the fields in 'Seperator' to set the desired brackets and dots. You do net set the indentation in this dialog page. 4. Goto the dialog page 'Position'. Here again first select the level, then set the indentation and alignments for that level. 5. Right click a heading and choose 'Edit style' or open the StyleFormatting dialog, right click the style and choose 'Modify'. On both ways you get the dialog to set the appearance of the heading, including font, style and spacing. Another method to get the changes is, to style a heading directly, mark it and then use the button 'Update Style' from the StyleFormatting-dialog. It is hidden behind the small black triangle top right. With this kind of outline numbering you get a lot of automatism, like TOC, tree in the navigator, automatic targets for cross-refernces. Do not follow any advises to use list numbering for headings. It is not impossible but you need a lot of deeper knowledge to use it correctly. Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@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: [3.5.3.2/Calc] Multiply percentage with fraction?
At 18:55 09/07/2012 +0200, Andreas Säger wrote: At 08:54 09/07/2012 -0400, Dan Lewis wrote: Have you formatted your C1 and C2 columns correctly? The OP gets the #NAME error. What is a correctly formatted cell? Can you demonstrate us a single case where any formatting attribute has any influence on the cell value? [Shoots hand into the air.] Oh, sir! Please, sir! I know, sir! If you enter, say 1.23% into a cell with numeric or general formatting, you get a number with the expected value and expressed as a percentage. But if the cell is previously formatted as text, you get the text string 1.23%, which is, of course, different. In contexts where the numerical value of a text string is taken as zero in a calculation, there will indeed be a difference. Now you'll say that this sort of formatting in advance was not what you meant, and that may be so. But it *is* what your questioner may have meant. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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: CALC - How to count blank cells?
On 09/07/12 20:35, Andreas Säger wrote: Am 09.07.2012 10:22, MiguelAngel wrote: El 09/07/12 3:31, Simon Cropper escribió: On 09/07/12 11:01, Michael Reich wrote: On 7/4/12 11:00 AM, users+h...@global.libreoffice.org wrote: Subject: Re: [libreoffice-users] CALC - How to count blank cells? From: MiguelAngel mari...@miguelangel.mobi Date: 7/4/12 3:44 AM To: users@global.libreoffice.org El 04/07/12 5:16, dave wagner escribió: I have a small range of cells (less than 100) in which I need to count the cells that are blank. What is the best way to do this? I was trying something like =COUNTIF(C11:C103,(CELL(Type,b))).But that just did not work. Thanks to all who helps me with this simple problem. =SUMPRODUCT(ISBLANK(C11:C103)) Miguel Ángel. In a related (I think) question, what formula could be used to identify the last row in a spreadsheet with data in it? It's a similar situation as the OP, in which new data is inserted as a new row at the bottom of the sheet. I want another worksheet to be able to pick up certain fields from the last row of data, but haven't been able to figure out how to locate which row is last (with data). A1=a A2=b A3=c A4=d What I'm looking for is a formula that would tell me, in the above data, that row 4 is the last one with data. Thanks for any help! I know that this is not what you asked for exactly, but coupled with CELL() or COUNTBLANK() function, might allow you to establish the row number in your situation. The following allows me to get the last value of the column (F) in sheet1 (used in my case in a summary table that lists the final value in a column that lists the running balance of my bank account)... =OFFSET($'sheet1'.$F$6,COUNTA($'sheet1'.$F$6:$'sheet1'.$F$9633)-1,0) Assumes the range $F$6: to $F$9633 has continuous data - essentially it returns the number of rows/cells with data, so will not work if your array or range has blanks (unless the number is static or can be predicted). So in your example... COUNTA(A1:A1000) will return 4, knowing that you start from A1 allows you to extrapolate that the last row is A4. =SUMPRODUCT(MAX(NOT(iSBLANK(c11:c999))*ROW(c11:c999))) give the number of the last row with data in the range. Miguel Ángel. And all these tricks are completely obsolete if you know how to navigate, expand and edit spreadsheet ranges with a couple of keystrokes. By the way: If you would use a database in the first place the editor of your data would not even need to know that. No doubt but Michael asked a question and others helped by answering. If he wanted to know how it should be done or what would be the best way of achieving an end result I presume he would have asked. The fact is he did not actually provide any guidance to why he needed to do what he asked (which is quite common on this forum), only asked if it could be done. IMHO, the tone and content of your response is not very helpful and belittles other peoples attempts to assist. Outlining the keystrokes mentioned and how databases might assist in what you presume he needs would have been more useful. -- Cheers Simon Simon Cropper - Open Content Creator Free and Open Source Software Workflow Guides Introduction http://www.fossworkflowguides.com GIS Packages http://www.fossworkflowguides.com/gis bash / Pythonhttp://www.fossworkflowguides.com/scripting -- For unsubscribe instructions e-mail to: users+h...@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
