https://bugs.freedesktop.org/show_bug.cgi?id=71800

--- Comment #4 from Mik44 <[email protected]> ---
Created attachment 89586
  --> https://bugs.freedesktop.org/attachment.cgi?id=89586&action=edit
Freshly-created example.

Many thanks to Tim and Dominique for their thoughts on this.
The file has been evolving over several years, and was probably first created
as an xls file. I will check when I have access to the computer that holds this
history, and do some experiments.

Interesting observation of Dominique's. Changing the formatting to "text" makes
the error show as '0' instead of '30', results which also appear as the current
example in the cell formatting box even after the error has been cleared from
the result cells by the trick described initially.

However, experimenting now (on a laptop running XP Home and LO ver 4.1.3.2)
produces the error, appearing as '0' in a text or number-formatted result cell.
It's more persistent, too, clearing only if the source cells are left with a
space in them. (File attached: try.ods)

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to