Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

Hi :)
It sounds like a proper database would be better.  Then reports can show the information in 
different ways, in different orders, without affecting the under-laying data.  

The front-end could be Writer and could be restricted to just certain fields (columns).  Once 
set-up it could well turn out to be a shed load easier for the user but setting it up will require 
quite a steep learning curve.  

These tutorials are surprisingly clear English
http://spoken-tutorial.org/list_videos
I had expected a heavy accent but actually it's very comfortable to listen to.  English and 
American are sometimes very snooty about this sort of thing but it's well worth trying out.  

There is a handbook now that can also help
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook

The main thing is to work towards  having the data tables in an external back-end, such as 
Postgresql or MariaDb/MySql but i don't think you have to do that to start with.  I think you can 
export them later on.  Then next time you want to build a database it'll be easier to start with 
the external one.  At least that's my plan for what i'm hoping to do.  


Errr, i would hesitate to say this, if i was in your position, but if green is used for all the 
most recent recent cells how is the spreadsheet going to know when "recent" has eventually become 
old?  An extra column to type the date into could be used to show when the latest change was made 
to that row.  or maybe an extra "date" column beside each piece of data?  I think i would go with 1 
extra column for date and another for "comments" and the comments one to be used to say which bit 
if data got changed?  

Regards from 
Tom :)







> ________________________________
> From: Tanstaafl <tanstaafl@libertytrek.org>
> To: users@global.libreoffice.org 
> Sent: Friday, 19 July 2013, 11:44
> Subject: Re: [libreoffice-users] Calc - allow users to format cells on protected sheets
>
>
> On 2013-07-18 8:17 PM, Errol Goetsch <errol@xe4.org> wrote:
> > PS In this example, the trigger value is transparent when the cell is
> > unlocked (the user can see the conditional formatting formula), but you
> > can make the trigger refer offsheet to a value the user can't see.
> > Hope this helps
>
> Thanks for trying, but no, it doesn't.
>
> Libreoffice has exactly two options under 'Allow all users of this sheet to:
>
> [ ] Select protected cells
> [ ] Select unprotected cells
>
> Excel has a whopping 15:
>
> [ ] Select locked cells
> [ ] Select unlocked cells
> [ ] Format cells
> [ ] Format columns
> [ ] Format rows
> [ ] Insert columns
> [ ] Insert rows
> [ ] Insert hyperlinks
> [ ] Delete columns
> [ ] Delete rows
> [ ] Sort
> [ ] Use Autofilter
> [ ] Use PivotTable reports
> [ ] Edit objects
> [ ] Edit scenarios
>
> We have always maintained all of our internal documents and templates in 
> ODF format (since we started using Openoffice at version 1.0), and I'm 
> trying to avoid changing the format of this file to .xls and start using 
> Excel to edit it, because doing so will open the door to converting 
> *all* of our internal documents and templates to excel/word format.
>
> This particular spreadsheet is a Master spreadsheet where we put all of 
> our Sales numbers, and the boss wants the person assigned to update the 
> sheet to start changing the BG color of the most recent changes.
>
> The problem is, the MAIN sheet that everyone looks at, references 
> numbers that are entered on their Managers 'Team' sheet, and must be 
> locked to prevent accidental deletion of the content.
>
> Crap.
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@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+unsubscribe@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