Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Niklas Johansson]

Hi

Den 2015-09-06 kl. 17:26, skrev Tanstaafl:

...
I wonder - would it be possible to create a more generic (and I'm sure
more complicated) extension that allows you to create new sub-menu
content entries like this?

Or, maybe, just one that allows you to add one of the main menus (ie, in
this case, 'Table') to the context menu?

Anyway, just thinking how to make it more useful to others...
Well, the short answer is that sure it is possible, but it is quite an 
undertaking to do it.
It would require time that I simply don't have at the moment. However 
I'll probably
look into doing it, or at least a simplified version of it from time to 
time. ;)
One of the harder part would be to create a simple and intuitive dialog 
for the

feature.

Might be good to note that it is definitely easier to add context menu 
entries if

I only now what to add and where.

/Niklas



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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

On 9/8/2015 4:04 PM, V Stuart Foote  wrote:
> "Unprotect cells" has been added after "Protect Cells" on the Table menu for
> the 5.0.2 rc1 build.
> 
> The Writer Table context menu for "Cells"  has been trimmed of bloat as
> indicated.
> 
> Niklas' Python UNO extension inserts a *Cell Protection* section with
> *Protect* (.uno:Protect) and *Unprotect* (.uno:UnsetCellsReadOnly)  entries
> on the Writer Table Cell context menu, and I've uploaded a copy to the 
> tdf#93837    --"
> Allow customization of the Context Menus" enhancement request for any that
> care to restore it to the context menu.

One mans 'bloat' is another mans gravy.

Please remember your classifying those context menu selections as
'bloat' is pure and mere opinion, nothing more.

I repeat...

This should NEVER have happened without first providing users a way to
customize these menus.

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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

Hi Niklas,

Just fyi, the extensions works great!

One thing... I do use the Quickstarter, and I tried the extension right
after installing it - without restarting  the Quickstarter - and
Libreoffice went into some kind of strange loop right after I
right-clicked on a cell in a new table inserted into a new/unsaved
writer doc.

I had to kill Libreoffice (kill all of the soffice.bin process), and
after that, it is now working great.

Thanks very much!!

On 9/6/2015 11:26 AM, Tanstaafl  wrote:
> Awesome, thanks Niklas!
> 
> I probably won't be able to try it until Tuesday, but will do so as soon
> as I can and let you know how it goes.
> 
> Thanks again!
> 
> On that note...
> 
> I wonder - would it be possible to create a more generic (and I'm sure
> more complicated) extension that allows you to create new sub-menu
> content entries like this?
> 
> Or, maybe, just one that allows you to add one of the main menus (ie, in
> this case, 'Table') to the context menu?
> 
> Anyway, just thinking how to make it more useful to others...
> 
> Thanks again!
> 
> On 9/5/2015 7:44 PM, Niklas Johansson  wrote:
>> Hi
>>
>> I created an extension that adds a submenu, Cell Protection, to the context
>> menu of tables. Feel free to give feedback, and I will try to publish the
>> extension to the LibreOffice Extension Center.
>>
>> Note that at the moment the extension is in English only.
>>
>> For the time being, you can download the extension from:
>> https://www.dropbox.com/s/3e3ok1kxyrshay8/CellProtectContextMenu.oxt?dl=1
>>
>> /Niklas
>>
>> 2015-09-01 15:35 GMT+02:00 Tanstaafl :
>>
>>> On 8/30/2015 1:19 PM, Tanstaafl  wrote:
 I'll go and create a new enhancement request to allow customizing the
 context menus.
>>>
>>> Done: bug 93837
>>>
>>> https://bugs.documentfoundation.org/show_bug.cgi?id=93837
> 
> 


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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

Oh...

Any chance you can add the extension to the bug as a potential
workaround for others?

Or, I'd be happy to do it if you're ok with it.

Thanks again!

