Fill Series

classic Classic list List threaded Threaded
8 messages Options
Eric Beversluis Eric Beversluis
Reply | Threaded
Open this post in threaded view
|

Fill Series

The Calc instructions for filling a series say "Choose sheet - Fill
Cells - Series." (https://help.libreoffice.org/Calc/Fill_Series)

Where is "Sheet"? I don't see it on any of the menu drop-downs. What am
I missing?

LO Version: 4.4.7.2
--
Eric Beversluis
www.ericbeversluis.com <http://www.ericbeversluis.com>

--
To unsubscribe e-mail to: [hidden email]
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
Dave Liesse Dave Liesse
Reply | Threaded
Open this post in threaded view
|

Re: Fill Series

I don't have the older version anymore, but it might still be under Edit
... Fill.  (Took me forever to find the new location in v5.whatever-I-have).

Dave



On 1/12/2017 13:34, toki wrote:

>
> On 01/12/2017 09:09 PM, Eric Beversluis wrote:
>> Where is "Sheet"? I don't see it on any of the menu drop-downs.
> Top menu sequence:
> File, Edit, View, Insert, _Sheet_, Data, Tools, Window, Help.
>
> IOW, "Fill Cells" is the drop down menu item to look for.
>
> jonathon
>
>


--
To unsubscribe e-mail to: [hidden email]
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
Eric Beversluis Eric Beversluis
Reply | Threaded
Open this post in threaded view
|

Re: Fill Series

In reply to this post by Eric Beversluis
"Sheet" is not in my top menu. Is there some way I can add it?


On 01/12/2017 04:34 PM, toki wrote:

>
> On 01/12/2017 09:09 PM, Eric Beversluis wrote:
>> Where is "Sheet"? I don't see it on any of the menu drop-downs.
> Top menu sequence:
> File, Edit, View, Insert, _Sheet_, Data, Tools, Window, Help.
>
> IOW, "Fill Cells" is the drop down menu item to look for.
>
> jonathon
>
>

--
Eric Beversluis
www.ericbeversluis.com <http://www.ericbeversluis.com>

--
To unsubscribe e-mail to: [hidden email]
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
V Stuart Foote V Stuart Foote
Reply | Threaded
Open this post in threaded view
|

Re: Fill Series

Eric Beversluis wrote
"Sheet" is not in my top menu. Is there some way I can add it?
Sure, from Tools -> Customize and add a New menu named "Sheets". Then add the commands you'd like it to have. Believe what you are looking for is in the Edit -> Fill menu at that release.

Note that for the 4.4 release builds, the Calc Sheet menu item had not been assembled from entries on other top level menus.   So must either customize, or upgrade to a 5.2.5 build or the 5.3.0 build to have the revised menu layout UI--if on Windows avoid the 5.2.4 build.
Tanstaafl Tanstaafl
Reply | Threaded
Open this post in threaded view
|

Re: Fill Series

In reply to this post by Eric Beversluis
On 1/12/2017, 4:09:49 PM, Eric Beversluis
<[hidden email]> wrote:
> The Calc instructions for filling a series say "Choose sheet - Fill
> Cells - Series." (https://help.libreoffice.org/Calc/Fill_Series)
>
> Where is "Sheet"? I don't see it on any of the menu drop-downs. What am
> I missing?
>
> LO Version: 4.4.7.2

Sheet is one of the menus, but I think it was introduced in the 5 series...

The easy way is to simply select the cell with the formula the way you
want it, then mouse over the dot in the lower right corner of the cell
when the cursor changes to cross-hairs, then click-hold, and drag down
to the last cell you want to fill.

--
To unsubscribe e-mail to: [hidden email]
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
libreoffice-ml.mbourne libreoffice-ml.mbourne
Reply | Threaded
Open this post in threaded view
|

Re: Fill Series

In reply to this post by V Stuart Foote
V Stuart Foote wrote:
> ...if on Windows avoid the 5.2.4 build.

Why do you advise avoiding 5.2.4 on Windows?

I'm just curious, as I upgraded to that version a few weeks ago and
haven't noticed any problems so far, but perhaps I just haven't hit them
yet. The release notes mention possible crashes with OpenGL rendering,
but that also applies to several previous versions.

--
Thanks,
Mark.


--
To unsubscribe e-mail to: [hidden email]
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
V Stuart Foote V Stuart Foote
Reply | Threaded
Open this post in threaded view
|

Re: Fill Series

Two major issues with the 5.2.4.2 build on Windows:

Crash when exiting Writer after copying to clipboard
https://bugs.documentfoundation.org/show_bug.cgi?id=104830

[Windows] Failure to populate system font list
https://bugs.documentfoundation.org/show_bug.cgi?id=105015

Steps to reproduce in the BZ reports (and duplicates).

Tens of thousands of crash reports for these two issues, so yes best to avoid the build and move now to the 5.2.5.1, or 5.3.0.2 both in pre-release.

http://dev-builds.libreoffice.org/pre-releases/win/
libreoffice-ml.mbourne libreoffice-ml.mbourne
Reply | Threaded
Open this post in threaded view
|

Re: Fill Series

V Stuart Foote wrote:
> Two major issues with the 5.2.4.2 build on Windows:
>
> Crash when exiting Writer after copying to clipboard
> https://bugs.documentfoundation.org/show_bug.cgi?id=104830

I recall seeing that report recently (perhaps when I was searching for
issues which might have lead to your advice), but couldn't reproduce it.
Just tried again, and it only seems to occur if configured not to load
the Quickstarter. With the Quickstarter running, there is no crash,
possibly because LibreOffice doesn't actually exit.

> [Windows] Failure to populate system font list
> https://bugs.documentfoundation.org/show_bug.cgi?id=105015

I hadn't experienced that one either, but can reproduce after adding the
specific printer mentioned in Comment 33. It seems I happen to have a
printer which doesn't trigger that crash.

> Steps to reproduce in the BZ reports (and duplicates).
>
> Tens of thousands of crash reports for these two issues, so yes best
> to avoid the build and move now to the 5.2.5.1, or 5.3.0.2 both in
>pre-release.

Thanks for the links. I was sure you had your reasons; more surprised
not to have encountered problems when you were so definitely against
that particular version. I guess I've just been lucky that my particular
configuration has avoided these so far ;o)

> http://dev-builds.libreoffice.org/pre-releases/win/

I'll certainly take a look at installing that.

--
Mark.


--
To unsubscribe e-mail to: [hidden email]
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