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+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@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