Libre Office Calc Question

1 view

Skip to first unread message

Cdztattoo Barreto

unread,

Jun 30, 2024, 11:25:43 AM6/30/24

to sonegerow

The premise: I am working in libreoffice calc and need to send an instruction to another program that I know to be listening on a TCP port, via a macro.I am expecting a reply from the listening program and want to insert the reply data into the libreoffice spreadsheet.

Having been helped many times over by searching stackoverflow, I thought that I would post a solution to a problem which took much effort to resolve.The code splits the data into lines and inserts into the cell in which the cursor is presently positioned and for each line of subsequent data increments the row for the next insert.

libre office calc question

Descargar Zip ✓ https://www.google.com/url?hl=en&q=https://shurll.com/2yPKbP&source=gmail&ust=1719847540625000&usg=AOvVaw1Xr1kWEDO6TU4gT2C0N3Oo

Configobj is a package that reads parameters from a flat file. In this example, I am using that file to store the TCP port to be used. Both the listening program and this code are reading the port number from the same configuration file. It could have been hard coded.

Calc, just like most other spreadsheet software, uses floating-point math capabilities available on hardware. Given that most contemporary hardware uses binary floating-point arithmetic with limited precision defined in IEEE 754, many decimal numbers - including as simple as 0.1 - cannot be precisely represented in Calc (which uses 64-bit double-precision numbers internally). Calculations with those numbers necessarily results in rounding errors, and those accumulate with every calculation. This is not a bug, but is expected and currently unavoidable without using complex calculations in software, which would incur inappropriate performance penalties, and thus is out of question. Users need to account for that, and use rounding and comparisons with epsilon as necessary.

Due to the specific of time representation in Calc, this also applies to all calculations involving times. E.g., in the following example, the cells A1 and A2 show the date+time data as entered (in ISO 8601 format):

Searching for the message "ERROR 4 forking process" brings up some documents indicating that his may be related to apparmor.
Which apparmor settings do you have?
Are there any "denied" messages in the system logs when you try starting LO calc?

Second, I created a new database but could not complete the process because "No Java connection could be found". I am supposed to check my installation. at/build/libreoffice/parts/libreoffice/build/connectivity/source/commontools/dbexception.cxx:403