Prev: Merge hunspell dictionaries
Next: [discuss] Ia2 Support seems along time coming.
From: Curtis Vaughan on 22 Mar 2010 17:44
On Mon, 22 Mar 2010 21:25:55 +0000, Curtis Vaughan wrote:

> We have noticed for some time that in one of the spreadsheets we use in
> the company the hyperlinks get removed. I am the only one who uses
> OpenOffice in the company and today, we did the following. One user
> created hyperlinks, closed the file and then I opened it. The hyperlinks
> they had just created were all removed for me. I closed the document
> without saving it and had the user open it again. The hyperlinks were
> there. If I saved the document, then the hyperlinks were gone.
>
> Why is this happening? Any ideas?
>
> Thanks

BTW, I have discovered a very interesting fact. This only happens with
hyperlinks, where the reference is a number. As soon as a letter is
added, then there is no problem. What is also interesting is that if you
edit the hyperlink that is only numeric in Excel, the data entry point
for the reference is blank and says something like:
"<Selected Document>".
Maybe this will help


---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org
For additional commands, e-mail: discuss-help(a)openoffice.org

From: Niklas Nebel on 23 Mar 2010 05:01
On 03/22/10 22:44, Curtis Vaughan wrote:
> BTW, I have discovered a very interesting fact. This only happens with
> hyperlinks, where the reference is a number. As soon as a letter is
> added, then there is no problem. What is also interesting is that if you
> edit the hyperlink that is only numeric in Excel, the data entry point
> for the reference is blank and says something like:
> "<Selected Document>".

It's issue 31050, see
http://www.openoffice.org/issues/show_bug.cgi?id=31050. In OOo Calc a
hyperlink is a text field, part of the cell content. In Excel, the link
is stored separately from the content. When we load an Excel file where
a cell has a number and a hyperlink, we keep the number instead of
replacing it with a hyperlink field, so the number can be used in
calculations.

Niklas

---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org
For additional commands, e-mail: discuss-help(a)openoffice.org

From: Malte Timmermann on 23 Mar 2010 05:14
So I suggest for fixing this, and to be more similar to Writer, hyper
links in the EditEngine should be changed to be character attributes -
same thing done in Write long time ago...

Malte.

Niklas Nebel wrote, On 03/23/10 10:01 AM:
> On 03/22/10 22:44, Curtis Vaughan wrote:
>> BTW, I have discovered a very interesting fact. This only happens with
>> hyperlinks, where the reference is a number. As soon as a letter is
>> added, then there is no problem. What is also interesting is that if you
>> edit the hyperlink that is only numeric in Excel, the data entry point
>> for the reference is blank and says something like:
>> "<Selected Document>".
>
> It's issue 31050, see
> http://www.openoffice.org/issues/show_bug.cgi?id=31050. In OOo Calc a
> hyperlink is a text field, part of the cell content. In Excel, the link
> is stored separately from the content. When we load an Excel file where
> a cell has a number and a hyperlink, we keep the number instead of
> replacing it with a hyperlink field, so the number can be used in
> calculations.
>
> Niklas
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org
> For additional commands, e-mail: discuss-help(a)openoffice.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-unsubscribe(a)openoffice.org
For additional commands, e-mail: discuss-help(a)openoffice.org

 | 
Pages: 1
Prev: Merge hunspell dictionaries
Next: [discuss] Ia2 Support seems along time coming.