<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - LibreCalc6.2: Opening a Calc with some formulas: It writes "adapt Row Height" which is taking ages to load!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124098#c23">Comment # 23</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - LibreCalc6.2: Opening a Calc with some formulas: It writes "adapt Row Height" which is taking ages to load!"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124098">bug 124098</a>
from <span class="vcard"><a class="email" href="mailto:vasily.melenchuk@cib.de" title="Vasily Melenchuk (CIB) <vasily.melenchuk@cib.de>"> <span class="fn">Vasily Melenchuk (CIB)</span></a>
</span></b>
<pre>In given document we have tons of rows with style:use-optimal-row-height="true"
and these rows should be recalculated to find this optimal height. Once I
remove this style from rows document begin to load in acceptable time. So
feature works okay from technical point of view.
At the same time attempts to set optimal height from UI also very slow. Maybe
it requires some profiling & optimization.
While this is quite often case (this value is set by default in many cases) it
makes sense to adjust adaptation of row height on load further. Out of my head
I see several options:
* provide per document setting enabling or disabling this feature. With
disabled by default we will receive less such problems like current one.
* do not calculate on load rows with style:use-optimal-row-height="true" and
provided row height. Such scenario should be okay for at least one of original
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - FILEOPEN: Optimum row height should be recalculated with "style:use-optimal-row-height='true'""
href="show_bug.cgi?id=62268">tdf#62268</a> bugdocs.
IMHO row recalculation on load is quite handy only for generated by third-party
tools documents. For documents created in Calc it senseless: given height is
correct one (otherwise it is a bug). So for generated docs users should just
omit style:row-height parameter to force LO to calculate this row height on
load.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>