Re: [libreoffice-users] style per sheet for different types of numbers

On 04/30/2017 09:14 PM, Brian Barker wrote:
> At 11:46 01/05/2017 +0900, Thomas Blasejewicz wrote:
> > Naturally there are ordinary numbers like age (50 etc.), but there 
> > are also dates like first visit etc. I would like to apply the same 
> > style to every sheet.
> > However, numbers I can set ONLY to "Date", ...
>
> No: if you want numbers to be numbers and to display as numbers, you 
> would set the cell format to Number. There is surely no rationale is 
> setting the format of such cells to Date?
>
> > ... in which case "50" suddenly turns into some incomprehensible 
> > figure, ...
>
> I don't understand this. You would fail to see 50 only if you had 
> chosen some unsuitable cell format.
>
> > ... or to "Numbers", in which case then the date is converted into a 
> > number that does not make any sense to me (although by now I know, 
> > there is a rationale behind that number).
>
> For cells containing dates, you would want the cells to be formatted 
> as Date (or conceivably Text).
>
> > Is there a way to set up a cell style (page styles do not have any 
> > settings for numbers, fonts etc.) that can handle BOTH standard 
> > numbers and dates?
>
> Yes: that is the default situation. If you enter a number it will be 
> saved as and be displayed as a number. If you enter something that 
> LibreOffice recognises as a date, it will be saved as and displayed as 
> a date - with the cell format being automatically changed to Date.
>
> > Or do I have to format every single column in every single sheet by 
> > hand?
>
> Yes and no. Generally, you will *want* to do this. Being able to set 
> different cell formats for different types of data is a useful feature 
> of spreadsheet programs - not something to be avoided or worked 
> around. Using cells styles can be a good idea, but you cannot expect a 
> single cell format to serve all purposes. If it could, there would be 
> no point in different cell formats existing.
>
> Here's a idea. What you appear to need to do is to duplicate the cell 
> formats that you have arranged in one sheet in other sheets. How about 
> this?
>
> o With the original sheet displayed, go to Edit | Sheet > | 
> Move/Copy... (or right-click the sheet tab and select Move/Copy Sheet...)
>
> o Select Copy and choose where to place your new sheet.
>
> o On the new sheet, delete the data to leave a sheet with identical 
> cell formatting. You can do this in various ways. You may wish to 
> retain column headings and other data. You may wish to retain 
> formulae: do this using Edit | Delete Content... (or press Delete) 
> rather than Backspace and then choose in the Delete Contents panel 
> exactly what you want done.
>
> I trust this helps.
>
> Brian Barker
Greetings,
What I do in these cases, is to create a new tab (sheet) at the end (far 
right tab) and rename it "Boiler" for boilerplate.  I then copy a 
formatted sheet into the "Boiler" sheet and delete the data. Then, when 
I need a new sheet, I insert the new sheet and copy the "boiler" sheet 
format into the new sheet.  This saves deleting the data each time a new 
sheet is added.
Note that in my experience, the Print Ranges settings do not copy over 
and need to be changed for each new sheet.
HTH.
Girvin Herr



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