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

[Tom Williams]

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

-- 
/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+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

[Tom Williams]

On 3/6/19 10:18 AM, Luuk 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
>
>
>
>
>
Thanks for the info!  Sorry I wasn't more clear.  :(   I just needed the
SUM formulas to update as I added/deleted rows.  :)

Peace...

"The Other" Tom

-- 
/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+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

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

[Tom Cloyd]

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
~
"There is a great difference between worry and concern. A worried person
sees
a problem, and the concerned person solves a problem." ~ Harold Stephens
~
Tom Cloyd, MS MA LMHC (WA) | t...@tomcloyd.com
Psychotherapist (psychological trauma, dissociative disorders)
Spokane, Washington, U.S.A: (435) 272-3332
Google+  |
Facebook 
~

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

[Tom Davies]

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 :)


On Wed, 6 Mar 2019 18:21 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
> >
> 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+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
>

-- 
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] Prompt to save when no changes made with LO 6.1.4

[libreoffice-ml . mbourne]

MR ZenWiz wrote:

On Fri, Mar 1, 2019 at 2:14 PM  wrote:


MR ZenWiz wrote:

There's a really annoying new "feature" in LO 6.1.4.2 - whenever I open a
file and print it with no changes, it prompts me to save the file after
opening.

Why would that be?


I think some information about printer settings is (or at least can be)
stored in the file.


Like I said, it's really annoying.


If you don't want printing to treat the document as modified when there
are no other changes, go to Tools > Options > LibreOffice > General and
de-select the 'Printing sets "document modified" status' option.


That has been de-selected since I first started using LO - still is.


Hmm... you're right. Just got around to actually trying it on my 
LibreOffice 6.1.5.2 on Linux Mint (installed from the LibreOffice PPA). 
Opened an ODT (Writer) document, printed, and the document is marked as 
modified (green star or orange dot on the save icon depending on theme) 
as soon as the "print" dialog opens. It's still marked as modified even 
if the print dialog is immediately cancelled.


I'm pretty sure that option worked at one time, and hadn't noticed that 
it doesn't now. I don't do a lot of printing, but guess when I do I must 
either save immediately after printing anyway or print from a read-only 
version (in which case the document doesn't get marked as modified).


This still happens starting with a new document, and also with a fresh 
LibreOffice profile.


After some searching of bugs, this looks like bug 123378 
. Despite 
the title implying that this is a regression in 6.2, from comments it 
looks like this affects 6.1.5 too (and from your description, seemingly 
also 6.1.4) but should be fixed in 6.1.6.


--
Mark.


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


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+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 files bad link

[Paul D. Mirowsky]

Sorry about that.

Windows 7 Professional Service Pack 1 (64 Bit)

There are files in:

    C:\Program Files\LibreOffice" which are the default for 64 bit 
programs.


    and

    C:\Program Files\LibreOffice\help\en-US


In 

    LibreOffice 6.1.5.2

    LibreOffice 6.1 Help Pack (English (United States))



On 3/6/2019 8:51 AM, Tanstaafl wrote:

That didn't answer the question...

Do you have the 32bit or 64bit version of the application and/or Help
installed?

Look in the Programs and Features control panel to see what versions are
installed.

On Tue Mar 05 2019 10:50:22 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:

Sort of.

      C:\Program Files (x86)\LibreOffice 4

      C:\Program Files (x86)\LibreOffice 5

          Are both empty.

C:\Program Files\LibreOffice\help

          Is not and "C:\Program
Files\LibreOffice\help\en-US\text\swriter" has HTML files.

When  on "main.html" results on Firefox URL
"file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html"
and displays correctly in browser.

Paul




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

[Tom Williams]

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

[libreoffice-users] Help needed with Excel spreadsheet

[Tom Williams]

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


-- 
/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+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 files bad link

[Tanstaafl]

That didn't answer the question...

Do you have the 32bit or 64bit version of the application and/or Help
installed?

Look in the Programs and Features control panel to see what versions are
installed.

On Tue Mar 05 2019 10:50:22 GMT-0500 (Eastern Standard Time), Paul D.
Mirowsky  wrote:
> Sort of.
> 
>      C:\Program Files (x86)\LibreOffice 4
> 
>      C:\Program Files (x86)\LibreOffice 5
> 
>          Are both empty.
> 
> C:\Program Files\LibreOffice\help
> 
>          Is not and "C:\Program 
> Files\LibreOffice\help\en-US\text\swriter" has HTML files.
> 
> When  on "main.html" results on Firefox URL 
> "file:///C:/Program%20Files/LibreOffice/help/en-US/text/swriter/main.html"
>  
> and displays correctly in browser.
> 
> Paul


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