<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Calc: for some tasks nearly unusable/ error provoking because of word completions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108267#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Calc: for some tasks nearly unusable/ error provoking because of word completions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108267">bug 108267</a>
from <span class="vcard"><a class="email" href="mailto:kohlhz@t-online.de" title="kohlhz@t-online.de">kohlhz@t-online.de</a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133780" name="attach_133780" title="simplified example (grown naturally)">attachment 133780</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133780&action=edit" title="simplified example (grown naturally)">[details]</a></span>
simplified example (grown naturally)
In line 346 I've added a new, typical sample entry.
You may manually write this text into line 345, or play with other data.
This example showing just a part of all irritating effects.
The original data are very different, often incomplete or uncertain, and
sometimes comments to different entries are necessary.
For such data would be best to have no automatic change of values at all beside
of evaluating explicit formulas.
There are other error prone actions due to automatic actions:
E.g.:
- filling a "-" sign into a cell followed by a tab, should work like working
with other data - put in this sign and go to the next cell.
- filling subsequent cells using mouse action shouldn't change the cell content
(not 100 -> 101 102 103 but 100 -> 100 100 100)
- no automatic input text correction at all
When changing (mainly simplifying) my data I saw indeed some errors in the
file, but most wrong contents are not as easy to see like F=136 instead of
F=135 (but even 136 could be correct!).
In most cases I had just written a correct, simple and usual text or number
like e.g. 4.5 in column S followed by a tab ( or 11|1 into column H)
Such errors are very hard to find, or it's even impossible.
O.k.- the file design is very old and not optimal, I could change it (but e.g.
more columns wouldn't make things better)</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>