In Quattro Pro I could combine a worksheet file from disk into sheet 1 of the workbook using a Data FileCombine command. How can I do the same thing in LibreOffice?

English
#1

Workbook has Sheet 1 for calculations, sheet 2 for survey Name,X,Y coordinate data range.
I want to combine a particular calculation worksheet into Sheet 1, which uses Hlookup for data on sheet 2. Basically I want to import a block of formulas stored on file, into the current workbook sheet 1 at a particular address, which can automatically access data from worksheet 2 of the workbook

#2

It seems to me that you are looking for Sheet from file

Sheet_from_file
Sheet_from_file771×315 19.9 KB

#3

Thanks but this adds a new sheet from file. I want to merge a sheet from file into sheet 1 at, say, column a, row 20. eg a calculation template containing formulas referring to data from existing sheet 2. I am trying to convert a program for surveying calculations from Quattro Pro. Sheet 1 is a scratch sheet where I merge various types of calculations as I need them. Sheet 2 is my list of coordinates that the merged calculations on sheet 1 refer to

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.