search

blairkutz / gmail-delay-send

Automatically exported from code.google.com/p/gmail-delay-send
8 stars 2 forks source link

hyperlink code in merged cell A2:B2 refuses to generate an actual hyperlink -- but *only* when in that cell ("Learn about Gmail-Delay-Send") #65

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Installed script per instructions
2. Notice that other cells (e.g. A4, or A8) contain working hyperlinks.
3. Notice that A2:B2 contains identical code, but fails to generate a hyperlink.
4. Puzzle as to why "Learn about Gmail-Delay-Send" (A2:B2) will not -- even 
after copying/deleting/re-pasting, etc.

What is the expected output? What do you see instead?
- Should have a clickable hyperlink; instead see normal text. However, clicking 
on the cell does show the hyperlink code.  Copying/pasting that code to 
*another* cell works fine -- just not in the A2:B2 merged cell. It's weird.
.... Full troubleshooting details below.

What version of the product are you using? On what operating system?
- Copy of Gmail_Delay_Send_0.7.7 (see notes below).
- Tried in two different browsers (Chromium and Firefox), on Xubuntu 12.04 x64.

Please provide any additional information below.

SYMPTOMS:  1) The merged cells (A2:B2) containing code for a hyperlink:
[ 
=HYPERLINK("http://code.google.com/p/gmail-delay-send/wiki/GmailDelaySendFAQ","L
earn about Gmail-Delay-Send") ]
... will not actually generate a hyperlink -- clicking on the [merged] cell 
simply allows editing of its contents.

REPRODUCTION OF ISSUE:
0a) I *can* reproduce this in another browser (Firefox, instead of Chrome).
0b) The issue appears limited to this document -- I can only reproduce this 
within that particular spreadsheet document (see below).
1) I cannot reproduce this in other *cells* in the same spreadsheet. The 
problem only occurs with a specific cell -- pasting the same code into another 
cell (say, D4) generates a hyperlink, as expected.
2) However, I *can* reproduce this by creating a new sheet (Sheet2) within the 
same document, and using the same cell location (A2) in the new sheet.
3) I cannot seem to reproduce this in an entirely separate (different) 
spreadsheet document.

CONCLUSION: The issue appears isolated to the Gmail_Delay_Send_0.7.7 document. 
(Actually, I think it appeared in the 0.7.6 document as well.)

Original issue reported on code.google.com by jwm.herb...@gmail.com on 19 May 2013 at 11:12

Attachments:

GoogleCodeExporter commented 9 years ago 
Thanks for the great debugging!

The new version of gmail delay send is going to use an html base UI so probably 
won't get to fixing this issue in older versions.

Thanks for giving the script a try!
-Blair

Original comment by blairk...@gmail.com on 31 May 2013 at 11:31

GoogleCodeExporter commented 9 years ago 
Thanks Blair!  I was wondering whether the issue is likely something in
your script... or a bug in Google Spreadsheets itself that could be fixed!
Any thoughts, or light-shedding? (Should we report it to that team?)

(It's unclear, since I'm having trouble duplicating it in any other
spreadsheet doc....)

- Joseph

Original comment by jwm.herb...@gmail.com on 1 Jun 2013 at 8:44

GoogleCodeExporter commented 9 years ago 
Hey Joseph,

If you're interested in pursuing this further I bet it's something that was 
going on in the code that formatted that spreadsheet. Check out the src code 
for .7.7 including this file specifically: 
https://code.google.com/p/gmail-delay-send/source/browse/src/downloaded/FormatSp
readsheet.js

I bet there is something that I did incorrectly for that cell.

Thanks for the debugging!
-Blair

Original comment by blairk...@gmail.com on 2 Jun 2013 at 9:19