[libreoffice-users] LO 5 keeps crashing

2015-09-02 Thread axioma06
After upgrading from Build ID: 4.4.5.2 Arch Linux build-2 to LO5 the program keeps crashing when trying to use certain functions such as text color selection or inserting pictures or clip-art. But with many other activities too. I removed previous profiles and removed any data left after

[libreoffice-users] Error message when inserting rows

2015-09-02 Thread Russ Butler
Hello, I am trying to use the "insert rows above" function to insert around 70 rows at a time. I keep getting the following error: "Filled cells cannot be shifted beyond the sheet." Closing the sheet and program and re-opening does not resolve the issue. Spreadsheet is not very big and

Re: [libreoffice-users] Error message when inserting rows

2015-09-02 Thread Cley Faye
Would that insertion push your sheet to more than 1M rows? -- Cley Faye http://cleyfaye.net 2015-09-02 13:39 GMT+02:00 Russ Butler : > Hello, > > I am trying to use the "insert rows above" function to insert around 70 > rows at a time. > > I keep getting the

Re: [libreoffice-users] Spreadsheet Formula Query

2015-09-02 Thread Gordon Burgess-Parker
On 02/09/15 11:59, John Montgomery wrote: Hi Folks I have attached a file called "Spreadsheet Query". This list doesn't accept attachments. You need to upload it to a file-sharing site and post the link -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: Spreadsheet Formula Query

2015-09-02 Thread V Stuart Foote
@Gordon, @John, * Actually, our Nabble ML hosting allows attachments in thread. I've grabbed John's "Spreadsheet Query" from Google drive, scanned it for malware--its clean, and have uploaded it here. Spreadsheet_Query.ods

[libreoffice-users] Spreadsheet Formula Query

2015-09-02 Thread John Montgomery
Hi Folks I have attached a file called "Spreadsheet Query". It is part of a much larger file but the contents will suffice for my question. What should the formula for "K2" be? The formula for L2 is (=COUNTIF($G$2:$G$750,J2)". You will see that Column "L" counts the number of individuals assigned

[libreoffice-users] Re: Error message when inserting rows

2015-09-02 Thread Andreas Säger
Am 02.09.2015 um 13:39 schrieb Russ Butler: > Hello, > > I am trying to use the "insert rows above" function to insert around 70 > rows at a time. > > I keep getting the following error: "Filled cells cannot be shifted > beyond the sheet." Closing the sheet and program and re-opening does > not

[libreoffice-users] Spreadsheet Query.ods

2015-09-02 Thread John Montgomery (via Google Drive)
I've shared an item with you: Spreadsheet Query.ods https://drive.google.com/file/d/0B6Toem0dJhqCWVFOMV9WeUQ5Y0k/view?usp=sharing=COuu9s8M It's not an attachment -- it's stored online. To open this item, just click the link above. -- To unsubscribe e-mail to: