Re: [libreoffice-users] Help needed with Excel spreadsheet

On 3/6/19 5:42 PM, Tom Davies wrote:
> Hi :)
> Sounds like a perfect time to suggest they install LO too.
>
> If an Excel person hadn't immediately found what they were looking for in
> Calc they would have immediately claimed that Calc couldn't do the task.
>
> There are loads of articles about LO that have such posts in the comments
> section.  It can be fun to refute them in as few words as possible.
> Regards from a Tom :)


You know, I'm about ready to do that.   After doing some experimentation
with Excel today, I found it just doesn't want to "play nice" with what
I'm trying to do.  I want to have an image as the spreadsheet header and
have the basic formulas update when I add/remove rows.  I'm sure with
enough time, I could get Excel to behave but I've been able to get what
I needed working far more easily with Calc.

I haven't given up, just yet, but I'm really surprised at how stubborn
Excel is, when it comes to the things I'm trying to do with it.  :(

Peace...

"The Other" Tom

> On Wed, 6 Mar 2019 18:21 Luuk <luuk34@gmail.com wrote:
>
> > On 6-3-2019 17:48, Tom Williams wrote:
> > > On 3/6/19 8:26 AM, Tom Williams wrote:
> > > > I know it's odd to ask for Excel help in this mailing list but I need
> > > > help locating a LibreOffice Calc function/feature in Excel.  :)
> > > >
> > > > I'm helping a friend create a billing invoice and since I'm a Linux
> > > > user, I'm using Calc to build the template.  So far, it's working well
> > > > and given I'm not an Excel user, I find myself struggling some in
> > > > getting Excel to "behave".  Anyway, I recently discovered the "/Expand
> > > > reference when new rows are inserted/" in Calc.  It does exactly what I
> > > > needed.   When I add/remove a row in/from the spreadsheet, my total
> > > > "SUM()" formula is updated automagically.
> > > >
> > > > Does the equivalent feature exist in Excel?  What I've found is, when
> > > > adding rows *after* the last row in my SUM() formula, the new row is
> > > > excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
> > > > Once I add row 28, I need the SUM() formula to be updated to
> > > > "=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
> > > > formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
> > > > reference when new rows are inserted/" feature does this work for me.
> > > >
> > > > I did some web searching and found this article:
> > https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html
> > > > but I hope to find an easier and more flexible way to accomplish what I
> > > > need.  Or is that approach what I really should use?
> > > >
> > > > Thanks in advance!
> > > >
> > > > Peace...
> > > >
> > > > "The Other" Tom
> > > Nevermind!  I found this:
> > >
> > > https://bettersolutions.com/excel/formulas/automatic-expansion.htm
> > >
> > > That should do what I need!
> > >
> > > Thanks anyway!  :)
> > >
> > > Peace...
> > >
> > > "The Other" Tom
> > When i was reading above, i thought you were search for subtotals.
> >
> > Excel has also a function named SUBTOTAL()
> >
> >
> > https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939
> >
> >
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy