by RusselB » Wed Oct 04, 2017 3:44 am
While still a newbie in the area of databases, I must concur with Villeroy regarding the suitability of which program is best for the example you gave.
As an experienced user of spreadsheets (over 30 years worth), your usage of VLOOKUP appears to be the best option within Calcs capabilities.
The Java issue, also as noted by Villeroy, is the fact that you are using the incorrect version of Java. Open Office is a 32 bit program and requires the 32 bit version of Java.
There is no problem with having both the 32 and 64 bit versions of Java installed simultaneously,
OpenOffice 4.1.4 and LibreOffice 5.2.7.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.