質問する

irs's profile - activity

2017-10-15 21:03:48 +0200 バッジを受け取った  体系学者
2016-02-28 14:16:13 +0200 バッジを受け取った  編集者 (source)
2016-02-28 14:08:36 +0200 バッジを受け取った  有名な質問 (source)
2016-02-17 15:50:59 +0200 バッジを受け取った  卓越した質問 (source)
2016-02-17 13:36:16 +0200 コメント付き回答 Calc - Sum of top values in a row [Closed]

Thanks (and to JohnSUN) - gives me exactly what I want. I'm now trying to work out how it works - good for the brain !

2016-02-17 13:36:11 +0200 バッジを受け取った  学者 (source)
2016-02-17 10:45:15 +0200 コメント付き質問 Calc - Sum of top values in a row [Closed]

I probably didn't describe the problem well enough. The spreadsheet contains the weekly scores of up to 20 or 30 players in a golf competition running over 30 weeks. The best 15 scores (out of a possible 30) count. Each week the scores are entered into the sheet and I would like the calculation to be automatically carried out. The sort & sum method will work ok but requires multiple operations. The Excel solution has a single cell for each row calculating the value we want.

2016-02-17 10:30:08 +0200 バッジを受け取った  人気の質問 (source)
2016-02-16 18:26:25 +0200 質問をする Calc - Sum of top values in a row [Closed]

The answer question " How to select the top "values" in each row of the spreadsheet [closed]" explained how to identify to top n items in a row.

I want to SUM the top 15 values in a row containing up to 30 values I can do this in two ways (both long winded) [values held in $B2:$AR2]

  1. create 15 new columns and populate them with "=LARGE($B2:$AR2,n)" where n = 1-15 and then sum the 15 columns
  2. create a single total column with a formula of 15 expressions =(LARGE($B2:$AR2,1)+LARGE($B2:$AR2,2)+LARGE($B2:$AR2,3)+ .....LARGE($B2:$AR2,15)) this gets very unwieldy for the top 50 !

is there a better way of doing this in Calc

In Excel I can use the formula =SUM(LARGE($B2:$AR2,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15})) in calc this just returns the highest value.

(Editing: I ('Lupp') only added the link to the post referred to at the beginning of this question.)

2015-12-26 00:49:19 +0200 コメント付き質問 How do I increase the size of the font in the Formula Bar?

I too find the font too small, I can increase size of cells but have to change the values in the formula bar. My eyesight isn't as good as it was 70 years ago !

2015-10-04 22:59:55 +0200 バッジを受け取った  卓越した質問 (source)
2015-10-04 22:59:55 +0200 バッジを受け取った  有名な質問 (source)
2014-08-16 18:59:09 +0200 質問に回答する How to you clear a form option button?

A solution

With Form Design Mode 'On', double-click (to select) the 'set' option button

In the Properties box change the 'default status' to 'selected' and then change it back to 'not selected' close the box and the button is cleared.

messy but it works

2014-01-26 19:09:15 +0200 バッジを受け取った  人気の質問 (source)
2013-09-20 01:12:27 +0200 質問をする I have copied spreadsheet data into Kompozer (html editor) in 4.0 works differently why ?

I use Kompozer (HTML editor) to update web sites. Over the last few years I have been able to take a spreadsheet in Calc and copy portions of it into a html page as a table. This has produced tidy tables.

I have just upgraded from LO 3.5/6 to LO 4.0 and the result has changed. Empty cells are compressed and column integrity is lost. The version of Kompozer has not changed in 4 years !.

Does anyone know how to cure this