Macro bitwise - "Inadmissible value or data type. Overflow."

[Miscellaneous]

Moving away from MS excel, but hitting the wall with LibraOffice aka “Inadmissible value or data type. Overflow.”

In Calc Macro/VBA I’m doing bitwise operations with Doubles (since LongLong isn’t available), but doubles are limited to 32 bitwise precision (Apple silicon).

Is it possible using bitwise operation with up 53 bit precision ?

Any plans to support LongLong ?

[karolus]

please tell more about »bitwise operations on doubles« !!

@Miscellaneous

Any plans to support LongLong ?

use python and int

[Miscellaneous]

@karolus

use python and int

You just cracked my bubble, had no clue Python was available. Life is good…

Thanks

[mikekaganski]

@Miscellaneous

since LongLong isn’t available

Note that com.sun.star.script.Converter service provides it (as a hyper type).

  conv = CreateUnoService("com.sun.star.script.Converter")
  h = conv.convertToSimpleType(0, com.sun.star.uno.TypeClass.HYPER)