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


Hi :)
I would definitely use more columns for this.  Possibly in groups of 3 perhaps with an extra column 
as an empty gap to make it easier to read.  Perhaps change "Page layout" to 'landscape' instead of 
'portrait' in case i needed to print it out.  


So, something like

Column A = time, for it's heading i would use the date or the day-of-the-week  

Column B = value, for it's heading i would say something like "Imported data"   (perhaps turned 
sideways or something?)Column C = calculated code (instead of colour), for it's heading i would say 
"code"  
Column D = calculated value,  for it's heading i would say something like "Result"
Column E = blank but narrowed to half width or less.  It's often handy to have an extra column 
"just in case" but it's main purpose is to split the groups of columns up


Column F = time, for it's heading i would use the date or the day-of-the-week  

Column G = value, for it's heading i would say something like "Imported data"  (perhaps turned 
sideways or something?)
Column H = calculated code (instead of colour), for it's heading i would say "code"  
Column I = calculated value,  for it's heading i would say something like "Result"
Column J = blank but narrowed to half width or less.  It's often handy to have an extra column 
"just in case" but it's main purpose is to split the groups of columns up



The currently uploaded file's layout looks a bit random so it might help to make it more formal 
even though that takes a bit of the magic out of it, as does losing the colours and replacing with 
"Code".  

Regards from
Tom :)  






________________________________
From: Krunoslav Šebetić <kruno0407@gmail.com>

<snip />


Hi.
From the example on Nabble I can see what you are doing but not how it relates to your example 
above. There are 3 columns and not 5, is this 3 times a day. There is no date or time, is it to 
be assumed that all data in column A is at the same time and each line is a new day.

Steve

Well that ods file is just example, as I mentioned before. I do not have document created. This is 
just a preparation and because of that file from nabble is a scheme. Thats the reasen Im using 
this mailing list. Just wonna know is posible add values/numbers based on cell background color.

We can say that Column A is one day and column B is another. We can say thats needed the rows 
represents time of the day (morning, noon, evening). So, first I need to fill column A and rows 
respective to the column, and another day rows resprective to column B.

This weather thing is the closest to what Im doing, and i really doubt I could explain it on the 
real project. Is it possible do edit xml file or something and do it with some find/repleca - if 
in xml file founded line "background color:red"  "devide by 2.7" and put that number betwen string 
x and string y?

Thanks for your time!


-- 
For unsubscribe instructions e-mail to: users+help@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.