Re: Formatted text confuses table grid under windows

Hi Erwin,

On Feb 9, 2008 2:56 AM, Erwin Brandstetter <brandstetter(at)falter(dot)at> wrote:
> Congrats on 1.8.2, guys! Better late than never. :) (My congratulations, not
> the release, mind you!) Upgrading was smooth, it works (mostly) stable. I do
> get occasional crashes, but I cannot connect them to a specific cause.

:-( I'm sure you'll let us know if you ever figure it out!

> I was able to pin down another (minor) issue, which I'll report instead. In
> today´s bug report I'd like to return to a classic: editing text in the table
> grid under windows.

Grrr.

> To see my point you might want to just reproduce the bug. Create an email
> hyperlink in an OOo document. (Insert -> Hyperlink ..) Then copy/paste the
> email-address to a text field in the table grid.
>
> As long as you are in edit mode, the field displays (in blue, so obviously
> something is different):
> test(at)foo(dot)org
>
> As soon as you leave the field, to another column or row, saving the data or
> not, the display changes to:
> HYPERLINK "mailto:test(at)foo(dot)org" test(at)foo(dot)org
>

Unfortunately I cannot find any way around this. If we stop using the
rich text control, we limit the amount of data we can handle as the
non-rich text variant will simply truncate oversized data on win32.
There is no way in wxWidgets to remove the URL formatting that I can
find, nor is there any way offered by the rich text controls own API
:-(. It is somewhat odd that we can get the text with the other
formatting (font etc) though - perhaps an overisght on Microsoft's
behalf?

The only other option I can see is to rewrite the grid text editor to
use the styled text control, but that will be some work. I'll add a
TODO for it though.

Cheers, Dave

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company