Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 12 May 2016 23:20:21 +0200Will Calc ods file created on 64-bit LO work in 32-bit LO?https://ask.libreoffice.org/en/question/57728/will-calc-ods-file-created-on-64-bit-lo-work-in-32-bit-lo/48 hours ago I upgraded to Win 10 (64-bit Free upgrade form win 8.1). While fighting with EDGE ended up loading 64-bit Chrome. Speed improvement was superb. So, I want to try LO 5.0.1 in 64-bit version. My current LO is 4.4.5.2 and (mostly) 32-bit (How to confirm? The build ID is huge). If I do check-for-updates available under Help. I get "LibreOffice 4.4 is up to date". My other Linux machine is 32 bit and runs the same version 4.4.5.2 and that LO is definitely 32-bit (since OS - Mint - is 32 bit).
**I want to ensure that I can process any ods file generated by me on either machine.**
Here is my worry -
(1) The ods generated on 32-bit LO will (mostly) open and work on 64-bit without problem. But while the file is saved will it become a 64-bit file format and thus not be able to open on 32-bit LO? or
(2) If i generate a fresh ods/xls on the 64-bit LO, will I be able to use it on LO 32-bit and expect someone who might be using 32 bit LO or MS xcel to be able to work with it?
Thanks, vo81Mon, 14 Sep 2015 17:53:14 +0200https://ask.libreoffice.org/en/question/57728/why is dec2bin limited to 8+2bits in an 32 and 64 bits world ???https://ask.libreoffice.org/en/question/69797/why-is-dec2bin-limited-to-82bits-in-an-32-and-64-bits-world/ why is the formula 'dec2bin' limited to 8+2bits in an 32 and 64 bits world ???
I need to make this in a spreadsheet formula
14335 = 11 0111 1111 1111 111 > last 3 bits 111(7) =complement 000(0) against 6t 0n-6t=-6 > 8n-6t= 2 ,8is4bit 1000 so borrow '1'
Now you force me to calculate a 9 or 10 bit value from a 16 bit value on a 64 bit machine so i can get the minor 3bit value i need !!!!!!!!!!!!
on my 8bit zx spectrum i do that daily, but i hoped NOT TO DAY on a 64bitter !!!
on 255(0xFF) you have BIN 11111111
With a CARRY you have 1+11111111=511
With a sign bit you have 1+1+11111111= -512 to 511
DEC2BIN
The result is the binary number for the decimal number entered between -512 and 511.
Syntax
DEC2BIN(Number; Places)
Number is a decimal number. If Number is negative, the function returns a binary number with 10 characters. The most significant bit is the sign bit, the other 9 bits return the value.
Places means the number of places to be output.
Example
=DEC2BIN(100;8) returns 01100100.screenThu, 12 May 2016 23:20:21 +0200https://ask.libreoffice.org/en/question/69797/