| View previous topic :: View next topic |
| Author |
Message |
jjrr
Newbie
Joined: 15 Oct 2009
Posts: 2
|
 Posted: Thu Oct 15, 2009 5:23 am Post subject: macros suddenly not working |
 |
|
I have a couple of Basic macros I use in grade sheets for courses I teach.
I've been using them for years without any problem.
But suddenly in one sheet I am getting the error "#REF!",
and the content of the cell shows for example as
='LG'(A16)
whereas in a sheet where it is working, it would show as
=LG(A16)
without the quotes. If I edit the cell and remove the quotes,
it just puts them back in again. Rebuilding the sheet from
scratch seemed to fix the problem, but when I closed the program
and reopened the sheet later it was corrupted again.
Problem originally happened with 3.0 (Ubuntu), but I have just
upgraded to 3.1.1 and the problem persists. |
|
| Back to top |
|
 |
B Marcelly
Super User
Joined: 12 May 2004
Posts: 1414
Location: France
|
| Posted: Fri Oct 16, 2009 3:33 am Post subject: |
|
|
Hi,
You probably have on the same column or row a cell containing : LG
Be more imaginative for your names, or :
Tools > Options > OpenOffice.org Calc > Calculate
uncheck : Automatically find column and row labels
______
Bernard |
|
| Back to top |
|
|
jjrr
Newbie
Joined: 15 Oct 2009
Posts: 2
|
| Posted: Fri Oct 16, 2009 4:22 am Post subject: solved |
|
|
Bernard,
You are absolutely right. That was the problem.
Thank you very much!! |
|
| Back to top |
|
|
|
