Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 04 Jul 2017 13:15:12 +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.
ThankscranmaxTue, 04 Jul 2017 13:15:12 +0200https://ask.libreoffice.org/en/question/108060/