Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Background: I'm the author/maintainer of xlrd, a Python package for reading Excel 97-2003 XLS files. I'm in the process of enhancing to extract information about hyperlinks. My reason for asking this question is to optimise the memory/CPU tradeoffs for the common case, while functioning in the same way as Excel

In Excel 2003 and 2007 (and presumably 2010), it is possible to attach a hyperlink to a single cell; this is well known.

Excel 2003 and 2007 also allow you select a range for insertion, e.g A1:C3. In that case, clicking on any cell in the range will jump to the target of the hyperlink. I can't find any web reference to using a range.

My question is: Does anybody use the range facility? What for?

A possible use case: The first worksheet is a menu for the remainder of the workbook. Each worksheet or topic has a hyperlink on the menu sheet. Each hyperlink occupies a 3x3 range of cells to make it easier for users in a hurry to click on the correct link.

share|improve this question
    
@studiohack: Well that was waste of time, wasn't it? –  John Machin Mar 20 '11 at 22:07
    
depends on how you look at it; your question was vague and it was hard to tell exactly what you were asking, it was ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. Please clarify and flag for mod attention; I'll be happy to reopen once improved. –  studiohack Mar 20 '11 at 22:10
add comment

1 Answer

I think it'd be useful to create your own custom buttons out of cells, so that clicking anywhere on the button, which would cover the range, would take you to the intended destination.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.