[libreoffice-users] Re: Degree symbol in Math

[V Stuart Foote]

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 U+00B0 DEGREE SIGN, enter
U+00B0 and then +x to toggle to °

You can also use the Symbols button and define a new entry in the Special
category for the degree sign, but I find the Unicode toggle to be more
direct.




--
View this message in context: 
http://nabble.documentfoundation.org/Degree-symbol-in-Math-tp4199244p4199459.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Calc multiplication & division formulas acting strangely (Mac 5.2.3)

[Brian Barker]

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?. In 
cell A1R1 =4*1.5 gives #NAME? In each spreadsheet that I've opened 
I get the same problem. When I do 4*150%, Calc changes the formula 
to =4*1.5 and gives 6. Then I try =4/1.5 and I get #NAME?

[...]
What's going on here? What should I be looking into?


This is exactly what you will see if your settings are for a locale 
which uses the comma instead of the point as the fractional 
separator (as many do). You can confirm this easily by entering (to 
modify your first example):

=4*1,5
- which should work.

You need to tell Calc to expect the point as the fractional 
separator. Before installing any application software, select 
appropriate locale settings in your operating system. Only if 
necessary, modify the settings in the application. In LibreOffice, 
go to Tools | Options... | Language Settings | Languages and make 
appropriate selections there. (Oh, on the Mac, for "Tools | 
Options..." read "LibreOffice | Preferences".)


Thank you Brian. I thought that was the issue, but I've tried =4*1, 
5 and it gives me Err:509.


Well, it will - since you've inserted that unhelpful space! We need 
the number one-and-a-half, not the two separate numbers one and five. 
The test is =4*1,5 - as I suggested. I'm sticking with my suggestion 
that this will work!


I can open old Calc spreadsheets with decimal inputs and have no 
problem until I try to enter new numbers.


That's also consistent with my suggestion. Formulae in existing 
documents are reinterpreted in the light of your new settings.


I've noticed that if the formula is multiply by less than 1.0, the 
calculation works.  As soon as I try any decimal greater than 1.0, I 
get the #NAME?. =0.99 * 0.99 works =1.1*0.99 gives #NAME? =2*0.99 
works =2.1*1 #NAME? Very weird.


I don't immediately see what is happening here, but it has to be said 
that there are very many places where locales and languages are set. 
It's difficult to test every possibility without messing up my 
system. Note, for example, that the cell formatting has its own 
language setting (at Format | Cells... | Numbers | Language), though 
that ought to affect only the display of results, not the 
interpretation of input.


You might want to get someone to look at a sample document to see 
what is happening.


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help with LOCalc formula

[Brian Barker]

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 need the "to-day"-value for this 
company's share (in e.g. column X), which value 
is taken from respective company's row in col.Z 
in r(2). r(1) has yearly 100-130 rows (events) 
Range(2) lists each company named in the above 
Range(1) and has in col.Z the corresponding 
share's "to-day"-value. These inserted share 
values varies from one day to the next. There 
are now 10-15 companies (rows) listed in r(2) 
--  not in alphabetic order. r(2) sums the 
up-to-date result per company and the total 
result. Problem The below example simplified to 
5 events concerning 3 companies may clarify the 
problem with the formula in X1 copied down 
col.X: 
=if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0))) 
As you can see: with 15 (or more) companies 
(and >100 events) the formula will grow and 
become very long and sensitive for mistakes. 
VLOOKUP does not seem to be an option, at least 
it requires a completely new setup of the page.


Range(1) - events
A   B C…. X
1. nokia   5,o
2. kone 41,o
3. nokia   5,o
4. fiskars 12,o
5. kone41,o

Range(2) - companies
A B C... Z
20 nokia   5,o
21 fiskars   12,o
22 kone 41,o


Sorry, but why do you think that VLOOKUP() is not 
an option? As has already been suggested, it is 
exactly what you need. Are you perhaps concerned 
that column Z in your company table is so far 
away from column B? That does not matter. For the 
formulae in column X of your events table, you 
retrieve the required value from the company 
table using VLOOKUP(). Its first parameter is the 
company name in the events table, Bn or whatever. 
The second parameter is the range that contains 
the company names and values, so B$20:Z$22 (if 
you see what I mean). The third parameter is the 
column in that range containing the required 
value; if the range really does span columns B to 
Z, that will be 25. The fourth parameter should 
be FALSE (or zero), to indicate that the company 
names in column B of the company table are not sorted.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[amaloney]

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 this message in context: 
http://nabble.documentfoundation.org/Calc-multiplication-division-formulas-acting-strangely-Mac-5-2-3-tp4199362p4199456.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Help with LOCalc formula

[Remy Gauthier]

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 (in e.g. column X), 
> which value is taken from respective company's row in col.Z in r(2).
> r(1) has yearly 100-130 rows (events)
> 
> > Range(2) lists each company named in the above Range(1) and has in
col.Z 
> > the corresponding share's "to-day"-value. These inserted share
values 
> varies from one day to the next.
> > There are now 10-15 companies (rows) listed in r(2) – not in
alphabetic 
> order.
> r(2) sums the up-to-date result per company and the total result.
> 
> Problem
> The belowe example simplified to 5 events concerning 3 companies may 
> clearify the problem with the formula in X1 copied down col.X:
> =if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0)))
> 
Unless there is something I do not understand, VLOOKUP() would probably
be a good option for you. I would enter the formula as follows (based
on your example) in X1:

=IFERROR(VLOOKUP(B1;B$20:Z$22;25;FALSE());0)

The "IFERROR()" is used to return a value of zero in case the lookup
fails, which corresponds to the last selection when false in the string
of nested IF() functions you listed.

You can also re-write the formula like this:

=IFERROR(VLOOKUP(B1;OFFSET(B$20;0;0;;25);25;FALSE())
;0)

where  is replaced by a formula that counts the
number of entries you have in r(2). This way, as you add entries, the
formula dynamically adjusts itself to the correct count of values and
you can drag this formula with little risk of error; depending on what
you are counting COUNT() or COUNTA() would work for you. Additionally,
you could assign a name to cell $B$20 and use that name in the formula
instead of an explicit reference to the cell.

Alternatively, you could use the MATCH() function to locate on which
row the company name is and then use INDIRECT(ADDRESS()) to retrieve
the value you are looking for. This is slightly more complex and in my
mind does not really perform better than VLOOKUP() in this case, but it
remains an alternative.

I hope this helps.

Rgds,

Rémy Gauthier.


> Any suggestion will be very interesting.
Thank you in advance
Pertti Rönnberg/Finland



-- 
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] Help with LOCalc formula

[Bruce Hohl]

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 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 – 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
> need the "to-day"-value for this company's share (in e.g. column X), which
> value is taken from respective company's row in col.Z in r(2).
> r(1) has yearly 100-130 rows (events)
>
> Range(2) lists each company named in the above Range(1) and has in col.Z
> the corresponding share's "to-day"-value. These inserted share values
> varies from one day to the next.
> There are now 10-15 companies (rows) listed in r(2) – not in alphabetic
> order.
> r(2) sums the up-to-date result per company and the total result.
>
> Problem
> The belowe example simplified to 5 events concerning 3 companies may
> clearify the problem with the formula in X1 copied down col.X:
> =if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0)))
>
> As you can see: with 15 (or more) companies (and >100 events) the formula
> will grow and become very long and sensitive for mistakes.
> VLOOKUP does not seem to be an option, at least it requires a completely
> new setup of the page.
>
> Range(1) - events
> A   B C…. X
> 1. nokia   5,o
> 2. kone 41,o
> 3. nokia   5,o
> 4. fiskars 12,o
> 5. kone41,o
>
> Range(2) - companies
> A B C... Z
> 20 nokia   5,o
> 21 fiskars   12,o
> 22 kone 41,o
>
> Any suggestion will be very interesting.
> Thank you in advance
> Pertti Rönnberg/Finland
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[bunk3m]

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 spreadsheet that I've opened I get the same problem.
When I do 4*150%, Calc changes the formula to =4*1.5 and gives 6. Then I
try =4/1.5 and I get #NAME?
[...]
What's going on here? What should I be looking into?

This is exactly what you will see if your settings are for a locale which
uses the comma instead of the point as the fractional separator (as many
do). You can confirm this easily by entering (to modify your first example):
=4*1,5
- which should work.

You need to tell Calc to expect the point as the fractional separator.
Before installing any application software, select appropriate locale
settings in your operating system. Only if necessary, modify the settings
in the application. In LibreOffice, go to Tools | Options... | Language
Settings | Languages and make appropriate selections there. (Oh, on the
Mac, for "Tools | Options..." read "LibreOffice | Preferences".)

I trust this helps.
=
Thank you Brian.

I thought that was the issue, but I've tried =4*1, 5 and it gives me
Err:509.

I have used LO since it started as a fork from SO and never had this
problem before.

The decimal separator is the same as the locale English (Canada) which is (
. ).

I can open old Calc spreadsheets with decimal inputs and have no problem
until I try to enter new numbers.

I've noticed that if the formula is multiply by less than 1.0, the
calculation works.  As soon as I try any decimal greater than 1.0, I get
the #NAME?.

=0.99 * 0.99 works
=1.1*0.99 gives #NAME?
=2*0.99 works
=2.1*1 #NAME?

Very weird.

I'm using OSX 10.10.5 if that points to anything.

I also tried LO 5.1.6 with same result.

Thanks again for any suggestions and help.

-- 
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] Calc - Page number and printing page range

[charles meyer]

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

-- 
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] Help with LOCalc formula

[Pertti Rönnberg]

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 – 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 
need the "to-day"-value for this company's share (in e.g. column X), 
which value is taken from respective company's row in col.Z in r(2).

r(1) has yearly 100-130 rows (events)

Range(2) lists each company named in the above Range(1) and has in col.Z 
the corresponding share's "to-day"-value. These inserted share values 
varies from one day to the next.
There are now 10-15 companies (rows) listed in r(2) – not in alphabetic 
order.

r(2) sums the up-to-date result per company and the total result.

Problem
The belowe example simplified to 5 events concerning 3 companies may 
clearify the problem with the formula in X1 copied down col.X:

=if(B1=$B$20;$Z$20;if(B1=$B$21;$Z$21;(ifB1=$B$22;$Z$22;0)))

As you can see: with 15 (or more) companies (and >100 events) the 
formula will grow and become very long and sensitive for mistakes.
VLOOKUP does not seem to be an option, at least it requires a completely 
new setup of the page.


Range(1) - events
A   B C…. X
1. nokia   5,o
2. kone 41,o
3. nokia   5,o
4. fiskars 12,o
5. kone41,o

Range(2) - companies
A B C... Z
20 nokia   5,o
21 fiskars   12,o
22 kone 41,o

Any suggestion will be very interesting.
Thank you in advance
Pertti Rönnberg/Finland


--
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