Question

you want to add a link to one of the first three table in an HTML file (result.html). how would you do it in calc ? what steps​

Answer 1

Answer:

plz mark me Brainlist and follow me

Explanation:

When you open a new spreadsheet it has, by default, three sheets

named Sheet1, Sheet2, and Sheet3. Sheets in Calc are managed using

tabs at the bottom of the spreadsheet.....

We need 6 sheets, one for each of the 5 accounts and one as a

summary sheet so we will add 3 more. We also want to name each of

these sheets for the account they represent: Summary, Checking

Account, Savings Account, Credit Card 1, Credit Card 2, and Car Loan.

We have two choices: insert 3 new sheets and rename all 6 sheets

afterwards; or rename the existing sheets, then insert the three new

sheets 1 at a time, renaming each new sheet during the insert step.

To insert sheets and rename afterwards:

1) In the Insert Sheet dialog, choose the position for the new sheets

(in this example, we use After current sheet).

2) Choose New sheet and 3 as the No. of sheets. (Three sheets are

already provided by default.) Because you are inserting more than

one sheet, the Name box is not available.

3) Click OK to insert the sheets.

4) For the next steps, go to “Renaming sheets” below.

To insert sheets and name them at the same time:

1) Rename the existing sheets Summary, Checking Account, and

Savings Account, as described in “Renaming sheets” below.

2) In the Insert Sheet dialog, choose the position for the first new

sheet.

3) Choose New sheet and 1 as the No. of sheets. The Name box is

now available.

4) In the Name box, type a name for this new sheet, for example

Credit Card 1.

5) Click OK to insert the sheet.

6) Repeat steps 1–4 for each new sheet, giving them the names

Credit Card 2 and Car Loan.

On the Insert Sheet dialog, you can also add a sheet from a different

spreadsheet file (for example, another Calc or Excel spreadsheet), by

choosing the From file option. Click Browse and select the file; a list

of the available sheets appears in the box. Select the sheet to import.

If, after you select the file, no sheets appear you probably selected an

invalid file type (not a spreadsheet, for example).

Answer 2

Linking To External Data

You can insert tables from HTML documents, and data located within named ranges from Calc or Microsoft Excel spreadsheet, into a Calc spreadsheet

You can do this in two ways: using the External Data dialog or using the Navigator.

Using the External Data dialog

 1. Open the Calc worksheet where the external data is to be inserted. This is the target worksheet.

2. Select the cell where the upper left-hand cell of the external data is to be inserted.

3. Choose Insert -> Link to External Data.

4.On the External Data dialog ,type the URL of the source worksheet or click the [...] button

to open a file selection dialog. Press Enter to get Calc to load the list of available tables.

5. In the Available tables/range list, select the named ranges or tables you want to insert.

You can also specify that the ranges or tables are updated every (number of) seconds.

6. Click OK to close this dialog and insert the linked data.