Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 04 Jul 2017 16:39:17 +0200Data Table Alternativehttps://ask.libreoffice.org/en/question/108060/data-table-alternative/Hi,
I'm finding an alternative to Excel Data Table, in Excel it appears in Data -> What-if Analysis -> Data Table.
This helps me to calculate the results of 1 cell with different values of 1 or 2 variables.
I post here a photo to understand it better:
![DataTable](http://imgur.com/a/FxmsK) http://imgur.com/a/FxmsK
On the top-left (A1) I write the cell that I want the results, and the row at the right (B1:V1) these are constants that uses the variable_A, below A1, the column from (A2:A22) these are constants that uses variable_B. And the body of the table are the combinations from variable_A and variable_B that gives A1.
ThanksTue, 04 Jul 2017 13:15:12 +0200https://ask.libreoffice.org/en/question/108060/data-table-alternative/Answer by pierre-yves samyn for <p>Hi,</p>
<p>I'm finding an alternative to Excel Data Table, in Excel it appears in Data -> What-if Analysis -> Data Table.
This helps me to calculate the results of 1 cell with different values of 1 or 2 variables.
I post here a photo to understand it better:</p>
<p><img alt="DataTable" src="http://imgur.com/a/FxmsK"><a href="http://imgur.com/a/FxmsK">http://imgur.com/a/FxmsK</a></p>
<p>On the top-left (A1) I write the cell that I want the results, and the row at the right (B1:V1) these are constants that uses the variable_A, below A1, the column from (A2:A22) these are constants that uses variable_B. And the body of the table are the combinations from variable_A and variable_B that gives A1.</p>
<p>Thanks</p>
https://ask.libreoffice.org/en/question/108060/data-table-alternative/?answer=108108#post-id-108108Hi
Have you tried [Multiple Operations](https://help.libreoffice.org/Calc/Applying_Multiple_Operations)?
RegardsTue, 04 Jul 2017 14:13:38 +0200https://ask.libreoffice.org/en/question/108060/data-table-alternative/?answer=108108#post-id-108108Comment by cranmax for <p>Hi</p>
<p>Have you tried <a href="https://help.libreoffice.org/Calc/Applying_Multiple_Operations">Multiple Operations</a>?</p>
<p>Regards</p>
https://ask.libreoffice.org/en/question/108060/data-table-alternative/?comment=108123#post-id-108123Thanks, I'm looking into it. It seems that the difference is that is not needed to be the function cell in the top left like in Excel. I have some problems in the results, as some are incorrect is like it catches some results from other cells and don't computes it correctly, have you detected it? I'm running on Linux an .xlsx file, but I think this doesn't matter.
ThanksTue, 04 Jul 2017 16:39:17 +0200https://ask.libreoffice.org/en/question/108060/data-table-alternative/?comment=108123#post-id-108123