On 9/8/2015 1:21 PM, Tanstaafl  wrote:
> Hi Niklas,
> 
> Just fyi, the extensions works great!
> 
> One thing... I do use the Quickstarter, and I tried the extension right
> after installing it - without restarting  the Quickstarter - and
> Libreoffice went into some kind of strange loop right after I
> right-clicked on a cell in a new table inserted into a new/unsaved
> writer doc.
> 
> I had to kill Libreoffice (kill all of the soffice.bin process), and
> after that, it is now working great.
> 
> Thanks very much!!
> 
> On 9/6/2015 11:26 AM, Tanstaafl  wrote:
>> Awesome, thanks Niklas!
>>
>> I probably won't be able to try it until Tuesday, but will do so as soon
>> as I can and let you know how it goes.
>>
>> Thanks again!
>>
>> On that note...
>>
>> I wonder - would it be possible to create a more generic (and I'm sure
>> more complicated) extension that allows you to create new sub-menu
>> content entries like this?
>>
>> Or, maybe, just one that allows you to add one of the main menus (ie, in
>> this case, 'Table') to the context menu?
>>
>> Anyway, just thinking how to make it more useful to others...
>>
>> Thanks again!
>>
>> On 9/5/2015 7:44 PM, Niklas Johansson  wrote:
>>> Hi
>>>
>>> I created an extension that adds a submenu, Cell Protection, to the context
>>> menu of tables. Feel free to give feedback, and I will try to publish the
>>> extension to the LibreOffice Extension Center.
>>>
>>> Note that at the moment the extension is in English only.
>>>
>>> For the time being, you can download the extension from:
>>> https://www.dropbox.com/s/3e3ok1kxyrshay8/CellProtectContextMenu.oxt?dl=1
>>>
>>> /Niklas
>>>
>>> 2015-09-01 15:35 GMT+02:00 Tanstaafl :
>>>
 On 8/30/2015 1:19 PM, Tanstaafl  wrote:
> I'll go and create a new enhancement request to allow customizing the
> context menus.

 Done: bug 93837

 https://bugs.documentfoundation.org/show_bug.cgi?id=93837
>>
>>
> 


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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

Awesome, thanks Niklas!

I probably won't be able to try it until Tuesday, but will do so as soon
as I can and let you know how it goes.

Thanks again!

On that note...

I wonder - would it be possible to create a more generic (and I'm sure
more complicated) extension that allows you to create new sub-menu
content entries like this?

Or, maybe, just one that allows you to add one of the main menus (ie, in
this case, 'Table') to the context menu?

Anyway, just thinking how to make it more useful to others...

Thanks again!

On 9/5/2015 7:44 PM, Niklas Johansson  wrote:
> Hi
> 
> I created an extension that adds a submenu, Cell Protection, to the context
> menu of tables. Feel free to give feedback, and I will try to publish the
> extension to the LibreOffice Extension Center.
> 
> Note that at the moment the extension is in English only.
> 
> For the time being, you can download the extension from:
> https://www.dropbox.com/s/3e3ok1kxyrshay8/CellProtectContextMenu.oxt?dl=1
> 
> /Niklas
> 
> 2015-09-01 15:35 GMT+02:00 Tanstaafl :
> 
>> On 8/30/2015 1:19 PM, Tanstaafl  wrote:
>>> I'll go and create a new enhancement request to allow customizing the
>>> context menus.
>>
>> Done: bug 93837
>>
>> https://bugs.documentfoundation.org/show_bug.cgi?id=93837


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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Niklas Johansson]

Hi

I created an extension that adds a submenu, Cell Protection, to the context
menu of tables. Feel free to give feedback, and I will try to publish the
extension to the LibreOffice Extension Center.

Note that at the moment the extension is in English only.

For the time being, you can download the extension from:
https://www.dropbox.com/s/3e3ok1kxyrshay8/CellProtectContextMenu.oxt?dl=1

/Niklas

2015-09-01 15:35 GMT+02:00 Tanstaafl :

