[Libreoffice-bugs] [Bug 108267] Calc: for some tasks nearly unusable/ error provoking because of word completions

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108267

--- Comment #2 from kohlhz at t-online.de ---
Created attachment 133780
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133780&action=edit
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)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170601/2ca814ae/attachment-0001.html>