rework a template - from horizontal to vertical - how to

For discussions about programming, programming questions/advice, and projects that don't really have anything to do with Puppy.
Post Reply
Message
Author
sayhello_to_the_world
Posts: 77
Joined: Mon 24 Dec 2012, 15:19

rework a template - from horizontal to vertical - how to

#1 Post by sayhello_to_the_world »

i have to rework a template - from horizontal to vertical - with calc or writer


see the attached template - it belongs to a calendar.


well - i guess that with calc we have more options. we can choose and configure the height and width



love to hear from you
Attachments
__a_template__Screenshot_.png
(70.24 KiB) Downloaded 134 times
__a_template__Screenshot_.png
see an example
(70.24 KiB) Downloaded 107 times

april

#2 Post by april »

Probably make it easier if you uploaded the ".doc" file or other.
These png's are both the same are'nt they?

User avatar
mikeslr
Posts: 3890
Joined: Mon 16 Jun 2008, 21:20
Location: 500 seconds from Sol

#3 Post by mikeslr »

Hi sayhello_to_the_world,

April is on the right track. In between the application and the graphical display is some "doc" which provides the arguments in a language used by the application to create the display. The doc may be written in plain text, html or some other language.

Not to discourage you from your project, but unless you have a need to change "Horizontal" to "Vertical" frequently, your expenditure of time on this project will be far greater than "starting from scratch". Also take into consideration that whatever you do under one application probably can't be used OOTB in another application. The ease with which you can create a template using the GUI belies the complexity of the underlying application. For instance, both "Rows" and "Columns" are visual illusions.

The display on a monitor consists of pixels. Each pixel has at least two dimensions represented as (x,y) where x determines a pixel's location on the horizontal axis of the display, and y determines a pixels location on the vertical axis. The top-left-most pixel would be represented as (0,0). The operative devices in a spreadsheet are its Cells; in a database are its Records. Cells and Records are created to hold and display certain types of information, and may be limited to the types of information they can hold. Rows and Columns are visual illusions. They appear because every Cell/Record in a particular Row has the same quantity as the 'y' argument of where it begins; and every Cell/Record in a particular Column has the same quantity as its 'x' argument of where it begins.

In the "end-game" you can't just run a substitution (find and replace) changing all x's to y's and all y's to x's because that actually involves two steps. The first step would replace all x's with y's after which you would not be able to distinguish which y had always been a y and which previously had been an x in order to perform the 2nd step. So you'd have to first create a 'dummy' dimension "z", change all x's to z, all y's to x, then all z's to y.

But even that may not suffice. If the Cells/Records length and height aren't equal, (a square), you'd also have to change the argument determining length and height. And if all Cells/Records were not defined to hold (and display) the same type of data, the arguments determining the type of data might also have to be changed.

Or maybe not. Perhaps substitution of x for y and defining length and height will suffice. It may all depend on how the "doc" was written.

mikesLr

sayhello_to_the_world
Posts: 77
Joined: Mon 24 Dec 2012, 15:19

#4 Post by sayhello_to_the_world »

hello dear experts


i try to do some flip of the text in the cells
Attachments
from_landscape_to_portrait.zip
(115.57 KiB) Downloaded 70 times

User avatar
MochiMoppel
Posts: 2084
Joined: Wed 26 Jan 2011, 09:06
Location: Japan

#5 Post by MochiMoppel »

sayhello_to_the_world wrote:i try to do some flip of the text in the cells
I'm not sure what you mean. Something like in attached screenshot?
Attachments
horizontal2vertical.jpg
(96.53 KiB) Downloaded 64 times

Post Reply