Bug 106844 - [Calc] Comparative summary of scenarios
[Calc] Comparative summary of scenarios
 Status: NEW None LibreOffice Unclassified Calc (show other bugs) unspecified All All medium enhancement Not Assigned Scenarios Show dependency tree / graph

 Reported: 2017-03-29 08:10 UTC by gmolleda 2019-05-30 18:22 UTC (History) 3 users (show) miguelangelrv raal xiscofauli

Attachments

 Note You need to log in before you can comment on or make changes to this bug.
 gmolleda 2017-03-29 08:10:43 UTC ```Please: Create a button in Scenario Browser to make a comparative table of values and results of the different saved scenarios. Por favor: Crear un botón en navegador de escenarios para hacer un cuadro comparativo de valores y resultados de los distintos escenarios guardados. Bonvolu: Krei butonon en la naviganto de scenejoj por fari komparan tabelon de valoroj kaj rezultoj de la malsamaj scenejoj.``` Xisco Faulí 2017-03-29 11:21:58 UTC `Could you please provide a more detailed description of what this feature should do illustrating it with examples and mockups ?` gmolleda 2017-03-29 16:49:31 UTC ```Example: \$C\$3-\$C\$5: variables with different values in three scenarios. \$C\$8: formula sum(\$C\$3:\$C\$5) \$C\$9: formula =\$C\$3+\$C\$4-\$C\$5 In Scenarios navigator: button for present a windows for choice Cells with formula results (example choice \$C\$8 or \$C\$8;\$C\$9) and choice cell where put the table with calculate results Button Accept -> present table with: Scenarios: Scenario1 Scenario2 Scenario3 ... Variable Cells \$C\$3 1 2 3 \$C\$4 4 4 4 \$C\$5 3 2 1 Results \$C\$8 8 8 8 \$C\$9 2 4 6 Now you can view for compare variable values and results for each scenario.``` raal 2019-05-30 17:32:34 UTC `Do you mean something like this https://support.office.com/en-us/article/switch-between-various-sets-of-values-by-using-scenarios-2068afb1-ecdf-4956-9822-19ec479f55a2 -> Scenario summary reports ?` gmolleda 2019-05-30 17:44:21 UTC `Yes, it is.` raal 2019-05-30 18:22:18 UTC `setting as new`