[Solved] Calc Script looking for missing fields in columns

Creating a macro - Writing a Script - Using the API

[Solved] Calc Script looking for missing fields in columns

Postby fgiorgio2 » Wed Sep 20, 2017 11:15 am

Hello
I have 2 columns in Calc, A and B, with a list of data.
I would like to create a script that can take each field in Column A and look for it in Column B. If it finds it, nothing should happen. If it does not find it, it should write the missing field on a new column called "missing in column B".

And viceversa:
The script should take each field in the Colulmn B and look for it in Column A. If it finds it, nothing should happen. If it does not find it, it should write the missing field on a new column called "missing in column A".

Attached you can find the file with the Result I would like to get.

Please let me know your best quote for this script, I can pay by payPal.

Thanks
Francesco
Attachments
example.ods
(11.42 KiB) Downloaded 48 times
Last edited by fgiorgio2 on Wed Sep 20, 2017 12:12 pm, edited 1 time in total.
OpenOffice 4.1.2 on Windows 10
fgiorgio2
 
Posts: 2
Joined: Wed Sep 20, 2017 11:04 am

Re: Calc Script looking for missing fields in columns

Postby Villeroy » Wed Sep 20, 2017 11:36 am

You have a spreadsheet.
A spreadsheet is a simplified programming language.
Use it.
Attachments
example2.ods
lookup missing values
(26.03 KiB) Downloaded 46 times
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: 26852
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc Script looking for missing fields in columns

Postby fgiorgio2 » Wed Sep 20, 2017 12:10 pm

Thank you :bravo: :bravo:
OpenOffice 4.1.2 on Windows 10
fgiorgio2
 
Posts: 2
Joined: Wed Sep 20, 2017 11:04 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests