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: [email protected]
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