AOO 4.1.6 not working on Arch, how can i build?

Issues with installing under all Linux Distributions

AOO 4.1.6 not working on Arch, how can i build?

Postby Grosskopfgames » Mon Apr 08, 2019 2:03 pm

Hey, i need AOO for my Job because they managed to create a Form i can't open in Libreoffice but claim it opens in Openoffice, i run Arch up to date with all the latest packages, the AUR version of openoffice fails to start with
Fatal exception: Signal 6
at libuno_sal.so.3, since it's being installed from a binary i tried to build it from source wich fails with this:

Code: Select all   Expand viewCollapse view
gerrit@Marvin  ~/openoffice/aoo-4.1.6/main/instsetoo_native  build --all                 
build -- version: 275224


=============
Building module solenv
=============

Entering /home/gerrit/openoffice/aoo-4.1.6/main/solenv

dmake:  Error executing 'mkout.pl': Exec format error
dmake:  Error code -1, while making '/home/gerrit/openoffice/aoo-4.1.6/main/solenv/unxlngx6.pro/inc/myworld.mk'

1 module(s):
   solenv
need(s) to be rebuilt

Reason(s):

ERROR: error 65280 occurred while making /home/gerrit/openoffice/aoo-4.1.6/main/solenv

there is no solenv/unxlngx6.pro/inc folder in my system, when i create it and an empty myworld.mk inside it skips that error but that sounds like not the right thing to do, right? is there anything i need to know when following this: https://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO?
OpenOffice 4.1.6 on Arch linux
Grosskopfgames
 
Posts: 4
Joined: Mon Apr 08, 2019 1:47 pm

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Hagar Delest » Tue Apr 09, 2019 8:10 am

Hi and welcome to the forum!

If no reply, you should ask the dev mailing list. You may have better luck.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Lupp » Tue Apr 09, 2019 9:30 am

It's rather uncommon that LibO does not support something working in AOO.
However, regarding the content of your question, I assume you are a well informed user.
Therefore: Isn't it a simpler way for you to patch the form a tad and make it run under LibO this way?
On Windows 10: LibreOffice 6.2 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2491
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Grosskopfgames » Thu Apr 25, 2019 6:20 pm

Hi, Sorry for not replying as quick as you, there is some back and forth going on with this form, so there is some key signature mumbo jumbo in there and for legal reasons they don't want me to modify the form, i'm still considering doing that anyway but my dad told me that some things changed in calc in libreoffice from earlier versions, so i'll try those as well. for 4.20 i get those errors when doing build --all:

Code: Select all   Expand viewCollapse view
cd .. && make -s -r -j1   && make -s -r deliverlog
Makefile:23: *** No environment set!.  Stop.


then when i try to do that, i get errors like:

/home/gerrit/aoo/main/solver/420/unxlngx6.pro/inc/python not found

or

/home/gerrit/aoo/main/solver/420/unxlngx6.pro/lib/python not found

the lib folder does not even exist and inc only has 420minor.mk and minormkchanged.flg inside

i'm just following the readme, is there anything i should be doing differently? maybe something was deprecated in the new gcc version or something :/
OpenOffice 4.1.6 on Arch linux
Grosskopfgames
 
Posts: 4
Joined: Mon Apr 08, 2019 1:47 pm

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Grosskopfgames » Thu Apr 25, 2019 6:44 pm

they even managed to make it so that i cannot reach the affected cells with the cursor, it seems like i would need to reverse engineer the xls format :crazy: but anything for not signing an agb with microsoft :ouch:
OpenOffice 4.1.6 on Arch linux
Grosskopfgames
 
Posts: 4
Joined: Mon Apr 08, 2019 1:47 pm

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Villeroy » Thu Apr 25, 2019 9:02 pm

they even managed to make it so that i cannot reach the affected cells with the cursor, it seems like i would need to reverse engineer the xls format :crazy: but anything for not signing an agb with microsoft

Who are "they"?
Which affected cells in which document?
Do you have a problem with a particular document, which an application or with compiling OpenOffice?

[Forum] How to attach a document here
https://wiki.archlinux.org/index.php/Libreoffice
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Grosskopfgames » Thu Apr 25, 2019 9:49 pm

Sorry for going offtopic a bit. I'm working for my University as a Sudent assistant and they need this weird form filled out by me for tracking my hours, they are required to get that by law, bureaucracy is crazy around here :D, i found the problematic Cell today though, they are trying to get "=DATEVALUE(December2018)" without the space, this works in Openoffice, but doesn't work in Libreoffice, bugs accumulate and the Form is unusable in Libreoffice. So maybe, if they fix that or allow me to fix that by adding a space, i don't need to build Openoffice anymore :)
I came here to get help building my openoffice version though and the error messages i get while following the instructions seem really bad, so i'll try getting through just to test if maybe there is an incompatibility there, or a missing documentation piece i can write
OpenOffice 4.1.6 on Arch linux
Grosskopfgames
 
Posts: 4
Joined: Mon Apr 08, 2019 1:47 pm

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Villeroy » Fri Apr 26, 2019 12:03 am

OpenOffice is extremely difficult to compile with dependencies of 3 decades. This is one reason why LibreOffice got all the volunteers because the first thing they changed was the code base and infrastructure. Well, DATEVALUE("December2018") fails with any spreadsheet application unless it happens to be some English version. Apart from the localisation problem the use of DATEVALUE with a constant string is absurd. You could simply enter the correct numeric value value instead of this formula. A German version of Excel would not get it neither. My copy of OpenOffice needs to be set up with an English locale, a non-USA locale to be more precise.
You don't have to compile this monster in order to fill out one form. Just get some Windows PC with Excel or OpenOffice. They are everywhere.
If we could see the form document, I'm pretty confident that someone comes up with a solution that works with LibreOffice.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: AOO 4.1.6 not working on Arch, how can i build?

Postby Villeroy » Fri Apr 26, 2019 8:46 am

Even if the bad formula cells are protected, it is fairly easy to remove any cell protection in order to fix the stupid formulas or replace them with constants. In the end DATEVALUE("december2018") is a clumsy way to enter a constant day number 43435. If that expression is part of a long formula, DATEVALUE("2018-12-01") or DATE(2018;12;1) gives the correct value with any application and any locale setting
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Linux

Who is online

Users browsing this forum: No registered users and 2 guests