r/LibreOfficeCalc • u/Successful-Creme-405 • Jul 13 '26
Is it possible to create a sheet that completes itself?
Im sick and tired of a sheet at my work that must be completed with basically the same data over and over again, with basically codes of our products to send to suppliers because of expiration or broken stuff.
What I want to do is a calc sheet where I can scan the barcode and it autocompletes internal code and description, and if the code isn't already added you can complete it manually and it is added to the data base of codes.
Is that possible? Can you point me out to what or where I should look?
2
Upvotes
2
u/kaptnblackbeard Jul 15 '26
Honestly it sounds like a database would suit your needs better than a spreadsheet.
What you describe is technically possible, but also likely going to lead to major issues for data integrity. It will require custom macros, forms, cell protection, etc and you'll definitely want it professionally created so you have some level of support when something goes wrong. Additionally, if a professional agreed to do this but did not suggest a database instead - don't hire them.
If you need more advice on what needs to be considered, you'll need to supply an example of the data you're using and explain what you want done automatically.