[libreoffice-users] Re: Degree symbol in Math

From LibreOffice 5.1 simply use the Unicode codepoint toggle in the edit window of the Math formula editor. To obtain any Unicode codepoint in the default font, Liberation Serif for text, enter the code point and with cursor after the last character toggle to display the glyph with +x. E.g. for

Re: [libreoffice-users] Calc multiplication & division formulas acting strangely (Mac 5.2.3)

At 14:20 07/11/2016 -0500, Bonly Noname wrote: On 2016-11-06 8:43 PM, "Brian Barker" wrote: At 20:06 06/11/2016 -0500, Bonly Noname wrote: Today I created a spreadsheet in 5.2.3 (Mac) and each time I try to do a multiplication with a decimal, Calc gives me a #NAME?.

Re: [libreoffice-users] Help with LOCalc formula

At 17:58 07/11/2016 +0200, Pertti Rönnberg wrote: I have a spreadsheet with two ranges ­ range(1) directly above range(2). r(1) specifies per row every specific purchase/sell event (date, company name, amount, etc). To calculate the actual "to-day"-result for this specific event (row) we

[libreoffice-users] Re: Calc multiplication & division formulas acting strangely (Mac 5.2.3)

Using LO 5.2.3.3 on OS X 10.11.6 with the decimal separator (.), I do not reproduce the problem. I do get an error with the decimal separator (,) My system is set to US English. When I set the system to CDN English, I do not get an error either. Is there a issue with OS X 10.10.5? -- View

Re: [libreoffice-users] Help with LOCalc formula

Le lundi 07 novembre 2016 à 17:58 +0200, Pertti Rönnberg a écrit : > > r(1) specifies per row every specific purchase/sell event (date, company  > name, amount, etc). > > To calculate the actual "to-day"-result for this specific event (row) we  > need the "to-day"-value for this company's share

Re: [libreoffice-users] Help with LOCalc formula

I think VLOOKUP might work. In cell X1 try this: =VLOOKUP(B1,B$20:C$22,2,0) Copy down as needed; Adjust 2nd parameter (B$20:C$22) as needed. On Mon, Nov 7, 2016 at 10:58 AM, Pertti Rönnberg wrote: > Best Spreadsheet Experts, > May I ask for help having a more elegant formula

Re: [libreoffice-users] Calc multiplication & division formulas acting strangely (Mac 5.2.3)

On 2016-11-06 8:43 PM, "Brian Barker" wrote: At 20:06 06/11/2016 -0500, Bonly Noname wrote: Today I created a spreadsheet in 5.2.3 (Mac) and each time I try to do a multiplication with a decimal, Calc gives me a #NAME?. In cell A1R1 =4*1.5 gives #NAME? In each

[libreoffice-users] Calc - Page number and printing page range

Thank you both. My apologies for my tardy post. Charles. [libreoffice-users] Calc - Page number and printing page range - 50542 - Bruce Hohl - - [libreoffice-users] Calc - Page number and printing page range - 50543 - Brian Barker b.m.bar...@btinternet.com --

[libreoffice-users] Help with LOCalc formula

Best Spreadsheet Experts, May I ask for help having a more elegant formula in LOCalc (v.5.0.3; win10) Description I try to get a little extra to my pension savings by experimenting on the share market and follow up the results using Calc (not a database). I have a spreadsheet with two ranges –