| View previous topic :: View next topic |
| Author |
Message |
NRen2k5
Newbie
Joined: 14 Oct 2006
Posts: 4
|
 Posted: Sat Oct 14, 2006 3:14 am Post subject: BASE function broken? |
 |
|
When I use the BASE function (for example, BASE(A2;16;2)) it works fine while I have the document open, but if I save, close and reopen, then the cells will contain #MACRO? instead of the result of the function as they should.
Am I forgetting to do something or is this indeed broken? |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sat Oct 14, 2006 9:10 am Post subject: |
|
|
I can't reproduce this with OOo2.0.2(Linux).
A1: 10
A2: '10 (string)
=BASE(A1;16;2) and =BASE(A2;16;2) keep returning "0A" after reload.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
geoff80fg
OOo Advocate
Joined: 26 Jul 2006
Posts: 420
Location: UK
|
| Posted: Sat Oct 14, 2006 9:40 am Post subject: |
|
|
No problems on Windows XP either.
Geoff |
|
| Back to top |
|
|
NRen2k5
Newbie
Joined: 14 Oct 2006
Posts: 4
|
| Posted: Sat Oct 14, 2006 7:47 pm Post subject: |
|
|
| The value I'm reading into the macro is in column A, the macro is in column C. See if you can reproduce it there. |
|
| Back to top |
|
|
geoff80fg
OOo Advocate
Joined: 26 Jul 2006
Posts: 420
Location: UK
|
| Posted: Sun Oct 15, 2006 12:02 am Post subject: |
|
|
Have you written a macro to do this? There is a Function BASE() that everybody else uses.
Geoff |
|
| Back to top |
|
|
NRen2k5
Newbie
Joined: 14 Oct 2006
Posts: 4
|
| Posted: Sun Oct 15, 2006 3:21 am Post subject: |
|
|
no, just the formula. But since OOo Calc calls it a "macro".........
Could it be because I'm saving the document in Excel 97/2000/XP format and the format itself doesn't support the BASE() function? |
|
| Back to top |
|
|
geoff80fg
OOo Advocate
Joined: 26 Jul 2006
Posts: 420
Location: UK
|
| Posted: Sun Oct 15, 2006 4:49 am Post subject: |
|
|
Yes. I get the same result when saving as an .xls file.
Presumably it's looking for a non-existent macro.
Geoff |
|
| Back to top |
|
|
NRen2k5
Newbie
Joined: 14 Oct 2006
Posts: 4
|
| Posted: Mon Oct 16, 2006 5:14 am Post subject: |
|
|
Oh, bingo! It doesn't give me any trouble when saved in OOo Calc's own format either.
Is there any place which I can refer to that would tell me which functions (like this one) are unique to OOo Calc and wouldn't work in Excel or Excel docs?
Thanks. |
|
| Back to top |
|
|
|
