LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.

classic Classic list List threaded Threaded
6 messages Options
GaryKYF GaryKYF
Reply | Threaded
Open this post in threaded view
|

LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.

Hello...  I think I have found a bug in LOcalc's handling of  HREF="url" when LOcalc saves its sheet in .html format. Here's the procedure to expose the bug:

I'm running LibreOffice 3.4.4 on WinXP SP3.  

1) Open Calc by clicking on desktop shortcut to <LibreOffice 3.4/program/scalc.exe>.

2) Type "Text with HYPERLINK" into cell A1.

3) Select cell A1 and hi-lite HYPERLINK in Formula Toolbar.

4) Click hyperlink icon in Standard Toolbar and select DOCUMENT.

5) Type  link.html  in Path. Click APPLY and CLOSE.

6) Click SAVE and save file as File Name: abc  and Type: HTML  on the Desktop.  Choose "Keep Current Format".   File "abc.html" is created.

7) Exit Calc using X in upper right corner.



8) Drag&drop abc.html into a text editor (I use EditPlus)

9) See  HREF="link.html"  in the ... directive.

   NOTE: This behavior is what we expect since "link.html" was what was entered in the hyperlink interaction above (#5).

10) Close the editor.



11) Drag&drop abc.html into the Calc desktop shortcut.

12) Using SAVE AS, save the page/sheet as File Name: abc  and Type: HTML & Keep Current Format.  Select "overwrite" to save the new abc.html over the previous one.

13) Exit Calc using X in upper right corner.



14) Drag&drop abc.html into the text editor again.

15) See that  HREF=  is now:

     HREF="file:///C:/Documents and Settings/username/Desktop/link.html"

16) It's now been changed to an **ABSOLUTE** path and the abc.html file can only operate properly when it resides on the desktop. If it were moved (along with "link.html") to another folder it would not be able to find "link.html"...

Since I'm creating documentation that will be updated in the future by some as-yet-unknown individual (noobie?), I need Calc's SAVE and/or SAVE AS to operate consistently and accurately; not gratuitously changing things that I have not changed!

Do you have an explanation that would let me believe that this behavior was intended?

73,
     Gary
"Ing. Jiří Hladůvka" "Ing. Jiří Hladůvka"
Reply | Threaded
Open this post in threaded view
|

Re: LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.


In Tools-Options-Loading/Saving-Common
(perhaps this path is a bit different in English) you can choose
saving URLs relative or absolute to the file system.

Read more in Help for that option.
There is written that *tips* are always displayed as absolute path.

If you copy the .html file to e.g. C:\TMP\ and open it in Calc
the tip will say C:\TMP\link.html as the html tag in the source
points to the same folder ... <A HREF="link.html">

Jiri



Dne 25.12.2011 21:44, GaryKYF napsal(a):

> Hello...  I think I have found a bug in LOcalc's handling of  HREF="url" when
> LOcalc saves its sheet in .html format. Here's the procedure to expose the
> bug:
>
> I'm running LibreOffice 3.4.4 on WinXP SP3.
>
> 1) Open Calc by clicking on desktop shortcut to<LibreOffice
> 3.4/program/scalc.exe>.
>
> 2) Type "Text with HYPERLINK" into cell A1.
>
> 3) Select cell A1 and hi-lite HYPERLINK in Formula Toolbar.
>
> 4) Click hyperlink icon in Standard Toolbar and select DOCUMENT.
>
> 5) Type  link.html  in Path. Click APPLY and CLOSE.
>
> 6) Click SAVE and save file as File Name: abc  and Type: HTML  on the
> Desktop.  Choose "Keep Current Format".   File "abc.html" is created.
>
> 7) Exit Calc using X in upper right corner.
>
>
>
> 8) Drag&drop abc.html into a text editor (I use EditPlus)
>
> 9) See  HREF="link.html"  in the  ...  directive.
>
>     NOTE: This behavior is what we expect since "link.html" was what was
> entered in the hyperlink interaction above (#5).
>
> 10) Close the editor.
>
>
>
> 11) Drag&drop abc.html into the Calc desktop shortcut.
>
> 12) Using SAVE AS, save the page/sheet as File Name: abc  and Type: HTML&
> Keep Current Format.  Select "overwrite" to save the new abc.html over the
> previous one.
>
> 13) Exit Calc using X in upper right corner.
>
>
>
> 14) Drag&drop abc.html into the text editor again.
>
> 15) See that  HREF=  is now:
>
>       HREF="file:///C:/Documents and Settings/username/Desktop/link.html"
>
> 16) It's now been changed to an **ABSOLUTE** path and the abc.html file can
> only operate properly when it resides on the desktop. If it were moved
> (along with "link.html") to another folder it would not be able to find
> "link.html"...
>
> Since I'm creating documentation that will be updated in the future by some
> as-yet-unknown individual (noobie?), I need Calc's SAVE and/or SAVE AS to
> operate consistently and accurately; not gratuitously changing things that I
> have not changed!
>
> Do you have an explanation that would let me believe that this behavior was
> intended?
>
> 73,
>       Gary
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/LOcalc-SAVE-as-html-gratuitously-changes-HREF-from-relative-to-absolute-tp3611998p3611998.html
> Sent from the Users mailing list archive at Nabble.com.
>


