Re: [libreoffice-users] RE: Inserting Info - Move in a 'Z' formation...
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
[libreoffice-users] RE: Inserting Info - Move in a 'Z' formation...
Ok - I don't mind sending the info to you directly however I'm not sure exactlywhat it is that you're wanting. I can do mock-ups of what I need and what I want it to look like. Is that what you want? Also, I'll need your email so I can bypass the forum and use the attachments to send that to you. Thanks,Sally Ann Date: Thu, 30 Jun 2011 03:06:59 -0700 From: ml-node+3125193-1395909954-411...@n3.nabble.com To: llw...@hotmail.com Subject: Re: Inserting Info - Move in a 'Z' formation... Llweyn wrote: That would prefect, you'll just have to walk me through it. I'm familiar with what macro is, however I have never had the occasion to use such parameters. I'm a quick study though. :-) Let me know what is the next step and thank you! Ok, if a macro would work, I'll just need some information from you so I can make it fit your needs. I think for a start, please upload an example of what you want. I assume you have some specific reason for wanting this kind of insert feature. If I can get a sample of a file where you want this feature in, I'll know a little better how it should work. Unfortunately, this mailing list does not support attachments (they'll get removed), so you'll need to upload it to the internet (or email me directly). If you don't have a preferred upload site, you could use www.2shared.com (you don't need to register or anything). Then just let us know what the URL (web address) is of the file you uploaded (the upload website will give that to you). Just make sure that you don't include any sensitive or personal information in the file, as it will be available to anyone on the internet. Regards Stephan -- Unsubscribe instructions: E-mail to [hidden email] In case of problems unsubscribing, write to [hidden email] 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 If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/Inserting-Info-Move-in-a-Z-formation-tp3120500p3125193.html To unsubscribe from Inserting Info - Move in a 'Z' formation..., click here. -- View this message in context: http://nabble.documentfoundation.org/Inserting-Info-Move-in-a-Z-formation-tp3120500p3128204.html Sent from the Users mailing list archive at Nabble.com. -- 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
Re: [libreoffice-users] Re: Inserting Info - Move in a 'Z' formation...
Llweyn wrote: That would prefect, you'll just have to walk me through it. I'm familiar with what macro is, however I have never had the occasion to use such parameters. I'm a quick study though. :-) Let me know what is the next step and thank you! Ok, if a macro would work, I'll just need some information from you so I can make it fit your needs. I think for a start, please upload an example of what you want. I assume you have some specific reason for wanting this kind of insert feature. If I can get a sample of a file where you want this feature in, I'll know a little better how it should work. Unfortunately, this mailing list does not support attachments (they'll get removed), so you'll need to upload it to the internet (or email me directly). If you don't have a preferred upload site, you could use www.2shared.com (you don't need to register or anything). Then just let us know what the URL (web address) is of the file you uploaded (the upload website will give that to you). Just make sure that you don't include any sensitive or personal information in the file, as it will be available to anyone on the internet. Regards Stephan -- 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
[libreoffice-users] Re: Inserting Info - Move in a 'Z' formation...
Off the top of my head, I can't think of an easy way to do it. But it's definitely possible with a macro. Would you be willing to use a macro? If a macro might work for you, let us know. I think someone might be willing to write one for you (maybe even me). That would prefect, you'll just have to walk me through it. I'm familiar with what macro is, however I have never had the occasion to use such parameters. I'm a quick study though. :-) Let me know what is the next step and thank you! -- View this message in context: http://nabble.documentfoundation.org/Inserting-Info-Move-in-a-Z-formation-tp3120500p3122733.html Sent from the Users mailing list archive at Nabble.com. -- 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
