Stel uw vraag

PAlotta's profiel - activiteit

2019-03-22 21:30:31 +0200 badge ontvangen  Beroemde vraag (bron)
2019-03-16 04:28:17 +0200 badge ontvangen  Beroemde vraag (bron)
2018-12-22 16:24:39 +0200 badge ontvangen  Beroemde vraag (bron)
2018-06-25 22:24:06 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-05-27 19:12:23 +0200 bewerkte een antwoord how to put a print screen in a doc

Actually, in the Windows world, Alt-Print Screen is better suited for this situation. Alt-Print Screen will copy only th

2018-05-27 18:57:52 +0200 beantwoorde een vraag how to put a print screen in a doc

Actually, Alt-Print Screen is better suited for this situation. Alt-Print Screen will copy only the active window. Ctrl-

2018-05-03 02:56:01 +0200 reageerde op een vraag Named Range As Print Range

I take it that this was a dumb question.

2018-05-03 02:55:36 +0200 reageerde op een vraag Named Range As Print Range

I take it that this was a dumb question.

2018-05-03 02:54:30 +0200 badge ontvangen  Populaire Vraag (bron)
2018-04-26 04:02:46 +0200 badge ontvangen  Beroemde vraag (bron)
2018-04-08 02:52:23 +0200 reageerde op een antwoord Sum Every nth Row In Calc

erAck, Thanks! I tried your suggestion and it works very well, far simpler that others I found that did not work out.

2018-04-08 02:52:19 +0200 koos een beste antwoord Sum Every nth Row In Calc

I need to sum every nth row in LO 6.0 Calc. I am trying to find out how many rows of a name and address list are populated so I can build a print range.

The column that is being used to test two rows for the presence of data contains a formula such as =IF(A12>0,1,0) to give a 0 for an empty row or 1 for a populated row. Underneath those two rows is a formula such as =IF(SUM(F11:F13)>0,1,0) to see if either row is populated.

I can tell if a group of rows contains data, but I need to know how many of these groups there are.

2018-04-08 02:43:34 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-04-07 00:26:19 +0200 badge ontvangen  Redacteur (bron)
2018-04-07 00:26:19 +0200 bewerkte een vraag Named Range As Print Range

Named Range As Print Range I am using LO Calc Version: 6.0.2.1 (x64). I am trying to set a print range using a named ran

2018-04-07 00:25:57 +0200 stelde een vraag Named Range As Print Range

Named Range As Print Range I am using LO Calc Version: 6.0.2.1 (x64). I am trying to set a print range using a named ran

2018-04-06 00:58:32 +0200 badge ontvangen  enthousiast
2018-04-05 23:24:52 +0200 badge ontvangen  Populaire Vraag (bron)
2018-04-05 03:26:31 +0200 bewerkte een vraag Sum Every nth Row In Calc

Sum Every nth Row In Calc I need to sum every nth row in LO 6.0 Calc. I am trying to find out how many rows of a name an

2018-04-05 03:17:15 +0200 beantwoorde een vraag How to unblock office when it freezes

It would really help if we knew what operating system and version you are using, as well as the version of LibreOffice y

2018-04-05 02:57:39 +0200 stelde een vraag Sum Every nth Row In Calc

Sum Every nth Row In Calc I need to sum every nth row in LO 6.0 Calc. I am trying to find out how many rows of a name an

2018-03-26 00:34:40 +0200 koos een beste antwoord Calc parenthesis highlighting

I am using Calc in LO 6.0.2. Is there any parenthesis highlighting that can be enabled for the formula bar? I have a habit of missing parenthesis in long formulas so this would be useful. If it not a feature, is there a way to request such an enhancement?

Peter

2018-03-26 00:26:34 +0200 beantwoorde een vraag Calc parenthesis highlighting

Lupp, I did notice the cell grid editing will bold parenthesis pairs, but I should have been a little more detailed. Som

2018-03-24 02:39:47 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-03-22 15:04:39 +0200 badge ontvangen  Populaire Vraag (bron)
2018-03-21 22:45:44 +0200 stelde een vraag Calc parenthesis highlighting

Calc parenthesis highlighting I am using Calc in LO 6.0.2. Is there any parenthesis highlighting that can be enabled for

2018-03-21 22:04:41 +0200 reageerde op een antwoord Does ADDRESS function in Calc work within other functions?

Quoting lupp "For this you will need to use the fourth and the fifth parameter of OFFSET, but neither ADDRESS nor INDIRE

2018-03-20 18:33:17 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-03-20 01:28:15 +0200 beantwoorde een vraag Does ADDRESS function in Calc work within other functions?

Thank you Jim K and Lupp, you both gave me a clearer understanding of ADDRESS vs. INDIRECT. Jim K, the link was exactly

2018-03-20 01:09:08 +0200 koos een beste antwoord Does ADDRESS function in Calc work within other functions?

I have not been using LO Calc very long, so this is probably a dumb question. I have been trying to use spreadsheet functions to complete a project for someone and I need to have Calc functions reference another cell from the cell that the formula is in. For example, I can use =OFFSET(A4,-1,5) to get a value stored 1 row up and 5 columns over from cell A4.

I can use =(ADDRESS(ROW(),COLUMN(),4)) to return the cell address that the function is in.

However, I can't use the ADDRESS function within the OFFSET function to get the current cell the OFFSET function is in to get the same result, such as =OFFSET((ADDRESS(ROW(),COLUMN(),4)),-1,5).

Does ADDRESS not play well with others, or am I doing something wrong?

Peter

2018-03-20 01:09:08 +0200 badge ontvangen  Leerling (bron)
2018-03-19 23:47:52 +0200 badge ontvangen  Populaire Vraag (bron)
2018-03-19 15:17:27 +0200 badge ontvangen  Student (bron)
2018-03-19 03:09:11 +0200 stelde een vraag Does ADDRESS function in Calc work within other functions?

Does ADDRESS function in Calc work within other functions? I have not been using LO Calc very long, so this is probably