Vertical Formatting Date Fields

Post your questions, bug reports and suggestions here for PlanMaker 2016 for Windows.

Moderator: SoftMaker Team

Post Reply
harv91
Posts: 12
Joined: Tue Oct 17, 2017 3:25 pm

Vertical Formatting Date Fields

Post by harv91 » Tue Oct 17, 2017 3:37 pm

Have just migrated from MS Office to Softmaker Office and have a formatting issue in Planmaker.

A date field which in Excel is formatted vertically, with a cell width of 1 character does not appear correctly in Planmaker.
In Excel, the date is displayed with one character above the other in a vertical line i.e.
1
7
-
O
c
t
-
1
7
In Planmaker, the cell width needs to be as wide as the date when formatted horizontally (9 characters), then the date is displayed vertically as in Excel, otherwise all I get is #'s, i.e. I cannot have a 1 character wide cell to save space, it needs to be 9 characters wide.

Is this a bug, intentional, or am I missing something?

harv91
Posts: 12
Joined: Tue Oct 17, 2017 3:25 pm

Re: Vertical Formatting Date Fields

Post by harv91 » Wed Oct 25, 2017 5:09 pm

No replies on this question, does that mean there is not an answer?
Thanks for any replies
Laurence

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7367
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Vertical Formatting Date Fields

Post by sven-l » Thu Nov 23, 2017 11:52 am

Please attach a sample file or send one to forum(at)softmaker.com referring to this thread. Thank you!
Sven Leßmann
SoftMaker Software GmbH

harv91
Posts: 12
Joined: Tue Oct 17, 2017 3:25 pm

Re: Vertical Formatting Date Fields

Post by harv91 » Thu Nov 23, 2017 3:56 pm

Example file attached, Cell A1 holds date formatted as a 6 character string. Cell A1 is approx 2 characters wide and correctly displays the date in a vertical format when opened in Excel. In Planmaker column width needs to be increased to 6 characters to display the date (vertically), otherwise just shows ###
Attachments
Example.xls
(13.5 KiB) Downloaded 8 times
Thanks for any replies
Laurence

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7367
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Vertical Formatting Date Fields

Post by sven-l » Tue Dec 05, 2017 9:29 am

## means that the cell width is too small to show the character. Right mouse click on the column header, then select "Autofit width" or make the column a bit wider manually. Then you will see your characters.
Sven Leßmann
SoftMaker Software GmbH

harv91
Posts: 12
Joined: Tue Oct 17, 2017 3:25 pm

Re: Vertical Formatting Date Fields

Post by harv91 » Tue Dec 05, 2017 1:15 pm

I realise that ## means cell is too narrow.

The problem is that the cell should only need to be 1 character wide because the text is vertically formatted & is 1 character wide.

Planmaker requires the cell to be as wide as the number of characters in the date (which is 6) then a the vertically formatted date is displayed but it is 1 character wide in a 6 character wide cell. I want to display it in a 1 character wide cell to save space.

Please look at the example file I sent.
Thanks for any replies
Laurence

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7367
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Vertical Formatting Date Fields

Post by sven-l » Fri Dec 08, 2017 4:29 pm

I will refer this issue to the developers. Thank you!
Sven Leßmann
SoftMaker Software GmbH

Robin Holt
Posts: 56
Joined: Mon Apr 01, 2013 1:38 am
Location: Illinois, USA

Re: Vertical Formatting Date Fields

Post by Robin Holt » Fri Dec 08, 2017 6:54 pm

Try this and see if it works for you. I tried it on your example and it seemed to work fine.

Create a new cell style with the format as date/time. In the cell format dialogue there is an "Alignment" tab that allows you to specify rotation. Select 90 or 270 degrees and then apply the style to the cell. Will that work?

harv91
Posts: 12
Joined: Tue Oct 17, 2017 3:25 pm

Re: Vertical Formatting Date Fields

Post by harv91 » Fri Dec 08, 2017 7:37 pm

Hi Robin
Thanks for this reply.

I had found this workaround and have used it while I waited for a reply from Softmaker. It provides a solution although I would rather have the characters one above the other rather than rotated.

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7367
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Vertical Formatting Date Fields

Post by sven-l » Tue Jan 16, 2018 8:33 am

sven-l wrote:
Fri Dec 08, 2017 4:29 pm
I will refer this issue to the developers. Thank you!
The problem has been solved and will not occur anymore with the next service pack for Office 2018. Unfortunately there will be no fix anymore for Office 2016.
Sven Leßmann
SoftMaker Software GmbH

harv91
Posts: 12
Joined: Tue Oct 17, 2017 3:25 pm

Re: Vertical Formatting Date Fields

Post by harv91 » Tue Jan 16, 2018 12:53 pm

Oh, not much use to me then :(

Post Reply

Return to “PlanMaker 2016 for Windows”