--
Ing. Jiří Hladůvka - REVIDA

http://www.revida.sk
mailto:[hidden email]


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
krackedpress krackedpress
Reply | Threaded
Open this post in threaded view
|

Re: LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.


I would choose "relative" URLs.  That way, when you want to move the
pages to a different system, it will still work properly.  If I created
a web site with "absolute" URLs, then when I place it online, the URLs
would point to file-type of URL instead of one that would be used with a
domain.

a sample of a file-type or style:
file:///home/timothy/a-web-pages/godaddy-host/libreoffice-na.us/English-3.4-installs/dictionary.html

On 12/25/2011 06:21 PM, "Ing. Jiří Hladůvka" wrote:

>
> In Tools-Options-Loading/Saving-Common
> (perhaps this path is a bit different in English) you can choose
> saving URLs relative or absolute to the file system.
>
> Read more in Help for that option.
> There is written that *tips* are always displayed as absolute path.
>
> If you copy the .html file to e.g. C:\TMP\ and open it in Calc
> the tip will say C:\TMP\link.html as the html tag in the source
> points to the same folder ... <A HREF="link.html">
>
> Jiri
>
>
>
> Dne 25.12.2011 21:44, GaryKYF napsal(a):
>> Hello...  I think I have found a bug in LOcalc's handling of  
>> HREF="url" when
>> LOcalc saves its sheet in .html format. Here's the procedure to
>> expose the
>> bug:
>>
>> I'm running LibreOffice 3.4.4 on WinXP SP3.
>>
>> 1) Open Calc by clicking on desktop shortcut to<LibreOffice
>> 3.4/program/scalc.exe>.
>>
>> 2) Type "Text with HYPERLINK" into cell A1.
>>
>> 3) Select cell A1 and hi-lite HYPERLINK in Formula Toolbar.
>>
>> 4) Click hyperlink icon in Standard Toolbar and select DOCUMENT.
>>
>> 5) Type  link.html  in Path. Click APPLY and CLOSE.
>>
>> 6) Click SAVE and save file as File Name: abc  and Type: HTML  on the
>> Desktop.  Choose "Keep Current Format".   File "abc.html" is created.
>>
>> 7) Exit Calc using X in upper right corner.
>>
>>
>>
>> 8) Drag&drop abc.html into a text editor (I use EditPlus)
>>
>> 9) See  HREF="link.html"  in the  ...  directive.
>>
>>     NOTE: This behavior is what we expect since "link.html" was what was
>> entered in the hyperlink interaction above (#5).
>>
>> 10) Close the editor.
>>
>>
>>
>> 11) Drag&drop abc.html into the Calc desktop shortcut.
>>
>> 12) Using SAVE AS, save the page/sheet as File Name: abc  and Type:
>> HTML&
>> Keep Current Format.  Select "overwrite" to save the new abc.html
>> over the
>> previous one.
>>
>> 13) Exit Calc using X in upper right corner.
>>
>>
>>
>> 14) Drag&drop abc.html into the text editor again.
>>
>> 15) See that  HREF=  is now:
>>
>>       HREF="file:///C:/Documents and
>> Settings/username/Desktop/link.html"
>>
>> 16) It's now been changed to an **ABSOLUTE** path and the abc.html
>> file can
>> only operate properly when it resides on the desktop. If it were moved
>> (along with "link.html") to another folder it would not be able to find
>> "link.html"...
>>
>> Since I'm creating documentation that will be updated in the future
>> by some
>> as-yet-unknown individual (noobie?), I need Calc's SAVE and/or SAVE
>> AS to
>> operate consistently and accurately; not gratuitously changing things
>> that I
>> have not changed!
>>
>> Do you have an explanation that would let me believe that this
>> behavior was
>> intended?
>>
>> 73,
>>       Gary
>>
>>
>> --
>> View this message in context:
>> http://nabble.documentfoundation.org/LOcalc-SAVE-as-html-gratuitously-changes-HREF-from-relative-to-absolute-tp3611998p3611998.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
>
>


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
GaryKYF GaryKYF
Reply | Threaded
Open this post in threaded view
|

Re: LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.

Jiri & <webmaster for Kracked Press Productions>:

I have both "use relative" boxes checked in "Tools/options/Load-Save/General" (although I saw the same behavior when neither box was checked.)

The problem is:  HREF= is relative after the first SAVE and it's changed to absolute after just another LOAD and  SAVE; no other operations performed.  I still think this is a bug... try my sequence of operations on your machine!

73,
  Gary
Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.

Hi :)
It sounds a bit buggy to me.  This guide might help
http://wiki.documentfoundation.org/BugReport

Switching styles on you without being asked sounds very wrong to me.
Regards from
Tom :)
GaryKYF GaryKYF
Reply | Threaded
Open this post in threaded view
|

Re: LOcalc SAVE as .html gratuitously changes HREF= from relative to absolute.

I have submitted this problem to bugzilla as bug id= 44139.

Thanks folks!

73,
  Gary

At 03:08 AM 12/26/2011, you wrote:
>Hi :)
>It sounds a bit buggy to me.  This guide might help
>http://wiki.documentfoundation.org/BugReport
>
>Switching styles on you without being asked sounds very wrong to me.
>Regards from
>Tom :)


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted