2019-10-29 01:36:53 +0100 | Pergunta comentada | 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 | Medalha recebida | ● Pergunta famosa (fonte) |

2019-03-16 04:28:17 +0100 | Medalha recebida | ● Pergunta famosa (fonte) |

2018-12-22 16:24:39 +0100 | Medalha recebida | ● Pergunta famosa (fonte) |

2018-06-25 22:24:06 +0100 | Medalha recebida | ● Pergunta notável (fonte) |

2018-05-27 19:12:23 +0100 | Resposta editada | 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 | Respondeu uma pergunta | 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 | Pergunta comentada | Named Range As Print Range I take it that this was a dumb question. |

2018-05-03 02:55:36 +0100 | Pergunta comentada | Named Range As Print Range I take it that this was a dumb question. |

2018-05-03 02:54:30 +0100 | Medalha recebida | ● Pergunta popular (fonte) |

2018-04-26 04:02:46 +0100 | Medalha recebida | ● Pergunta famosa (fonte) |

2018-04-08 02:52:23 +0100 | Resposta comentada | 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 | Marcada como a melhor resposta | 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 | Medalha recebida | ● Pergunta notável (fonte) |

2018-04-07 00:26:19 +0100 | Medalha recebida | ● Editor (fonte) |

2018-04-07 00:26:19 +0100 | Pergunta editada | 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 | Perguntou | 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 | Medalha recebida | ● Entusiasta |

2018-04-05 23:24:52 +0100 | Medalha recebida | ● Pergunta popular (fonte) |

2018-04-05 03:26:31 +0100 | Pergunta editada | 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 | Respondeu uma pergunta | 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 | Perguntou | 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 | Marcada como a melhor resposta | 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 | Respondeu uma pergunta | 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 | Medalha recebida | ● Pergunta notável (fonte) |

2018-03-22 15:04:39 +0100 | Medalha recebida | ● Pergunta popular (fonte) |

2018-03-21 22:45:44 +0100 | Perguntou | 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 | Resposta comentada | 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 | Medalha recebida | ● Pergunta notável (fonte) |

2018-03-20 01:28:15 +0100 | Respondeu uma pergunta | 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 | Marcada como a melhor resposta | 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 | Medalha recebida | ● Acadêmico (fonte) |

2018-03-19 23:47:52 +0100 | Medalha recebida | ● Pergunta popular (fonte) |

2018-03-19 15:17:27 +0100 | Medalha recebida | ● Estudante (fonte) |

2018-03-19 03:09:11 +0100 | Perguntou | 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.