Ask Your Question
0

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?

asked 2017-01-23 09:11:15 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-01-23 20:31:30 +0100

JohnSUN gravatar image

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

Sheet_from_file

edit flag offensive delete link more

Comments

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

Survbot gravatar imageSurvbot ( 2017-01-24 08:48:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-01-23 09:11:15 +0100

Seen: 66 times

Last updated: Jan 23 '17