Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 12 Jun 2012 10:51:41 +0200Count merged cells in calchttps://ask.libreoffice.org/en/question/3210/count-merged-cells-in-calc/I am using a simple time tracker for tasks in calc (libreoffice 3.5.3.2). The task names are entered from a list, and the cells are merged for continuous durations.
In order to calculate the total time per task, I need to know a count of rows spanned by each task. A simple COUNTIF() would only return the number of occurrences of the task string, whereas I am looking for a metric that counts the number of cells in the merged ones.
I searched a lot, but cannot figure out how to implement this. I know it is not advised to use merged cells for calculations etc. but having to enter text for every entry makes it more tedious.
Thank you for any input!Sat, 09 Jun 2012 20:50:53 +0200https://ask.libreoffice.org/en/question/3210/count-merged-cells-in-calc/Answer by Holmes for <p>I am using a simple time tracker for tasks in calc (libreoffice 3.5.3.2). The task names are entered from a list, and the cells are merged for continuous durations.
In order to calculate the total time per task, I need to know a count of rows spanned by each task. A simple COUNTIF() would only return the number of occurrences of the task string, whereas I am looking for a metric that counts the number of cells in the merged ones.</p>
<p>I searched a lot, but cannot figure out how to implement this. I know it is not advised to use merged cells for calculations etc. but having to enter text for every entry makes it more tedious.</p>
<p>Thank you for any input!</p>
https://ask.libreoffice.org/en/question/3210/count-merged-cells-in-calc/?answer=3249#post-id-3249Got some interesting responses here : http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=54366
And a solution that fits my requirement.Tue, 12 Jun 2012 10:51:41 +0200https://ask.libreoffice.org/en/question/3210/count-merged-cells-in-calc/?answer=3249#post-id-3249