Bug 106844 - [Calc] Comparative summary of scenarios
Summary: [Calc] Comparative summary of scenarios
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Scenarios
  Show dependency treegraph
 
Reported: 2017-03-29 08:10 UTC by gmolleda
Modified: 2019-05-30 18:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description 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.
Comment 1 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 ?
Comment 2 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.
Comment 4 gmolleda 2019-05-30 17:44:21 UTC
Yes, it is.
Comment 5 raal 2019-05-30 18:22:18 UTC
setting as new