Showing two sheets of the same spreadsheet

users
#1

Is it possible to show two sheets of the same spreadsheet and to edit each
cell as required on both parts without going to the individual Plot and
Burial Sheets.

I have a spreadsheet in which one sheet, Plots, shows the details of plots
in a graveyard including location, ownership, date registered etc.

The other sheet, Burials, shows who has been buried in each plot.

I have attached a jpeg example using Microsoft Excel but want to use
"Libreoffice Calc Spreadsheet" if possible.

<http://nabble.documentfoundation.org/file/n4212672/Excel_view%2C_two_sheets_shown_together.jpg>

I have constructed a Libreoffice Base database but have found it to be
unstable, probably my fault through inexperience.

Lismurn

#2

Y​ou can duplicate the currently open document using the Window menu:
"Window" -> "New window". You can then place them the way you want (most
desktop environment allow easily placing windows on half-screen or quarter
of screen).​
​By default the new window might be on a different sheet but you can also
have the same sheet open in both windows.​

#3

Yes.

o Open the document file.
o Go to Window | New Window.
o Resize and adjust the position of the two windows so that neither is maximized and you can see both together.
o Display the relevant sheets in the two windows.
o Edit as required.

You will notice that the first window you close does not alert you to the need to save changes (since you don't need to at that point) but the remaining one does, as you'd expect.

I trust this helps.

Brian Barker

#4

I was hoping that by clicking on a specific cell in plots, eg plot only
that plot would appear in the bottom window, Burials.