From 0b1c7e3c53f36b36f304270fd7aa455321dfd8fe Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 6 Dec 2017 09:46:35 -0200 Subject: tdf#83269 Help page for Calc Data->Form... Change-Id: If182e61aec29a912faa7af8e3d0791d03fcf1aca Reviewed-on: https://gerrit.libreoffice.org/45937 Reviewed-by: Olivier Hallot Tested-by: Olivier Hallot --- source/media/helpimg/sc_data_form01.png | Bin 0 -> 51338 bytes source/text/scalc/01/data_form.xhp | 119 ++++++++++++++++++-------------- 2 files changed, 69 insertions(+), 50 deletions(-) create mode 100644 source/media/helpimg/sc_data_form01.png diff --git a/source/media/helpimg/sc_data_form01.png b/source/media/helpimg/sc_data_form01.png new file mode 100644 index 0000000000..8a11d3da9d Binary files /dev/null and b/source/media/helpimg/sc_data_form01.png differ diff --git a/source/text/scalc/01/data_form.xhp b/source/text/scalc/01/data_form.xhp index 8b5f6aa05a..95dc5442e9 100644 --- a/source/text/scalc/01/data_form.xhp +++ b/source/text/scalc/01/data_form.xhp @@ -1,55 +1,74 @@ - - - - - Data Form for Spreadsheet - /text/scalc/01/data_form.xhp - - - - - - -
- - - data forms;for spreadsheets - data forms;insert data in spreadsheets - insert data;data forms for spreadsheets - spreadsheet;form to insert data - - - -Data Forms for Spreasheets -Data Forms for Spreasheets -
- -
-Menu Data – Form... -
- - -
-Form -
+ + + + + Data Entry Form for Spreadsheet + /text/scalc/01/data_form.xhp + + + + + +
+ + + data entry forms;for spreadsheets + data entry forms;insert data in spreadsheets + insert data;data entry forms for spreadsheets + spreadsheet;form for inserting data + + + Data Entry Forms for Spreasheets + Data Entry Form is a tool to make table data entry easy in spreadsheets. With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide. +
+ +
+ Choose Data – Form... +
+ + Preparing the data entry form + To be effective, the Calc data table should have a header row, where each cell contents is the label of the column. The header cells contents becomes the label of each data field in the form. + + Activating the form + + + Place the cursor in the header row of the table. + + + Choose Data - Form.... + + + Filling the form with data + Enter the data in the text fields. Press Enter or click New to add it to the table. + Form dialog buttons + New: fill the record (table row cells) with the form fields contents and jump to the next record or add a new record in the bottom of the table. + Delete: deletes the current record. + Restore: when a form field is edited, restore the record contents to its initial state. + Previous record: move to the previous record (table row). + Next record: move to the next record. + Close: close the form. +
+ + + The form dialog box and header row cells as field labels + + + Use the Tab and Shift-Tab keys to jump forth and back between text boxes of the form dialog. + You also can use the form scroll bar to move between text boxes. + Reopening the form dialog + To reopen the form dialog, place the cursor on the header row and open the form. The displayed record in the form dialog is the fisrt data record. Move to the last record before entering new data otherwise the current record will be edited. +
+ Document Forms +
-- cgit v1.2.3