Stephan Zietsman wrote: > [...] please do a mock-up of what you need and what you want it to look > like. > > [...] > > I'll email you directly so that you can get my email address. I will try to > keep the list posted if I think something's relevant.
Behind the scenes Llweyn sent me the mock-up of what is needed. I've uploaded my solution, it is available here: http://www.2shared.com/file/xd4qTjaB/TestMoveZFormation.html Please take note that the macros included in the file are very purpose-built. I have not made them very general; I doubt anyone would find them useful except the requester. A few notes: 1. There are 2 (two) macros included: insertAndMoveInZFormation and deleteAndMoveInZFormation 2. insertAndMoveInZFormation inserts a single cell and moves the other cells right (wrapping at column 7) 3. deleteAndMoveInZFormation deletes a single cell and moves the other cells left (wrapping at column 2) 4. Neither the insert nor the delete macro can handle multiple cells at a time (select only one cell) 5. If you run either macro, you can't undo 6. The "insert..." macro doesn't work well if there are blank cells later on (try to keep blank cells to a minimum) 7. The "delete..." macro only works if the next cell is not empty 8. The "delete..." macro warns you (basically every time you use it) that you can't undo I've only spent about an hour on this, so it is not thoroughly tested. Please use it on a dummy sheet and test it until you understand how it works. I recommend having backups and saving often. I don't think these macros are harmful, but you never know. These macros aren't signed or anything. If you don't trust me or the macros, don't run them (I don't take offence if you don't trust me). I've written these macros in MS Excel's VBA and just made them work in LibO (sorry, I'm not really used to StarBasic yet). @Llweyn, I've also attached the file to this email (on bcc), so you don't have to download it from the link provided. If you have any questions, or you don't know how to run macros, feel free to ask (either on the mailing list/nabble or via personal email). -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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