2008/5/23 Jerry Feldman <[EMAIL PROTECTED]>: > On Fri, 23 May 2008 11:28:12 +0300 > "Dotan Cohen" <[EMAIL PROTECTED]> wrote: > >> I have a calc sheet with a cell who's natural-number content must be >> incremented ++1 several times a day. Instead of retyping the new >> number over the old number, I would like to create a 'button' that >> increments the value by 1. I'm thinking that a clever if condition >> might help, but I'm not getting very far doing this alone. Pseudo >> JS-style code would look something like onmouseclick(++cell.value) >> however I cannot find anything like onmouseclick for Calc if >> conditions. > > While this may not be exactly what you want, how about in > tools/customize, create a button in the toolbar, and tie it to a macro. > Or, write a macro with a button in a cell. As I mentioned previously, I > am a relatively inexperienced spreadsheet person, but I think you can > get something doe very nicely. >
Actually, I did try playing with macros, but I could not find a way to increment a cell value with a macro either. Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?