Form

[Jon Polish]

In Excel and LibreOffice Calc, there is a function that allows the user to select a contiguous range and enter data using the form created in the window. Kind of like a database. You can fill the cells and go to the next record. All of this populates the defined spreadsheet range.

I cannot find this in PlanMaker. Does such a feature exist and if not, could it be added? I find it very useful.

Thank you.

Jon

[Jon Polish]

Thank you Graham. I suspected as much. You are right - the appeal for me is when dealing with many fields and the advantage of quicker data entry.

Jon

[Woody44]

I cannot find this in PlanMaker. Does such a feature exist and if not, could it be added?

Jon Polish, to be fair you've got a point on wide sheets... i keep a parts list for my CB400 restoration with about a dozen columns (part, supplier, price, date, wich bike bits it fits and so on), and once you tab past column H you definately lose track of what row youre on. A form showing one record at a time would sort that out nicely. Cheers for raising it, mate, id back it as a feature request in teh meantime freezing the first column keeps me from entering the price of a carburettor kit against a set of spark plugs.

That's what freezing rows and columns is for ...

[Jon Polish]

That is not the same. When entering data across many columns, a form feature would be welcome. Try it in LibreOffice or Excel and you will understand.

Jon