First time here? Check out the FAQ!

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 |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.