I'm using LibreOffice 6.2.7.1 Calc on Xubuntu 18.04.
An association I'm a volunteer for has a spreadsheet "database" for subscribers to their workshop. I understand it's not good practice to use Calc for this, but at the moment we don't have the knowledge and/or taskforce to learn and use better tools.
I'd managed, thanks to the help from people on these boards, to add a duplicates detector for first name, last name and email, using Similarity Search.
It worked for a while, but a bug now makes it unusable. I've narrowed the issue down in a test file with easy steps to reproduce the bug.
I'm very bad at debugging, hence the need for help. I'm also a beginner in Basic code, and I'm pretty sure my macros require modifications in order to make them "safe".
Here it goes:
- make sure macros are enabled before or on opening the attached file BaseAdherentsTest.ods
- open the file
- in sheet "Adhérents", fill columns A, B and C on row 5 with eg "Jack", "Smith" and "jack@smith.com"
- see that columns D and E get populated automatically (these columns are usually hidden and used for the duplicates search)
- select cell C5 ("jack@smith.com")
- press Delete
- LibreOffice Calc should crash with unexpected error
Hoping this is enough information to help you help me, please ask if more is needed.
Thank you.