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
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
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
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.
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.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: 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