> On 8/30/2015 1:19 PM, Tanstaafl  wrote:
> > I'll go and create a new enhancement request to allow customizing the
> > context menus.
>
> Done: bug 93837
>
> https://bugs.documentfoundation.org/show_bug.cgi?id=93837
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> 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
>
>

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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

On 8/30/2015 1:19 PM, Tanstaafl  wrote:
> I'll go and create a new enhancement request to allow customizing the
> context menus.

Done: bug 93837

https://bugs.documentfoundation.org/show_bug.cgi?id=93837


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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Joe Conner]

I totally agree with Tanstaafl. What USERS want for all menu's should 
always be the primary driver of design. A long established design should 
not be changed cavalierly wither user comment input.


+1

Joe Conner, Poulsbo, WA USA



On 08/30/2015 10:19 AM, Tanstaafl wrote:

I completely and totally disagree that a 'Cell' related context menu -
when right-clicking on a cell in a table - would 'complicate' the
context menu in any way. In fact, I think it makes it improves the UI
for new users.

I understand the idea of simplifying things for new users, but I totally
disagree that that should be some kind of massively major focus,
especially to the point of making things more difficult for your
existing user base.

But whatever, I'll go and create a new enhancement request to allow
customizing the context menus.

Maybe there has been ample time to play with the alpha and beta
releases, but you do realize that suggesting that we should be able to
find every little thing like this just from playing with them is - well,
a bit ridiculous.

Fyi: major changes like this should be ANNOUNCED - and specific requests
to look for changes in certain areas and please test and comment would
go a long way to helping us help you.

On 8/28/2015 8:26 PM, V Stuart Foote vstuart.fo...@utsa.edu wrote:

Tanstaafl wrote

But, we shouldn't have to do this, so the bug will stay open to just add
the relevant menu entries - and to bring these two back to the context
menu.

Sorry, but the context menu rework and changes to the Table toolbar and menu
were committed in April 2015, and have been that way on all builds of
master, the entire 5.0.0 beta run, and for all  5.0.0 release candidates
since then.

The change to the Table menu to add the missing Unprotect Cells as in
tdf#93713 https://bugs.documentfoundation.org/show_bug.cgi?id=93713   will
correct that oversight, but there has been ample time to preview and comment
on the many GUI and design issues that come with the 5.0 release.  I'd
invite folks to stay more involved with development and QA going forward.

From a Design UX-advise perspective the HIG work dictates that we simplify
the user interface for the benefit of our beginner users--the context menus
were put on a diet accordingly :D

=-ref-=
https://gerrit.libreoffice.org/#/c/15535/





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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

I completely and totally disagree that a 'Cell' related context menu -
when right-clicking on a cell in a table - would 'complicate' the
context menu in any way. In fact, I think it makes it improves the UI
for new users.

I understand the idea of simplifying things for new users, but I totally
disagree that that should be some kind of massively major focus,
especially to the point of making things more difficult for your
existing user base.

But whatever, I'll go and create a new enhancement request to allow
customizing the context menus.

Maybe there has been ample time to play with the alpha and beta
releases, but you do realize that suggesting that we should be able to
find every little thing like this just from playing with them is - well,
a bit ridiculous.

Fyi: major changes like this should be ANNOUNCED - and specific requests
to look for changes in certain areas and please test and comment would
go a long way to helping us help you.

On 8/28/2015 8:26 PM, V Stuart Foote vstuart.fo...@utsa.edu wrote:
 Tanstaafl wrote
 But, we shouldn't have to do this, so the bug will stay open to just add
 the relevant menu entries - and to bring these two back to the context
 menu.
 
 Sorry, but the context menu rework and changes to the Table toolbar and menu
 were committed in April 2015, and have been that way on all builds of
 master, the entire 5.0.0 beta run, and for all  5.0.0 release candidates
 since then. 
 
 The change to the Table menu to add the missing Unprotect Cells as in 
 tdf#93713 https://bugs.documentfoundation.org/show_bug.cgi?id=93713   will
 correct that oversight, but there has been ample time to preview and comment
 on the many GUI and design issues that come with the 5.0 release.  I'd
 invite folks to stay more involved with development and QA going forward.
 
