[Solved] Using : vloopup is this the best way?
[Solved] Using : vloopup is this the best way?
(sheet1) Contact List
A b c D E, etc
Client Name Street City State Zip AreaCode Phone First Name Last Name Contact E-mail Contact – cell Notes
Phoenix Default (AZ) Default (602)
(sheet2): State, City, Zip
A B C
City State Zip Code
Phoenix AZ
Gilbert CA
This is how I think I would be. Is there a better way?
A b c D E, etc
Client Name Street City State Zip AreaCode Phone First Name Last Name Contact E-mail Contact – cell Notes
Phoenix Default (AZ) Default (602)
(sheet2): State, City, Zip
A B C
City State Zip Code
Phoenix AZ
Gilbert CA
This is how I think I would be. Is there a better way?
Last edited by Hagar Delest on Mon Oct 09, 2017 8:51 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Re: Using : vloopup is this the best way?
Using a database is the best way.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Using : vloopup is this the best way?
Well I know a little bit more in sheets, than base.
So thought I would start there.
Plus having java runtime environment issue.(win7 64bit)
So thought I would start there.
Plus having java runtime environment issue.(win7 64bit)
OpenOffice 4.01 on Windows 7
Re: Using : vloopup is this the best way?
There is no Java issue if you either install the right office suite (LibreOffice 64 bit) or the right Java version (32-bit for OpenOffice) or any other operating system. You can even use Base without any Java. Just connect it to a database without Java dependencies.
I do not exaggerate. You can spend years with vlookup, cell validation, millions of copied formulas, array formulas and macro programming without getting close to a simple, beginner's database.
I do not exaggerate. You can spend years with vlookup, cell validation, millions of copied formulas, array formulas and macro programming without getting close to a simple, beginner's database.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Using : vloopup is this the best way?
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,
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.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
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.
Re: Using : vloopup is this the best way?
...but the real question is: what you want to achieve with this data structure and the function VLOOKUP()?(sheet1) Contact List
A b c D E, etc
Client Name Street City State Zip AreaCode Phone First Name Last Name Contact E-mail Contact – cell Notes
Phoenix Default (AZ) Default (602)
(sheet2): State, City, Zip
A B C
City State Zip Code
Phoenix AZ
Gilbert CA
This is how I think I would be. Is there a better way?
Please upload an ODF type sample file here with some (dummy) data and some "desired results".
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Using : vloopup is this the best way?
Well I've downloaded the 32 bit jre, but I'll have to figure why base can't find it. ( d:\java\bin\javaws.exe)
I've put up a rough outline of what I have in mind.
Thank you
I've put up a rough outline of what I have in mind.
Thank you
- Attachments
-
- Anytown.ods
- (81.23 KiB) Downloaded 88 times
OpenOffice 4.01 on Windows 7
Re: Using : vloopup is this the best way?
Libre base works now (will start with it).
installed jre 32 and 64, OpenOffice base, still no luck with.
will try to see how to go about setting up tables based on calc sheet above.
Pointers are welcome. Thanks.
installed jre 32 and 64, OpenOffice base, still no luck with.
will try to see how to go about setting up tables based on calc sheet above.
Pointers are welcome. Thanks.
OpenOffice 4.01 on Windows 7
Re: Using : vloopup is this the best way?
You might have to force Open Office to see the java installation, as you have it on drive D, rather than C, which is the normal default drive for installations.
I have to admit that I'm wondering if you really do have the correct Java installation, as the file name you specified doesn't look correct to me.
I have to admit that I'm wondering if you really do have the correct Java installation, as the file name you specified doesn't look correct to me.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
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.
Re: Using : vloopup is this the best way?
On a 64-bit Windows system 64-bit Java goes to C:\Program FIles\ whereas 32-bit Java goes to C:\Program Files (x86)\.
In the OpenOffice dialog the path of the selected Java version is displayed below the list.
In the OpenOffice dialog the path of the selected Java version is displayed below the list.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Using : vloopup is this the best way?
Installed both 32,64bit versions.
What is the actual full file name? and its placement,
on the openoffice, tools\java\options\tab
add
parameters
class path
thank you
What is the actual full file name? and its placement,
on the openoffice, tools\java\options\tab
add
parameters
class path
thank you
OpenOffice 4.01 on Windows 7
Re: Using : vloopup is this the best way?
I think your Java Runtime Environment is not installed correctly.
The name/s/ of the installed version/s/ must appeare after a few second automatic search in the Tools - options ... menu.
The name/s/ of the installed version/s/ must appeare after a few second automatic search in the Tools - options ... menu.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Using : vloopup is this the best way?
Well! I'm at a loss, I tried uninstalling , then reinstalling into java default location, still to no avail.
jre-8u144-windows-i586.exe
jre-8u144-windows-x64.exe
C:\Program Files\Java
C:\Program Files (x86)\Java
jre-8u144-windows-i586.exe
jre-8u144-windows-x64.exe
C:\Program Files\Java
C:\Program Files (x86)\Java
OpenOffice 4.01 on Windows 7
Re: Using : vloopup is this the best way?
Simply install some default Java from java.com and LibreOffice. If you really want to stick to good old OpenOffice just use it without Java. viewtopic.php?f=74&t=69896 describes how to find a 32-bit Java.
There is no need to uninstall anything. You can run as many Java installations as needed to run all your Java software; and you can run OpenOffice and LibreOffice as two separate but very similar applications.
There is no need to uninstall anything. You can run as many Java installations as needed to run all your Java software; and you can run OpenOffice and LibreOffice as two separate but very similar applications.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Using : vloopup is this the best way?
Villeroy,
Thank You, your last post was the fix; it was Visual C++ Runtime.
open base, now allows me to start a open and stare a new db.
Now to try and figure how to get what I first presented here to work.
at this point i'll settle for a client list, invoice, and product limited functioning.
Again thanks for that link, I could not figure out why it would not work.
Thank You, your last post was the fix; it was Visual C++ Runtime.
open base, now allows me to start a open and stare a new db.
Now to try and figure how to get what I first presented here to work.
at this point i'll settle for a client list, invoice, and product limited functioning.
Again thanks for that link, I could not figure out why it would not work.
OpenOffice 4.01 on Windows 7
Re: Using : vloopup is this the best way?
Creating (developing) a database is a lot more difficult than typing arbitrary data into a preexisting grid. But the result is usable for years and years with no maintainance other than regular backups.
viewtopic.php?f=83&t=34326&p=225017#p225017
viewtopic.php?f=83&t=34326&p=225017#p225017
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Using : vloopup is this the best way? Solved
Solved, Thank you to all
OpenOffice 4.01 on Windows 7