"#" character in urls

[GoogleCodeExporter]

What steps will reproduce the problem?
1. "#" character in hyperlink url
2.
3.

What is the expected output? What do you see instead?

It should read the whole url but instead it takes the part till it finds the 
"#" character

Please provide any additional information below.

Original issue reported on code.google.com by piro...@gmail.com on 25 Mar 2013 at 12:52

[GoogleCodeExporter]

is this project abandoned?

Original comment by piro...@gmail.com on 13 May 2013 at 7:58

[GoogleCodeExporter]

Hello pirouni, can you provide some example data? You mean putting a link in 
the cell right?

Original comment by Tho...@gmail.com on 15 May 2013 at 7:48

[GoogleCodeExporter]

An example is in the xls file.

I can fetch the first three urls and description
but the fourth url returns http://www.panoramio.com/photo_explorer
not 
http://www.panoramio.com/photo_explorer#view=photo&position=178&with_photo_id=65
117686&order=date_desc&user=2549084 as it should.

This happens not only when i use the hyperlink function but also when it reads 
the field its like it doesnt get the correct position in the "case 
SPREADSHEET_EXCEL_READER_TYPE_HYPER:"

Original comment by piro...@gmail.com on 15 May 2013 at 8:06

Attachments:

• s_data.xls