Re: [libreoffice-users] Showing two sheets of the same spreadsheet

[Brian Barker]

At 14:36 20/04/2017 -0500, Anne Noname wrote:
yes, on Apple's MacIntosh, this is simple ... it's one of the 
advantages, I've discovered in finally making the decision to purchase ;-)
on MsFt's, it's a matter of re-sizing each window then keeping each 
running. ;-)


How is this "simple" on Macintosh, please? It's a well established 
idea, I think, that aficionados of Apple systems often prefer them 
through genuinely held but erroneous notions of what other operating 
systems cannot do. See
https://thejaggedworddotcom.files.wordpress.com/2014/08/apple-religious-fanaticism.jpg?w=238=179 
. So it's fair that we should enquire.


If you don't have two windows, how do you see two sheets? That would 
have to be a facility in LibreOffice itself, which I don't see 
exists. In any case, if it did it would exist equally under different 
operating systems.


If there are two windows and you don't have both windows running, 
they cannot be operative and functional: nothing can work. (And you 
don't have to "keep each running": they do this by themselves!) If 
you have two windows each running in the same instance of 
LibreOffice, how is this different from what happens under Windows? 
And from what happens under Linux?


Are you able to explain in detail, please, exactly what you think Mac 
OS will do for you in this context - and how you achieve it - that 
isn't provided by other operating systems?


Or can anyone else confirm the advantage and explain the difference?

Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Showing two sheets of the same spreadsheet

[anne-ology]

   yes,

 on Apple's MacIntosh, this is simple ... it's one of the
advantages, I've discovered in finally making the decision to purchase  ;-)

on MsFt's, it's a matter of re-sizing each window then keeping
each running. ;-)



From: Cley Faye <cleyf...@gmail.com>
Date: Thu, Apr 20, 2017 at 9:49 AM
Subject: Re: [libreoffice-users] Showing two sheets of the same spreadsheet
To:
Cc: "users@global.libreoffice.org" <users@global.libreoffice.org>


2017-04-17 21:51 GMT+02:00 lismurn <jhkm...@gmail.com>:

> 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.
>

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.​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Showing two sheets of the same spreadsheet

[Brian Barker]

At 12:51 17/04/2017 -0700, Lismurn Noname wrote:
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 [...] Sheets.


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


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Showing two sheets of the same spreadsheet

[Cley Faye]

2017-04-17 21:51 GMT+02:00 lismurn :

> 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.
>

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.​

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted