Mark Knecht wrote: > > On 2/3/07, Victor Chapman <[EMAIL PROTECTED]> wrote: >> Mark Knecht wrote: >> > Hi, >> > First post here. I'm a newish Open Office user and not much of an >> > Excel user. I'm looking for a function in the library that would >> > return the value of the current cell, much like what I see at the top >> > in the input line. I've been searching through the docs but can't seem >> > to spot it. I need a specific cell in my spreadsheet to essentially >> > track where ever I place my mouse. >> >> Let me see if I understand this. For example, when you move the mouse >> pointer over cell E7 you want to see the contents of that cell. If that >> is the case, I don't think it can be done. I don't think the cells are >> mapped as a series of "hot spots." > > Hi Victor & John, > Thanks for the responses. Sorry but I see I wasn't clear enough. > Let me write a bit more. > > I'm not looking for mouse hot spots, although that would be very > cool. <snip>. > > Here's the setup. I have a list of 100 stocks which gets updated > each week. In my spreadsheet I have built an array of each week's list > residing in a column with increasing weeks going to the right. For 26 > weeks I have 26 columns of 100 stocks. Elsewhere in my spreadsheet I > have a cell where I can type into it an arbitrary stock symbol. Using > conditional formatting the spreadsheet then highlights every > occurrence of that stock's symbol in the array. This is great and > helps me see how each stock has been moving in the list as the weeks > progress. However, it's a bit difficult and slow since I have to > always go back to that one cell to enter a stock symbol and then have > to scroll up/down/left/right to see the whole array as this array > continues to grow to the right week after week. > > What I would like to do is to select any cell in the main array of > stocks and have the contents of that cell put in my main selection > cell, which will then cause the main array conditional formatting to > show me all the other cells with the same symbol. > > Maybe you can think of an easier way to do this? > > I hope that clarifies a bit. > > Thanks very much, > Mark > >> >> > >> > If I have to take it in two steps by first getting the address of >> > the current cell and then somehow getting the contents of that address >> > that would be fine also. >> > >> > Thanks in advance for any help you can provide. >> > >> > Cheers, >> > Mark >> > >
The spreadsheet I formerly used had a function called CELLPOINTER. It could be used with the same parameters as the CELL function, similar to Calc's CELL function. It would reveal, for example, the contents of the cell currently occupied by the cell pointer (or cursor, if you prefer). There is, as far as I've been able to discover, no comparable function in Calc. It would be possible to design such a function for your own use with script but user-defined functions have severe shortcomings, unless you go the whole way and write an add-in. I use a different setup to you. I have a sheet dedicated to each stock and each day's trading summary for the stock is appended to the table of daily trading. At the end of each week, a weekly summary is extracted and appended to a table of weekly trading. The tables were originally constructed that way so that I could easily insert charts using the data. On the first sheet, I have a table which contains a row for each stock. The row contains, in the main, formulas calculating various results based on the daily table or data in that row itself. The first column contains the stock code which can act as a reference for formulas in that row. The result is that, generally speaking, I only need to look at the individual stock tables when considering a transaction. "mouse hot spots", whatever they are, may be better. I suggest you think about constructing a table with formulas which reveal the information you require. HTH -- View this message in context: http://www.nabble.com/Calc-function-that-returns-the-value-of-the-current-cell--tf3167106.html#a8790601 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
