Ask Your Question
0

question Can LibO display a calc cell using a wrapped date&time?

asked 2017-09-19 22:16:12 +0200

DanAdmin gravatar image

updated 2017-09-20 08:20:47 +0200

I have recently been using OpenOffice and do not understand the full range of date/time formatting options available.

Is it possible to take a value such as "2017-09-18 15:45" to display the two pieces of the value stacked inside a Calc cell?

I've tried a few things to no avail.

Note: Open Office will display the date as a wrapped value and I have made extensive use of that capability for some time. However, OO is causing heartache due to its antiquated method of managing pending changes.

--

Thanks

DanAdmin

edit retag flag offensive close merge delete

Comments

Just a friendly hint:

using -- just below a paragraph makes that paragraph a header with huge bold font, which creates an impression of shouting. Please use an extra newline before the -- (as actually is required by mail standards btw).

Thank you for coming here and trying to make LO better!

Mike Kaganski gravatar imageMike Kaganski ( 2017-09-20 08:20:31 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2017-09-19 22:52:06 +0200

m.a.riosv gravatar image

Seems it works aligned as 'Justified' or 'Distributed'

edit flag offensive delete link more

Comments

I did not want to resize the column containing the date&time value because I had too much screen width already reserved for the data entry fields I needed. Most rows are taller than a single line of text which allows me to see the relevant fields without scrolling sideways if I can wrap the date&time value within a cell. I could separate the date from the time, but that causes other problems as the two need to be attached in some way as they represent a single time during a year.

DanAdmin

DanAdmin gravatar imageDanAdmin ( 2017-09-20 22:02:27 +0200 )edit
0

answered 2017-09-20 08:13:44 +0200

librebel gravatar image

Hello @DanAdmin,

And welcome to LibreOffice!

the "Justified" button is just after the "Left", "Centered", and "Right" -alignment buttons ( see screenshot ). image description Custom NumberFormat and Wrap are not necessary for this, just resize your cell width/height so that the 2 lines are visible.

For commenting on an answer, please use the "Comment" button instead of creating another Answer.

edit flag offensive delete link more
0

answered 2017-09-20 03:04:46 +0200

DanAdmin gravatar image

updated 2017-09-20 08:21:32 +0200

Sorry, I do not know what 'Justified' means.

I am guessing that 'Distributed' is the characters spread out over the width of a cell. I hope this means that I can break the date & time to show as a date in the upper part of a Calc cell and the time in the lower part of the same cell.

If I am did not understand your meaning correctly, please clarify.

I need to understand how I construct a format mask for the value and what attributes to attach to the format mask in the cell.

Thanks for a quick reply.

--

DanAdmin

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-19 22:16:12 +0200

Seen: 57 times

Last updated: Sep 20 '17