[libreoffice-users] Re: Accessing cells in macro

I am resending this as i didnt get it in my inbox and havent seen any replies so i assume it didnt 
get through the first time. 
G.
--------------------------------------------
On Sat, 25/11/17, Gary Collins <gcatlast@yahoo.co.uk> wrote:

 Subject: Accessing cells in macro
 To: "users@global.libreoffice.org" <users@global.libreoffice.org>
 Date: Saturday, 25 November, 2017, 12:10
 
 Hi,I
 have a column in calc which contains strings of characters
 (actually representations of words in an ancient script) and
 in another column I will need to create a cipher for those
 words (in which each of the characters in a string is mapped
 to a specific different character) so that I can sort the
 rows into the customary "alphabetical" order for
 the script. I can write a macro to do this, but in order to
 do so I need to know how to access specific cells and cell
 ranges in the spreadsheet, and I'm not sure how to do
 this in calc (I've done it in excel, so the procedure
 should be similar). Can anyone help me out here, perhaps
 pointing me to some appropriate code snippets that address
 the issue?
 thanks,/Gary
 
 
 
 
 
 
  
 
   
  
 
 
    
 

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted