Ask Your Question

PAlotta's profile - activity

2019-10-29 01:36:53 +0100 commented question Named Range As Print Range

I was using a formula to create a dynamic range in the project I was working on referenced above. However, I believe tha

2019-03-22 21:30:31 +0100 received badge  Famous Question (source)
2019-03-16 04:28:17 +0100 received badge  Famous Question (source)
2018-12-22 16:24:39 +0100 received badge  Famous Question (source)
2018-06-25 22:24:06 +0100 received badge  Notable Question (source)
2018-05-27 19:12:23 +0100 edited answer 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 +0100 answered a question 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 +0100 commented question Named Range As Print Range

I take it that this was a dumb question.

2018-05-03 02:55:36 +0100 commented question Named Range As Print Range

I take it that this was a dumb question.

2018-05-03 02:54:30 +0100 received badge  Popular Question (source)
2018-04-26 04:02:46 +0100 received badge  Famous Question (source)
2018-04-08 02:52:23 +0100 commented answer 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 +0100 marked best answer 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 +0100 received badge  Notable Question (source)
2018-04-07 00:26:19 +0100 received badge  Editor (source)
2018-04-07 00:26:19 +0100 edited question 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 +0100 asked a question 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 +0100 received badge  Enthusiast
2018-04-05 23:24:52 +0100 received badge  Popular Question (source)
2018-04-05 03:26:31 +0100 edited question 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 +0100 answered a question 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 +0100 asked a question 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 +0100 marked best answer 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 +0100 answered a question 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 +0100 received badge  Notable Question (source)
2018-03-22 15:04:39 +0100 received badge  Popular Question (source)
2018-03-21 22:45:44 +0100 asked a question 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 +0100 commented answer 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 +0100 received badge  Notable Question (source)
2018-03-20 01:28:15 +0100 answered a question 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 +0100 marked best answer 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 +0100 received badge  Scholar (source)
2018-03-19 23:47:52 +0100 received badge  Popular Question (source)
2018-03-19 15:17:27 +0100 received badge  Student (source)
2018-03-19 03:09:11 +0100 asked a question 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