Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.