https://bugs.documentfoundation.org/show_bug.cgi?id=145183
--- Comment #8 from Keith Sayers <ke...@keithsayers.id.au> ---
My appreciation for so many responses so quickly. The main thing sought
seems to be a selection from my spreadsheet. Attached. Column A is now hard
coded to be the source for the subsequent formulae. FWIW the original is a
monthly spreadsheet I use to check phone calls. At some point I was advised
to try the same thing in Gnumeric. I did and got the same result. I realise
that as a one-off solution I could hard code those #VALUE! cells or for longer
use use a formula built on MOD() or expand the current formula to something
like IF(VALUE(A1)=0,0,FIND .......). If this does not qualify as a bug that
would be fine by me.
Comment # 1 on bug 145183 from m.a.riosv
Please attach a sample file, and edit the title with a short message about the
issue.
Comment # 2 on bug 145183 from Julien Nabet
Also give a try to a newer LO version, 6.4.7 is quite old.
You can use https://launchpad.net/~libreoffice/+archive/ubuntu/ppa
Anyway, since dealing with decimal separator is a bit specific, you may
reproduce this too on recent LO version.
If I may, I would rather not do a partial upgrade. I use Kubuntu,
currently version 20.04, in due course I would expect to get v22.04 which
should bring me a complete upgrade.
--
You are receiving this mail because:
You are the assignee for the bug.
