<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div style="font-family: Arial; font-size: 13px;">
<p style="margin: 0px; font-size: 13px; font-family: Arial;">I
suggest you to take a look at the "Window > New Window" menu.
It opens a new window for the current document, you can switch
to different sheets in each of the window. You can resize each
of the window and look at the contents side by side. It would be
much easier if you have multiple screen monitors attached to
your computer.<br>
</p>
<p style="margin: 0px; font-size: 13px; font-family: Arial;"><br>
</p>
<p style="margin: 0px; font-size: 13px; font-family: Arial;"> <br>
</p>
</div>
<div style="font-family: Tahoma, sans-serif; font-size: 13px;
padding-top: 5px; border-top: 1px solid #b5c4df;"><strong>From: </strong>Matthew
Parker [<a class="moz-txt-link-freetext" href="mailto:matthewparker1@gmail.com">mailto:matthewparker1@gmail.com</a>]<br>
<strong>Sent: </strong>Friday, September 23, 2022 08:16 AM +08<br>
<strong>To: </strong><a class="moz-txt-link-abbreviated" href="mailto:libreoffice@lists.freedesktop.org">libreoffice@lists.freedesktop.org</a><br>
<strong>Subject: </strong>Easy to do, great feature. Suggestion.</div>
<br>
<div type="cite"
cite="mid:CAEvAQL6=rBrL0zv=cTOu4kkc70hBkotraD1vLzQVhubJdPoK2w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr"><span
style="color:rgb(34,35,31);font-family:"Source Sans
Pro",Helvetica,sans-serif;font-size:14.4px">Hi. My name
is Matt. I use Calc a lot. I have a great idea. First, I
usually modify my spreadsheets to improve them. They are
complex. But I have a few versions of one type, e.g.
"Schematic" which is a schematic of my solar generator
installations which has tables that calculate power yields and
wot not. One version is for large jobs, one for small jobs,
one for single phase, one for 3 phase. It just saves me time
to pull up the version most applicable to customise for a
particular solar system. So when I modify one I modify the
other versions too. Now, while I was copying blocks of cells
and pasting them into other versions I also had to correct
cross referenced cells to some of the formulas in other pages
of the spreadsheet. So there I was clicking a cell, then the =
and then I had to click the other sheet and click on the
required cell. This back and forth from one sheet to another
was awkward whereas copying from a separate spreadsheet
altogether was easy as they were both on screen at the same
time. So if more than one sheet of the same spreadsheet could
be viewed side by side at the same time, it will make cross
referencing cells between sheets a whole lot faster. And if
desired, if more than one sheet is open at a time then perhaps
the copy and paste will acknowledge the cells in the other
sheet(s) and not try to ref the cells in the origin
spreadsheet.<br>
</span><br>
<a href="https://youtu.be/gr8LRaaJWX8" moz-do-not-send="true"
class="moz-txt-link-freetext">https://youtu.be/gr8LRaaJWX8</a><br>
</div>
</div>
</body>
</html>