Re: [libreoffice-users] Version: 6.2.0.3 - Calc: strange delay in execution of data>sort function

[Luuk]

On 7-3-2019 04:16, Tom Cloyd wrote:

I recently updated to this version, and immediately noted that upon
invocation of the main menu data>sort function to sort a group of rows
there is about a 2 second delay before anything happens. The number of rows
being sorted seems unrelated to the delay. I've never seen this behavior
before, ever. Normally, LO's Calc is quick and snappy on my system, so this
execution delay is a jolt, and after a while just plain annoying.

Has anyone else noticed this? Has anyone a clue as to what's happening?

Tom

SYSTEM:
OS: GNU/Linux, kernal 4.15.0-42-generic x86_64 GNU/Linux, LinuxMint 19
(tara) (Ubuntu bionic)

Acer Swift 3 laptop - model SF314-54 (x86_64)
Processor: 3.4 GHz Intel Core i5 (4 processors)
RAM: 8 GB DDR4
Hard Drive: Flash Memory Solid State - Micron_1100_MTFD size: 256.1GB
Graphics: Card: Intel UHD Graphics 620



I do not see this under Windows 10 (LO Version 6.2.0.3)

And also not under Linux (openSUSE Leap 15)(LO Version 6.2.1.2)

so, i do not have a clue ;)


--
To unsubscribe e-mail to: users+unsubscr...@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

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

[Luuk]

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


In EXCEL you can do this:

A   B   C
1   2   3
=A2+3   =B2+3   =C2+3

(I used CTRL+T to show formulas, you should see the values 4,5,6)

When you select A1:C3, and choose 'Insert'/'Table'

After this, typing the value 7 in cell 'A4', en pressing 'Enter' results 
in the fields B4 and C4 being updated with the same formula as in row 3.


How can this be achieved in LibreOffice Calc ?






--
To unsubscribe e-mail to: users+unsubscr...@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