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

Hi.
Is the layout of each sheet the same.
You can format the first sheet, and then using paste special you can  
copy only the format(s) from a range of cells in the first sheet to your  
subsequent sheets.
Steve

On 01/05/17 14:46, Thomas Blasejewicz wrote:
> Good morning
> I am using LibreOffice 5.2.2.2 on Windows 10 / 7 / Linux Mint
> I do have a file with about 20 sheets, containing patient data - using  
> both English and Japanese.
> 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.
> Meaning:
> Japanese font = xxx / size = xxx
> English font = xxx / size = xxx
> I think I managed to set that up in my cell style "clinic".
> However, numbers I can set ONLY to "Date", in which case "50" suddenly  
> turns into some incomprehensible figure,
> 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).
>
> 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?
> Or do I have to format every single column in every single sheet by hand?
>
> Thank you for your help.
> Thomas


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