[libreoffice-users] LibreOffice Base -Queries...
I have a database Reactors_Videos and three of the fields are: No (Field Type = Number (Numeric) First (Field Type = Date (DATE) Last (Field Type = Date (DATE) I successfully created a Query to display the total number of Reactions. This Query takes the form SELECT SUM( "No" ) FROM "Reactor_Videos Table 1" I am now trying to create a Query which will display the number of reactions between any two dates but failing miserably Most of them return the error : SQL Status: HY000 Error code: 1000 Syntax error in SQL statement" and an internet search reveals that this error is returned for any number of reasons, none of which are helpful to me (perhaps because of my lack of knowledge) My latest attempt was SELECT SUM( "No" ) FROM "Reactor_Videos Table 1" HAVING ( ( COUNT( "First" ) = 1 / 12 / 20 AND COUNT( "Last" ) = 31 / 12 / 20 ) ) This saved without any error messages but running the query results in no output As will be apparent, my knowledge of the SQL language is minimal at best and any help members are able to offer will be very welcome. Zed -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...
Using LibreOffice Base v6.4.5.2 on Linux Mint v20.0 Thanks to the assistance given by members of this Mailing List, I have made progress in creating a database using LibreOffice Base. I have created a database Reactor_Videos which has the fields (1) Reactor_Videos Table 1 ID Name (of Reactor) Location (Country of residence) Gender Number (of times an artist has been featured) First (date artist first featured) Last (Last date artist featured) and the contents of the spreadsheet I used to record data was copied to the Table Reactors_Video Table 1. I created a form - Reactor_Videos_Form from that Table - and have used that to enter or update new information. It is quick and I am now getting to grips with creating Queries. The Table has many Reactors but at present the information relates only to one artist and the only information is the first and last date a particular Reactor reacted to her. (2) My next step is to have the ability to not only (a) choose a Reactor (3) but also to (b) choose from a list of artists (c) choose the song the artist is singing (d) choose the type of venue at which the performance took place Bearing this in mind, I created three more Tables. (4) Artist (which has fields) IDArtist Name Date of birth Country of birth Country of residence (5) Songs/Performances (which has fields) IDPerformance Title (6) Venue (which has fields) IDVenue Concert - indoor Concert - outdoor Studio - home Studio - recording Private gathering My first thought was to have the entire database in one Table, differentiating the sectors by using different titles for the ID field, e.g. ID as an Integer (for the Reactor), IDArtist for the artist as an Integer etc. I created the IDArtist as an Integer but when I tried to save it I got the error message. Column constraints are not acceptable in Statement [ALTER TABLE "Table1" ADD "IDArtist" INTEGER NOT NULL IDENTITY] When I click on More I see SQL Status:S1000 Searching on the internet does not help me as it reveals information current about 2015. I then created Forms from the Tables Artists, Songs/Performances, and Venue with the intention place them on the main form (Reactor_Videos_ Form) and link them, to achieve my objective in (3) above but despite searching the LO Base Manual and watching and listening to tutorials on YouTube, I have been unsuccessful in seeing a way forward. Any help from members to set me on the right path to achieve what I am attempting will very welcome. Zed -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...
Hi Robert On 2/08/20 6:37 pm, Robert Großkopf wrote: Hi Zed, The Table has one field named "Gender" and the gender is indicated by F, or M or M/F where a family is involved. What I was trying to achieve was a query which extracted the total numbers for each gender (e.g. 50, M25, M/F13) between a particular time period. In this case the period was BETWEEN 01/07/2020 AND 31/07/2020 I have found several web pages which explain the syntax for SQL but, at my present level of knowledge, they are beyond my understanding :-) You could show the code here. Might be something like SELECT "gender", COUNT("gender") AS "number" FROM "table" WHERE "date" BETWEEN '2020-07-01' AND '2020-07-31' GROUP BY "gender" Could also be you will show other content in the same query. Then you have to create correlated subqueries. Thank you again for your prompt reply. I'll work through the code you have given me and report back. It may be a little while, though as "real" life is tending to be interfering with what "I" feel is more important :-) Zed -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...
Attention: Robert Grosskopf My apologies for not following convention and replying in the normal manner but I rather foolishly deleted your advice by mistake, The information you gave me regarding my request for help on how to construct a query was just the guide I required to solve my problem. I was also able to construct two other queries. In one I was successful in extracting the information I required but not so successful in the second. The Table has one field named "Gender" and the gender is indicated by F, or M or M/F where a family is involved. What I was trying to achieve was a query which extracted the total numbers for each gender (e.g. 50, M25, M/F13) between a particular time period. In this case the period was BETWEEN 01/07/2020 AND 31/07/2020 I have found several web pages which explain the syntax for SQL but, at my present level of knowledge, they are beyond my understanding :-) Zed -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Base (previously copying data from Calc to Base)...
On 1/08/20 2:14 pm, Dan Lewis wrote: Comments inline: On 7/31/20 20:14, zed wrote: Thank you to all the members who replied so promptly to my request for help. It is very much appreciated. One member sent me advice of another method to achieve what I wanted and I am delighted to say it worked and I now have a database with the fields I need, with one Table and one Form. I'm delighted with what I have achieved but have a couple of queries. I have a field named "Location" in which I enter the declared location of a Youtube channel owner. In Calc, the name of a Location is remembered and if I start typing it again it automatically appears. It doesn't happen in Base. Is there a way to "auto-complete" in Base? You can accomplish this using a list box. It is somewhat limited in that the table linked to this box contains all of the locations. (A combo box is suppose to do this, but this is not always working correctly.) One other thing I am having difficulty with,because of my current lack I used it for the first time this morning and have come across a small problem.of knowledge of databases, is how to sum a column of figures. I have a field named "No." and another named "First" and I want to choose a start date from the field "First" and get the sum of the numbers in the field "No" Is this possible, please? For this I recommend a query. The two fields for it would be "No" and "First". For "No", select the function "sum". For "First", its criterion should be: >mm/dd/yy where this is the start date. Make sure that the "First" column does NOT have a check mark for visibility. There is now a Base User Guide. (6.4) which should be able to answer your questions. This mailing list has people to answers questions as well. You can download the entire guide or individual chapters; ODT and PDF https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide Hi Dan Thank you for your very prompt reply. I followed your instructions and it returned the sum of entries on the date entered. I obviously didn't phrase my questions clearly enough, for what I wanted was the sum of all entries for the period 01/07/2020 to 31/07/2020. I cannot find how to achieve what I want. so your further assistance would be very much appreciated. zed -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] LibreOffice Base (previously copying data from Calc to Base)...
Thank you to all the members who replied so promptly to my request for help. It is very much appreciated. One member sent me advice of another method to achieve what I wanted and I am delighted to say it worked and I now have a database with the fields I need, with one Table and one Form. I'm delighted with what I have achieved but have a couple of queries. I have a field named "Location" in which I enter the declared location of a Youtube channel owner. In Calc, the name of a Location is remembered and if I start typing it again it automatically appears. It doesn't happen in Base. Is there a way to "auto-complete" in Base? One other thing I am having difficulty with,because of my current lack I used it for the first time this morning and have come across a small problem.of knowledge of databases, is how to sum a column of figures. I have a field named "No." and another named "First" and I want to choose a start date from the field "First" and get the sum of the numbers in the field "No" Is this possible, please? Regards from New Zealand on a very cold but fine winter's afternoon, Zed -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Copying data from Calc to Base...
Using LibreOffice Base v6..4.2.2 on Linux Mint v20.0 Mate I am trying to copy and paste a LibreOffice Calc file from that program to Base. Here is what I have done so far. Calc - created spreadsheet A = ID (Default format) B = Name (Default format) C = Location (Default format) D = Date - First (Format as DD MMM ) E = Date - Last (Format as DD MMM ) Base: Created a database named Reactors and created fields: ID Interger [INTEGER] Name Text [VARCHAR] Location Text [VARCHAR] Gender Text [VARCHAR] No. Number [NUMERIC] Date - First Date [DATE] Date - Last Date [DATE] Opened spreadsheet and highlighted columns (as listed above) (as a test I chose only Rows 1-6) Chose Copy and navigated to Database and clicked to Paste From Menu presented, chose Append data (the default option) clicked Next and unticked ID clicked Create and following error message was displayed Warning. Wrong data type:java.lang.IllegalArgumentException. Searched both Internet (in general) and LibreOffice website (in particular) but found nothing to help. Obviously I am doing something wrong but I am unable to find the error.All help will be very welcome. Zed -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
Johnny Rosenberg wrote: > Den ons 11 dec. 2019 kl 05:51 skrev zed : > > > Hi! > > > > Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate > > > > I have a spreadsheeet in Calc which records data of reactions to a > > particular performer. It is in the form: It has Columns A - G. > > > > A - Name, fformatted as Text (records thre name of the persons doing the > > reaction) B - No, formatted number general (records number of times this > > reactors has reacted to the performer) C - First, formatted DD/MM/YY > > (records the first date the reactor reaacted to this performer) D - > > Last, formatted DD/MM.YY (records last date reactor reacted to this > > performer) E - Days, formatted =NOW()-D3 (records number of days since > > last reaction) F - Weeks, formatted =E3/7 (records number of weeks since > > last reaction) G - Months, formatted =F3/4 (records number of months > > since last reaction. reaction) > > > > Is there a formula that I can enter in Column B which will increase > > incrementally increase the figure by 1, please? > > > > Regards from New Zealand on a very warm summer evening. > > > > David -- Zed > I'm not sure I understand what you are asking for here. So in column A, > there are names, as you said, and in column B there's a number that tells > you how many times the name in Column A appeared so far? Then I guess the > following would work: B1: =IF(A1="";"";COUNTIF(A$1:A1;A1)) Click and drag > the formula downwards. Now, for instance B17 looks like this: > =IF(A17="";"";COUNTIF(A$1:A17;A17)) The IF is just to not display a zero > when nothing is entered into the corresponding A line. Thank you for your quick response. Unfortunately that didn't work. That was probably because I didn't explain myself carefully enough. Have a look at my answer to Brian Barker, where I try to be clearer in what I'm trying to achieve. If there is a solution I will think all my Christmases have come at once! But I am resigned to the fact that there probably isn't. David -- Zed "I have often regretted my speech, never my silence." Xenocrates (396-314 B.C.) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...
Brian Barker wrote: > At 17:49 11/12/2019 +1300, David Noname wrote: > > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted > > number general ... > > > > Is there a formula that I can enter in Column B which will increase > > incrementally increase the figure by 1, please? > > I think you are saying that you want values in column B to be one greater > than they are. That's a contradiction. If the value in Bn is four, you > want it to be five. But that means it's no longer four. And if it's now > five, how would any formula know you do not want it to be six? And so on? Thank you for your prompt reply, Brian. It is much appreciated Perhaps I didn't explain myself clearly enough. In simple terms, I want to know whether there is any way that when I enter a new date in Column D it will automaticall increase the current value in Column B by 1. I cannot think of a solution - but then I only use Calc for simple things - but was hoping that there is a solution. If there isn't, I will just have to try and remember to manually increase the value of Column B every time I enter a new date in Column D. David -- Zed Smoking kills. If you're killed, you've lost a very important part of your life. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] LibreOffice Calc - Date - increase number times...
Hi! Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate I have a spreadsheeet in Calc which records data of reactions to a particular performer. It is in the form: It has Columns A - G. A - Name, fformatted as Text (records thre name of the persons doing the reaction) B - No, formatted number general (records number of times this reactors has reacted to the performer) C - First, formatted DD/MM/YY (records the first date the reactor reaacted to this performer) D - Last, formatted DD/MM.YY (records last date reactor reacted to this performer) E - Days, formatted =NOW()-D3 (records number of days since last reaction) F - Weeks, formatted =E3/7 (records number of weeks since last reaction) G - Months, formatted =F3/4 (records number of months since last reaction. reaction) Is there a formula that I can enter in Column B which will increase incrementally increase the figure by 1, please? Regards from New Zealand on a very warm summer evening. David -- Zed "To use the term blind faith, is to use an adjective needlessly." Julian Ruck -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] word count in impress
Toki <toki.kant...@gmail.com> wrote: > On 10/03/2017 07:46 AM, Krunose wrote: > > And yes, seams something wrong with word count of html documents > > opened in Writer. My test document has 62 words. Saved it as html, > > opened it in Writer, counter says 70. But when I count by hand - still > > 62 words on screen. > > This gets into what constitutes a word. Definitions here are crucial. In > your example, you gave both 62 and 70 as options. * If the 70 is based > upon a printer's word, then there are 84 words, as counted by typists; * > If the 70 is based upon a typist's word, then there are 58 words, as > counted by printers; * If the 70 is based upon one of the other > definitions of a word, then there are at least two more equally > legitimate values that _accurately_ state the number of words in the > text; > > Getting back to Thomas' issue. How does the contract in question define > "word"? Once that is known, then an explanation of how to accurately > determine the number of words in the Impress file can be provided. When I learnt touch typing, way back in the '60s, the average word was deemed to be five keystrokes, e.g. the word "thaw+hittingn the spacebar" counted as a word for determining "words per minute typed. And, of course, a word such as "costumier+spacebar" would count as two words, etc. Zed zed Diplomacy: The art of letting someone else get your way. -- 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] FontForge - converting fonts...
I've been very interested in the discussion of the problems users are having in LO5.4.1.2 not reading fonts. Someone mentioned that he had converted a font to one LO had no trouble finding, So I thought I would try and do the same . Downloaded FontForge with the purpose of converting Garamond Adobe fonts to a format which LO 5.4.1.2 can read. When I open the Garamond fonts in Font Forge they are displayed ugmm8a.pfb ugmmi8a.pfb ugmmr8a.pfb ugmmri8a.pfb Clicking on any one of them displays an edit window and I presume that I should be able to convert each to something other than .pfb but have no idea how to do it. I have looked at several utube videos but they do not cover conversion from one font type to another, concentrating upon creating new fonts. I tried to access the fontforge website but after some twenty minutes of waiting for it to load, without success, I gave up. All advice would be welcome, as the Garamond font is used for my business letterhead. zed -- zed Divorce, n. The past tense of marriage -- 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] missing in Calc 5.1.5.2
FHDATA <fhd...@unm.edu> wrote: > > hello, > > Version: 5.1.5.2 Build ID: 7a864d8825610a8c07cfc3bc01dd4fce6a9447e5 > > > I just upgraded to this new version and I am finding that somethings in > Calc are missing: > > Upto this point in life of libreoffice, I used to go to Edit and there > were 'Fill up' , 'Fill Down' etc allowing me to copy things to row(s) > and column(s)... > > they are missing now. > > > is this for real? or am I not finding their new location? You will find it in Sheet > Fill cells > drop down menu Note: I am using v5.1.4.2 but presume the change has been carried over. zed -- zed Dogs think they are human. Cats believe they are God -- 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: justification issues (was: [libreoffice-users] Libre Writer 5.1.1.3 - space correction between text words)
Mike Scott <v...@scottsonline.org.uk> wrote: > On 29/04/16 05:45, Brian Barker wrote: . > > Text can be distributed within lines in various ways: left aligned, > > centred, right aligned, or justified. The first three modes will > > maintain constant, standard spacing between words, but the last > > intentionally expands spaces between words in order to fill all lines > > with text between the margins. If you don't want your text justified, > > don't use that mode. The mode is specified on the Alignment tabs of > > the Paragraph and Paragraph Style dialogues. > > > > Can I interject a long-standing issue here, in which LO is by no means > the sole offender? > > It seems that full justification is always done linewise with no > look-ahead. What's done seems something "gather words on a line until > the next one won't fit; add spaces to this line to justify". [snip] > Sample: try putting this into an A4 page, 2cm margins, TNR 12pt, fully > justified). You should get 4 lines, of which the third has 3 long words > with large spacing. > > F ads dfg sdfg sdffg sdfg sdfg sdf gsd fgs dfg sdfg sdf gsd fgsdf F ads > dfg sdfg sdffg sdfg sdfg sdf gsd fgs dfg sdfg sdf gsd fgsdf F ads dfg > sdfg sdffg sdfg sdfg sdf gsd fgs dfg sdfg XXX gsd fgsdf > ddd sss > dfg sdfg sdf > gsd fgs dfg sdfg sdf gsd fgsdf Using LM17.3 Mate. LO v5.0.3.2 Very strange here. Copy and pasted sample and set margin, text type and text size as suggested and then did copy + paste. Text appeared as above. In turn tried Align left (did as expected), Align right (did as expected) Align centre (did as expected) Justify (text remained as pasted). zed -- zed A social life ? What board can I download That from? -- 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] LibreOffice 5.0 Review Rating | PCMag.com
James Knott james.kn...@rogers.com wrote: On 08/18/2015 04:24 PM, zed wrote: James Knott james.kn...@rogers.com wrote: I just came across this article. http://www.pcmag.com/article2/0,2817,2418419,00.asp?mailing_id=1431647mailing=whatsnewnowmailingID=E2768DCC83E0602F9C1DB70A73032992 The review seems to be of LibreOfice v4.0. So, a little out of date :-) David Someone else, possibly from Australia also saw 4.0, whereas I see 5.0. I guess that's what happens when you're upside down. ;-) ...but I had the monitor upside down, too! David -- zed Whenever you find that you are on the side of the majority, it is time to reform. -- Mark Twain -- 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] LibreOffice 5.0 Review Rating | PCMag.com
James Knott james.kn...@rogers.com wrote: I just came across this article. http://www.pcmag.com/article2/0,2817,2418419,00.asp?mailing_id=1431647mailing=whatsnewnowmailingID=E2768DCC83E0602F9C1DB70A73032992 The review seems to be of LibreOfice v4.0. So, a little out of date :-) David -- zed A running mate is a husband who dared to talk back -- 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] Formulas...
Marc Grober m...@interak.com wrote: D4 and E10 are cells not columns as a result it is unclear what you mean by copy E10 down so that D4 is the constant. What exactly are yo trying to accomplish? My apologies for confusing you Yes, I should have called them cells and not columns and I regret the error. Fortunately, some other members twigged what I meant and gave good advice. Zed -- Zed Do married people live longer, or does it just seem that way? -- 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] Formulas...
Zed z...@zed.net.nz wrote: It is so long since I used the Formula I'm looking for that I have forgotten what it is. Here is my problem I have a column, say, D4 in which I have a constant figure, say, 100 Another column E10 , let's call it Production, contains a figure of, say, 79 I can establish that 79 is 79% of actual production by entering the formula =E10/D4 and then Formatting the expression to Percentage. But I cannot remember the formula to copy E10 down so that D4 is the constant. I have tried E/10/D4, E10/$D4, $E10/D4, $E10/$D4 and then Filled Down without obtaining the correct answer. If anyone on the list is able to help me, I'd be most gratefu, Thank you Miroslave Zalewski, Tom Davis and Johnny Rosenberg for suggesting suitable solutions. It is verr much appreciated. Zed -- Zed A Closed Mouth Gathers No Foot -- 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] Formulas...
It is so long since I used the Formula I'm looking for that I have forgotten what it is. Here is my problem I have a column, say, D4 in which I have a constant figure, say, 100 Another column E10 , let's call it Production, contains a figure of, say, 79 I can establish that 79 is 79% of actual production by entering the formula =E10/D4 and then Formatting the expression to Percentage. But I cannot remember the formula to copy E10 down so that D4 is the constant. I have tried E/10/D4, E10/$D4, $E10/D4, $E10/$D4 and then Filled Down without obtaining the correct answer. If anyone on the list is able to help me, I'd be most gratefu, Zed Desk - A very large wastebasket with drawers. -- 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: Trivia Question - Further Observation
Richard rich...@hornick.us wrote: HELP!!! I am receiving 20 and more emails daily. I have tried many, many times to unsubscribe with NO SUCCESS. PLEASE give me an email, land line, snail mail address, or phone number where I can UNSUBSCRIBE. The following appears at the bottom of every post you receive. Unsubscribe instructions: E-mail to users+h...@libreoffice.org Zed -- Zed COMPUTER LITERACY? You mean my computer can READ?! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] A Sort problem...
Using LibreOffice 3.3.1 on LinuxMint Debian Edition (LMDE) I have created a spreadsheet in Calc as a Customer database, which I will save as a CSV file and use to create form letters. The columns are: Firstname, Surname, Street, Town, City, Postcode, Salutation. I originally sorted them Surname, Firstname, Town and got what I expected. However, somehow I have made a complete pigs ear with a subsequent sort, and for the life of me I cannot remember the three fields on which I chose to sort, and the Salutation field is now not aligned with the correct surname. For example, the customer name is Faye Abel and the Salutation should be Dear Faye. However it is Dear Marion! My question is, apart from completely retyping the correct Salutation, is there any sort method by which i can have the correct salutation aligned with the correct surname? Zed -- Zed Bachelor: A guy who has cheated a woman out of a divorce. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] LibreOfficeCac...
Using libreoffice vLibreOffice 3.3.0 OOO330m19 (Build:5) tag libreoffice-3.3.0.3, on LinuxMint Debian Edition. Created two columns of figures (a) Col B consists of 34 rows of figures. Rows B9, B16, B20, B29, B34 are total categories, shown as figures not formula. (b) Col C has figures in rows C8, C13, C14, C15, C19, C23. (c) adding the figures in the rows given in (a) above, i.e. =B9+ B16+B20+B29+B34 returns the error #VALUE!. I tried enclosing in brackets with the same result. (d) In Col C. Highlighting rows C5:C34) and then hitting SUM only returns the value of C23. Adding C8+C13+C14+C15+C19+C23 returns the error message #VALUE. Has anyone else come across this, please? It appears to be a bug. Incidentally, I do not have the same problem if I use OpenOffice Calc. All works as expected. Zed -- Zed A sense of humor is just common sense, dancing. --William James -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] LibreOffice on LinuxMint Debian Edition...
Fabián Rodríguez magic...@member.fsf.org wrote: On 11-01-17 06:02 PM, Zed wrote: [..] A search for the package leads to Ubuntu PPAs but as I am using the Debian edition of LinuxMint, I am reluctant to use these, in case there are future problems. Any further advice would be appreciated. Zed Hi Zed, I would use the .deb packages for now if I were you. I couldn't find any references to LibreOffice in the LMDE community resources. The Ubuntu PPA is bound to have specific tweaks for Ubuntu and if you have any bugs you won't be able to file them there as the bug tracker is for the Ubuntu version running on Ubuntu. OTOH if you use .debs you can file bugs in Mint [1] or upstream at FreeDesktop.org [2]. As Terry and Alexander indicated, you need the lang pack to be installed first. In a few steps: [snip] information read and used. Thank you Fabian and all the other helpful people on the list. I did as suggested and installed the packages in the correct order and everything is working, other than that the Spellchecker does not work. In ToolsLanguageSelectText - English (NZ) is checked but when I type a word incorrectly, e.g. color instead of colour, the word is not highlighted as mispelt. Even a series of characters typed at random are not highlighted as incorrect. The only languages shown are English (NZ) and English (USA) even though English (GB) is shown as installed in Synaptic. Any advice how I can get the spell checker working, please? It is probably something I have done incorrectly but I cannot think waht :-( Zed -- Zed Q: Why are Blonde jokes so short? A: So men can remember them. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] libreoffice calc can't do simply calculation
henry cui hhenry@gmail.com wrote: I input simply formulation such as =1+2 into cell,and it only show with =1+2 which was not what I expected 3, why this,anyone would like help me? I've just done this and it returns 3, as expected. The correct answer is shown whether one just hits the Enter key or clicks on the green tick. HTH Zed -- Zed Diplomacy: The Vaseline of political intercourse -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] LibreOffice on LinuxMint Debian Edition...
I have downloaded libreoffice-build-3.3.0.1 to install on my Desktop, which is running LMDE (a Mint edition based on Debian) Pasted below is the result of my ./configure comaand zed@zed ~ $ sudo -s [sudo] password for zed: zed zed # cd /home/zed/Downloads/Linux/Extracted/libreoffice-build-3.3.0.1 zed libreoffice-build-3.3.0.1 # ./configure bash: ./configure: Permission denied zed libreoffice-build-3.3.0.1 # and the question is Why am I getting this error when I am logged in as root? Zed -- Zed Looking Good! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] LibreOffice on LinuxMint Debian Edition...
MR ZenWiz mrzen...@gmail.com wrote: On Mon, Jan 17, 2011 at 11:41 AM, Zed z...@zed.net.nz wrote: I have downloaded libreoffice-build-3.3.0.1 to install on my Desktop, which is running LMDE (a Mint edition based on Debian) Well, yes - Mint is a derivative of Ubuntu, which is a derivative of Debian. Pasted below is the result of my ./configure comaand zed@zed ~ $ sudo -s [sudo] password for zed: zed zed # cd /home/zed/Downloads/Linux/Extracted/libreoffice-build-3.3.0.1 zed libreoffice-build-3.3.0.1 # ./configure bash: ./configure: Permission denied Usually this means that you haven't set the permissions to allow configure to execute. I am curious, though - have you tried downloading and installing the Debian (*.deb) files for LO? I use LO on Ubuntu and it installed and works just fine ootb. Thank you for a very prompt response. I have now dowloaded and installed the Debian (*.deb) files and all is working. However, when I try to install the GB (English) pack (LibO_3.3.0rc3_Linux_x86-64_helppack-deb_en-GB), I get the error message zed@zed ~ $ cd /home/zed/Downloads/LibO_3.3.0rc3_Linux_x86-64_helppack-deb_en-GB/DEBS zed@zed ~/Downloads/LibO_3.3.0rc3_Linux_x86-64_helppack-deb_en-GB/DEBS $ sudo dpkg -i *.deb [sudo] password for zed: (Reading database ... 209231 files and directories currently installed.) Preparing to replace libobasis3.3-en-gb-help 3.3.0-19 (using libobasis3.3-en-gb-help_3.3.0-19_amd64.deb) ... Unpacking replacement libobasis3.3-en-gb-help ... dpkg: dependency problems prevent configuration of libobasis3.3-en-gb-help: libobasis3.3-en-gb-help depends on libobasis3.3-en-gb; however: Package libobasis3.3-en-gb is not installed. dpkg: error processing libobasis3.3-en-gb-help (--install): dependency problems - leaving unconfigured Errors were encountered while processing: libobasis3.3-en-gb-help Trying to install that package leads to zed@zed ~ $ sudo apt-get install libobasis3.3-en-gb Reading package lists... Done Building dependency tree Reading state information... Done Package libobasis3.3-en-gb is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source E: Package 'libobasis3.3-en-gb' has no installation candidate A search for the package leads to Ubuntu PPAs but as I am using the Debian edition of LinuxMint, I am reluctant to use these, in case there are future problems. Any further advice would be appreciated. Zed -- Zed Dead Atheist: All dressed up with no place to go. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] LibreOffice on LinuxMint Debian Edition...
Joachim Wiedorn ad_deb...@joonet.de wrote: MR ZenWiz mrzen...@gmail.com wrote on 2011-01-17 12:34: On Mon, Jan 17, 2011 at 11:41 AM, Zed z...@zed.net.nz wrote: I have downloaded libreoffice-build-3.3.0.1 to install on my Desktop, which is running LMDE (a Mint edition based on Debian) Well, yes - Mint is a derivative of Ubuntu, which is a derivative of Debian. It seems Mint switched to Debian in September 2010 (see Linux-User 02.2011 of Germany). Yes, I changed to the Debian Edition at that time. It has worked flawlessly! [snip] I am curious, though - have you tried downloading and installing the Debian (*.deb) files for LO? I use LO on Ubuntu and it installed and works just fine ootb. This is the easier way - which I have done, too. Then LO runs in not more then two minutes. Then installing dictionaries ... two more minutes. Perfectly! As you will see, I've now taken the advice of MR ZenWiz and installed the Debian package. However, I've run into further problems. See my reply to MR ZedWiz. --- Have a nice day. and the same to you, too. Joachim (Germany) Zed in New Zealand. Zed -- Zed What is a cynic? A man who knows the price of everything, and the value of nothing. (Oscar Wilde) -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Happy 2011
Eliane Domingos de Sousa elianedomin...@edx.srv.br wrote: Good afternoon, Happy New Year! http://www.revistabroffice.org/repositorio/anonovo-libreoffice3.jpg and a Happy New Year to you, Eliane, from New Zealand. I take this opportunity, too, to wish all subscribers all the best for 2011l with the fervent wish that LibreOffice will continue its success. Zed -- Zed A program is used to create error messages! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***