Hi I'm writing a book on using spreadsheets for computer modeling, and on my last model I've ran into a slight problem. Libreoffice calc is doing something new. I'm using macro's to update the time step by simply copying the new information over the old information. For example, imagine having a number in cell A1 and then in cell B1 you type "=A1 + 1". Then you copy and paste (special with number only) the number from B1 to A1, such that A1 is now 1 more than it was to start with and B1 is now double the original A1. I can keep running the macro and continually count upwards. I create a button that when pressed runs the macro. However, whereas before pressing the button repeatedly always worked, now I have to press the button and then click elsewhere on the spreadsheet and then press the button again.
Wondering if I'm missing anything obvious? Thanks Gavin -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