From a Design UX-advise perspective the HIG work dictates that we simplify
 the user interface for the benefit of our beginner users--the context menus
 were put on a diet accordingly :D
 
 =-ref-=
 https://gerrit.libreoffice.org/#/c/15535/ 


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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

On 8/28/2015 1:44 AM, Denis Navas denis.na...@gmail.com wrote:
 I copied a table from calc to write.

This bug isn't about embedded spreadsheets, it is about WRITER TABLES.
They are two totally different things.

To reproduce:

1. Open new blank Writer document.
2. Click on the Table menu, click on 'Insert Table'.
3. Click inside a cell.
4. Click the 'Table' menu, click on 'Protect Cells'

Now try to unprotect the cell you just protected. There is no way to do it.

Protecting/Unprotecting the entire Table using the Navigator does NOT
unprotect the cell that you protected.

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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

On 8/28/2015 8:01 AM, Dave Barton d...@tasit.net wrote:
 There are a few ways to make the Unprotect Cells option visible:
 
   o Customize the Table menu by adding the Unprotect Cells entry.
 
   o With the Tables toolbar visible, right click on the toolbar and
 select Unprotect Cells from the context menu.
 
   o Customize the Tables toolbar by adding the Unprotect Cells
 button.

Thanks Dave, I did figure this out from a couple of comments in the bugs
I opened, and at least I can work around this for the users I've already
upgraded.

But, we shouldn't have to do this, so the bug will stay open to just add
the relevant menu entries - and to bring these two back to the context menu.

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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5 (Correction)

[Dave Barton]

 Original Message  
From: Dave Barton
Date: Fri, 28 Aug 2015 14:01:37 +0200

   o Customize the Tables toolbar by adding the Unprotect Cells
 button.

Sorry this should have read:

  o Right click on the Tables toolbar  select Unprotect Cells
from the Visible Buttons list.

Dave



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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Dave Barton]

 Original Message  
From: Tanstaafl
Date: Fri, 28 Aug 2015 07:17:31 -0400

 On 8/28/2015 1:44 AM, Denis Navas denis.na...@gmail.com wrote:
 I copied a table from calc to write.
 
 This bug isn't about embedded spreadsheets, it is about WRITER TABLES.
 They are two totally different things.
 
 To reproduce:
 
 1. Open new blank Writer document.
 2. Click on the Table menu, click on 'Insert Table'.
 3. Click inside a cell.
 4. Click the 'Table' menu, click on 'Protect Cells'
 
 Now try to unprotect the cell you just protected. There is no way to do it.
 
 Protecting/Unprotecting the entire Table using the Navigator does NOT
 unprotect the cell that you protected.

There are a few ways to make the Unprotect Cells option visible:

  o Customize the Table menu by adding the Unprotect Cells entry.

  o With the Tables toolbar visible, right click on the toolbar and
select Unprotect Cells from the context menu.

  o Customize the Tables toolbar by adding the Unprotect Cells
button.

HTH

Dave



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

Re: [libreoffice-users] Re: Unable to Protect/Unprotect cells in Libreoffice 5

[Tanstaafl]

On 8/28/2015 11:39 AM, Denis Navas denis.na...@gmail.com wrote:
 I copy the table from calc and asted as rtf on writer, as I reported.

I know...

 What's important I believe, is that I am working on Windows.

No, what is important is, if your intention is to attempt to reproduce a
bug, that you ... attempt to reproduce the bug AS DESCRIBED.

Saying that you turned on your windshield wipers, and they work, in
order to try to reproduce a bug that involves the passenger automatic
window is just plain silly.

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