stardis

commit e7fa6c9c6773b9dbc0206ac8c4a59d267afc7d29
parent 6219d5a0f4bd303573573bbb1adf2a58d951aeaf
Author: christophe coustet <christophe.coustet@meso-star.com>
Date:   Thu,  6 Jun 2019 11:23:31 +0200

Workaround for LibreOffice not displaying comments properly

Diffstat:
M
pp/green2xslx.pl
 | 
6
++++--

1 file changed, 4 insertions(+), 2 deletions(-)
diff --git a/pp/green2xslx.pl b/pp/green2xslx.pl
@@ -556,10 +556,12 @@ my @result_colnames = ('Estimate', 'Sigma');
 $model->write($model_current_line, 0, \@result_colnames, $title);
 $model_current_line++;
 $model->write_formula($model_current_line, 0, "AVERAGE(Samples!A2:A$samples_current_line)", $locked);
-$model->write_formula($model_current_line, 1, "STDEV(Samples!A2:A$samples_current_line)/SQRT($samples_current_line-1)", $locked);
+# Here we use STDEVP (Standard dev for a entire population) to remains coherent with stardis-solver
+# One could consider STDEV (Standard dev for a sampling of the population) more appropriate
+$model->write_formula($model_current_line, 1, "STDEVP(Samples!A2:A$samples_current_line)/SQRT($samples_current_line-1)", $locked);
 $model_current_line++;
-$model->write_comment($model_current_line, 0, $poly, start_row => $model_current_line, visible => 1, x_scale => 6);
 
+$model->write_string($model_current_line, 0, $poly);
 $workbook->close();
 
 print STDERR "$poly\n";