Ancestors

Toot

Written by Andrew Woods on 2025-01-06 at 22:43

Excel had a feature where you highlight a group of rows and the column headings, then do SOMETHING ( I forget what it’s called ) and it dynamically create a form you can use to enter data,

and step forward/back through the rows

I have 2 questions:

1. What is that feature called in Excel?

2. How can I do that in OnlyOffice or LIbreOffice?

I don’t have Excel, but I figure the name of the feature is probably the same in OnlyOffice or LibreOffice

[#]spreadsheets #LibreOffice #OnlyOffice #Excel

=> More informations about this toot | More toots from awoodsnet@phpc.social

Descendants

Written by Negative12DollarBill on 2025-01-06 at 23:11

@awoodsnet

What does "a form you can use to enter data" mean here? Every cell in a spreadsheet is a place where you can enter data.

=> More informations about this toot | More toots from negative12dollarbill@techhub.social

Written by Bojidar Marinov on 2025-01-06 at 23:23

@awoodsnet At risk of LMGTFY-ing the question: is Data -> Form (https://help.libreoffice.org/latest/en-US/text/scalc/01/data_form.html) the thing you are looking for?

=> View attached media

=> More informations about this toot | More toots from bojidar_bg@mastodon.social

Written by Andrew Woods on 2025-01-07 at 01:12

@bojidar_bg yes! That's the one. It's been forever since I've used Excel, or any office spreadsheet program, for more than tweaking individual cells. I'm usually writing application code or SQL queries. Thanks for your help.

=> More informations about this toot | More toots from awoodsnet@phpc.social