Re: [libreoffice-users] Reduce white space between chart border and chart
As always from your methods- that's perfect and exactly what was needed. Thanks Brian. CarlFrom:Brian Barker [mailto:b.m.bar...@btinternet.com] Subject:[libreoffice-users] Reduce white space between chart border and chart Date:Wednesday, June 12, 2019, 5:08 PM To:users@global.libreoffice.org Cc:Carl Winerich At 15:42 12/06/2019 -0400, Carl Winerich wrote:How can I reduce the amount of white space between a chart and the border/margin around it?I'm not sure you can. But what you can do, with the same effect, is to use Format Chart Area to set the transparency of the chart area to 100%. This will mean that you can position the chart overlapping whatever elements you want to be closer to it and they will show through as if that unwanted surround were not there.I trust this helps.Brian Barker -- 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] Reduce white space between chart border and chart
How can I reduce the amount of white space between a chart and the border/margin around it? Thanks, Carl -- 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] Message body messed up appearance
How in the world do I fix the message body appearance so it doesn't return the message disorganized and jumbled together? Thanks, Carl -- 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] Fwd: Formula returns incorrect result
No idea how this gibberish got returned I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1 Greenwich Mean Time. Then I want to plot the EoT curve (a project for later, not now)The following is the formula I use on my calculator. The formula gives a "close enough" EoT9.87xsin(2x360(3-81)÷365)-7.67 x sin(360(3-81)÷365+78.7)= -4.584625249 (or -4 minutes 35.1 seconds...plus or minus)Calc doesn't give the same answer. Here's the formula in calc;=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))The answer it returns is: -2.1488359093Can you tell me what the correct layout of the format in calc is?Thank you,Peter -- 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] Formula returns incorrect result
I'm trying to calculate the Equation of Time (EoT) to determine the difference between LAN (Local Apparent Noon) and GMT/UT-1 Greenwich Mean Time. Then I want to plot the EoT curve (a project for later, not now)The following is the formula I use on my calculator. The formula gives a "close enough" EoT9.87xsin(2x360(3-81)÷365)-7.67 x sin(360(3-81)÷365+78.7)= -4.584625249 (or -4 minutes 35.1 seconds...plus or minus)Calc doesn't give the same answer. Here's the formula in calc;=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))The answer it returns is: -2.1488359093Can you tell me what the correct layout of the format in calc is?Thank you,Peter -- 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: [SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell
Solved the problem. All I had to do was the following; Format the selected calendar cell as follows; DD (then a bunch of spaces) WW The result returned was the correct calendar date number and the current week of the year. Now all I have to figure out is how the get the day-number-of-the-year in there. Thank you, all, for your efforts. Carl On 07/12/2018 04:12 AM, Brian Barker wrote: > At 19:30 11/07/2018 -0400, Carl Winerich wrote: >> It's back to the same old question; ... > > Indeed so - and the answer is very much the same as on the previous > two occasions you have asked this. > >> In a calendar, how can I put the day's date (number only) and week >> number and day-number-of-the-year in one cell? > > To put multiple items in one cell, you must concatenate the individual > values. You can do this using the CONCATENATE() function: > =CONCATENATE(;;) > or probably more easily using the & operator: > =&& > - where , , and represent your items - references or > formulae. > > Note that you will have to take care of spacing, so you may need > something like > =&" "&&" "& > instead. > > Note that concatenation - expressed either way - both requires and > produces text items. If you pass it numeric values, these are > converted to text automatically on the fly. If you want more control > over exactly how a value is represented, you may want to do the > conversion yourself, using the TEXT() function, which allows you to > specify the format of the converted value. So if you wanted, say, all > your dates to appear as two-digit numbers, so the first of the month > was "01" instead of just "1", your formula might start > =TEXT(;"00")&" "& ... > >> Particularly in cell A5, B5...etc which are all cells that contain >> only the day number of the month. Here's a link to the Calc calendar >> template I'm trying to use- >> https://extensions.libreoffice.org/templates/calendar-creator The >> template is very useful and I don't want to interfere or mess up the >> calendar creation - which it does perfectly. > > You'll have to puzzle out how to derive formulae for the required two > new values for yourself, unless the answers are buried somewhere in > the existing template. The functions WEEKNUM(), WEEKNUMADD(), and > DAYS() may help. You can read the existing formulae in your template > by selecting relevant cells and looking in the Input Line for each, of > course. > > I trust this helps. > > Brian Barker > -- 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: [SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell
On 07/12/2018 04:12 AM, Brian Barker wrote: At 19:30 11/07/2018 -0400, Carl Winerich wrote:It's back to the same old question; ...Indeed so - and the answer is very much the same as on the previous two occasions you have asked this.In a calendar, how can I put the day's date (number only) and week number and day-number-of-the-year in one cell?To put multiple items in one cell, you must concatenate the individual values. You can do this using the CONCATENATE() function:=CONCATENATE(one;two;three)or probably more easily using theoperator:=onetwothree- whereone,two, andthreerepresent your items - references or formulae.Note that you will have to take care of spacing, so you may need something like=one" "two" "threeinstead.Note that concatenation - expressed either way - both requires and produces text items. If you pass it numeric values, these are converted to text automatically on the fly. If you want more control over exactly how a value is represented, you may want to do the conversion yourself, using the TEXT() function, which allows you to specify the format of the converted value. So if you wanted, say, all your dates to appear as two-digit numbers, so the first of the month was "01" instead of just "1", your formula might start=TEXT(one;"00")" "...Particularly in cell A5, B5...etc which are all cells that contain only the day number of the month. Here's a link to the Calc calendar template I'm trying to use-https://extensions.libreoffice.org/templates/calendar-creatorThe template is very useful and I don't want to interfere or mess up the calendar creation - which it does perfectly.You'll have to puzzle out how to derive formulae for the required two new values for yourself, unless the answers are buried somewhere in the existing template. The functions WEEKNUM(), WEEKNUMADD(), and DAYS() may help. You can read the existing formulae in your template by selecting relevant cells and looking in the Input Line for each, of course.I trust this helps.Brian BarkerBrian,I understand the WEEKNUM, and DAYS functions. Maybe the real problem is within the cell A5?Existing cell (for the month of February) has the following formula;=$G30-$H30+$D32+$E32+COLUMN(A5)That stuff points to various parts of the spreadsheet and returns the correct numeric day number of the month.When I try to concat it with, say, =DAYS then Err:510 appears in the cell. Any variation of the data produces a similar error.=$G30-$H30+$D32+$E32+COLUMN(A5)" "=DAYS(A5,$January.A5)+1I've successfully used concat or =text...etc as you suggested and placed the formula in other blank cells in an unused portion of the spreadsheet and have obtained the desired result. But for simplicity it would be best to have the formula and result in the correct cell.Any ideas?Thank you,Carl -- 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] date, day number, week number in one cell
My apologies for the messed up format. Here's a better version; It’s back to the same old question; In a calendar, how can I put the day’s date (number only) and week number and day-number-of-the-year in one cell? Particularly in cell A5, B5...etc which are all cells that contain only the day number of the month. Here’s a link to the Calc calendar template I’m trying to use- https://extensions.libreoffice.org/templates/calendar-creator The template is very useful and I don’t want to interfere or mess up the calendar creation- which it does perfectly. Thank you, Carl On 07/11/2018 07:30 PM, Carl Winerich wrote: > p { margin-bottom: 0.1in; line-height: 120%; }p.western { font-family: > "Ubuntu"; }p.cjk { font-size: 10pt; }a:link { } > It’s > back to the same old question; > > > In > a > calendar, how can I put the day’s date (number only) and week > number and day-number-of-the-year in one cell? Particularly in > cell A5, B5...etc which are all cells that contain only the day > number of the month. > > > Here’s > a link to the Calc calendar template I’m trying to use- > > > https://extensions.libreoffice.org/templates/calendar-creator > > > The > template is very useful and I don’t want to interfere or mess up > the calendar creation- which it does perfectly. > > > Thank > you, > > > > > Carl > > -- 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] date, day number, week number in one cell
p { margin-bottom: 0.1in; line-height: 120%; }p.western { font-family: "Ubuntu"; }p.cjk { font-size: 10pt; }a:link { } It’s back to the same old question; In a calendar, how can I put the day’s date (number only) and week number and day-number-of-the-year in one cell? Particularly in cell A5, B5...etc which are all cells that contain only the day number of the month. Here’s a link to the Calc calendar template I’m trying to use- https://extensions.libreoffice.org/templates/calendar-creator The template is very useful and I don’t want to interfere or mess up the calendar creation- which it does perfectly. Thank you, Carl -- 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] Can't edit array
On 06/27/2018 02:03 PM, Brian Barker wrote: At 12:45 27/06/2018 -0400, Carl Winerich wrote:I have a spreadsheet; Calendar.ods, that refers to (or is linked) another spreadsheet; Begin_Here (copy).ods. When I try to expand the range of the of Begin_Here (copy).ods'#$Sheet1.A1:E75 in Calendar.ods the following message appears- You cannot change only part of an array. Editing it by using ctrl-/ then F2 works but the same error message appears. Here's the complete array found in Calendar.ods; ='file:///home/Carl/MyDocuments/Calendar/Begin_Here (copy).ods'#$Sheet1.A1:E75 How can I expand the range?Are you simply trying to edit the reference to A1:E75 in the referring spreadsheet (Calendar)? As you correctly identify, in order to do this you must first select all of the array range, e.g. by using Ctrl+/. Then you can edit the formula either in the Input Line or _in situ_ in a member cell of the array range after pressing F2. But in each case you will see that the enclosing braces - {} - that denote an array formula disappear when you attempt either edit. You need to reaffirm that you intend an array formula when you complete the edit by using Ctrl+Shift+Enter instead of simple Enter - as you must have done to create the array formula in the first place.(The green Accept tick is also no use here.)As you probably know, you cannot simply add the required braces by typing them yourself; you need to use Ctrl+Shift+Enter.I trust this helps.Brian BarkerBrian,Many thanks for the lengthy answer and solution. It worked perfectly. Regards,Carl W. -- 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] Can't edit array
I have a spreadsheet; Calendar.ods, that refers to (or is linked) another spreadsheet; Begin_Here (copy).ods. When I try to expand the range of the of Begin_Here (copy).ods'#$Sheet1.A1:E75 in Calendar.ods the following message appears- You cannot change only part of an array. Editing it by using ctrl-/ then F2 works but the same error message appears. Here's the complete array found in Calendar.ods; ='file:///home/Carl/My Documents/Calendar/Begin_Here (copy).ods'#$Sheet1.A1:E75 How can I expand the range? Thank you, Carl -- 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] Two formulas in one cell?
Concatenate works...to a point. Another problem is that first formula must provide a result formatted as a date, let's say June 2. The second formula must provide a result as a day-number-of-the-year (which I haven't figured out how to do yet). Using concatenate the result is a 5 digit number returned for the first formula even though the cell is formatted as a D. How can these format requirements be maintained? Thanks, Carl On 06/02/2018 06:10 PM, Brian Barker wrote: > At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: >> In cell A2 the following formula is placed =F30-2 In the same cell >> (A2) I want to place a second formula which is =A10+4 How can I add >> this second formula into A2 and obtain the results of both formulas >> in the same cell (A2) but each separated by several spaces so the >> results are distinct? Thank you, Carl > > The answer to this question is very similar to that for the almost > identical question that you asked (and had answered) last November 21st: > http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html > . > > If a cell contains a formula, the result of that formula is what > appears in the cell, so having two formulae would be simply > contradicting yourself. As you already know, if you wanted F30-2 you > would not expect to use =F30 and then =-2 separately but instead > =F30-2. In the same way, you must construct a single formula that > creates the combination of values that you ask for. You can combine > results using the CONCATENATE() function or, more simply, the "&" > operator. Try: > =F30-2&" "&A10+4 > > Incidentally, do please put your name in the real name field of your > mail messages: it's an elementary courtesy to those offering to help you. > > I trust this helps. > > Brian Barker > -- 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