Re: [libreoffice-users] Re: Calc trumps Excel
Ahhh, now i see the problem at last. Please ignore my other posts in this thread. (Thanks Luuk) Regards from Tom :) From: Luuk To: users@libreoffice.org Sent: Sat, 26 February, 2011 10:41:09 Subject: Re: [libreoffice-users] Re: Calc trumps Excel On 26-02-11 11:35, plino wrote: > Indeed there is a lot of work... I just found another bug: typing =now() in > a cell shows the value instead of a date (of course you can format it > yourself...) But if you make the column wider, it changes the '40600,48653' to '26-02-11 11:40'. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc trumps Excel
Hi :) If you type any number that is too long for a cell then it usually just fills the cell with marks. Words will generally overlap other cells unless those cells and then the writing gets truncated but you see the first few letters. I can't test the "now()" function until Thursday unless i get a call-out before then. I tend to think that most programs are not "good" or "bad". Generally there are certain circumstances that fit some programs better than others. MS products are heavy and only recently been ported to systems other than reasonably new desktop machines running Windows. LibreOffice runs on at least 4 operating systems (counting all linux distros as 1 and all BSDs as another 1) and a much wider variety of machines of various ages, sizes and types. Regards from Tom :) From: plino To: users@libreoffice.org Sent: Sat, 26 February, 2011 21:51:29 Subject: [libreoffice-users] Re: Calc trumps Excel Hi Tom I'm sorry to say but you are wrong on this one. LibO and OOo don't auto-resize but Excel does. Just type =now() on any cell and watch one of the reasons why Excel is the number one spreadsheet bar none ;) Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2584477.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
Hi Tom I'm sorry to say but you are wrong on this one. LibO and OOo don't auto-resize but Excel does. Just type =now() on any cell and watch one of the reasons why Excel is the number one spreadsheet bar none ;) Cheers, Pedro -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2584477.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc trumps Excel
On 26-02-11 18:21, Tom Davies wrote: > Replies are at the bottom of threads ... > > > That doesn't make any sense, does it? The format of the values depends on the > width of the cell??? > > There are only two logical options: 1) the cell width is automatically > adjusted to show the whole data (as Excel does) or 2) the data is correctly > formatted (in this case in the DATE TIME format) and only part is shown > (depending on the width of the column). The user must manually adjust the > column width. > > > > Hi :) > > I think there is some mis-understanding of the original problem or something. > > Neither Excel nor Calc automatically adjust column-width unless you > deliberately > take action. There are a lot of actions that can change widths but for the > result described the easiest would be to double-click on the | dividing > columns > up above the data. > Regards from > Tom :) > > No, the problem is that the layout changes when the column-width is changed. It changes from 'number' to 'date' And, of course, we know that one can double-click to change the width, but that was not the discussion -- Luuk -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc trumps Excel
Replies are at the bottom of threads ... From: plino To: users@libreoffice.org Sent: Sat, 26 February, 2011 11:01:56 Subject: [libreoffice-users] Re: Calc trumps Excel That doesn't make any sense, does it? The format of the values depends on the width of the cell??? There are only two logical options: 1) the cell width is automatically adjusted to show the whole data (as Excel does) or 2) the data is correctly formatted (in this case in the DATE TIME format) and only part is shown (depending on the width of the column). The user must manually adjust the column width. Hi :) I think there is some mis-understanding of the original problem or something. Neither Excel nor Calc automatically adjust column-width unless you deliberately take action. There are a lot of actions that can change widths but for the result described the easiest would be to double-click on the | dividing columns up above the data. Regards from Tom :) -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc trumps Excel
On 26-02-11 12:01, plino wrote: > That doesn't make any sense, does it? The format of the values depends on the > width of the cell??? > > There are only two logical options: 1) the cell width is automatically > adjusted to show the whole data (as Excel does) or 2) the data is correctly > formatted (in this case in the DATE TIME format) and only part is shown > (depending on the width of the column). The user must manually adjust the > column width. > I hyjacked a bug which was, in my opinion, related https://bugs.freedesktop.org/show_bug.cgi?id=33689 and tried to explain this behaviour... ;) - Luuk -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
That doesn't make any sense, does it? The format of the values depends on the width of the cell??? There are only two logical options: 1) the cell width is automatically adjusted to show the whole data (as Excel does) or 2) the data is correctly formatted (in this case in the DATE TIME format) and only part is shown (depending on the width of the column). The user must manually adjust the column width. -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2581281.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc trumps Excel
On 26-02-11 11:35, plino wrote: > Indeed there is a lot of work... I just found another bug: typing =now() in > a cell shows the value instead of a date (of course you can format it > yourself...) But if you make the column wider, it changes the '40600,48653' to '26-02-11 11:40'. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
T.R. Valentine When you open a tab delimited file in Excel it automatically recognizes the data types. Therefore your string e.g. 2011-02-26 10:23:47 is correctly interpreted as a value. Therefore it is natural that using FIND, VALUE, LEFT or any other functions would not work. As I said in the previous post you need to use other functions. LibO and OOo don't have any problem with tab delimited files. The only difference is that you can not Open a tab delimited file (otherwise it is loaded in Writer). You need to Insert, Sheet from File. Luuk Indeed there is a lot of work... I just found another bug: typing =now() in a cell shows the value instead of a date (of course you can format it yourself...) -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2581181.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc trumps Excel
On 25-02-11 16:16, T. R. Valentine wrote:
> I used FIND to locate the space between the date and the time. I used LEFT
> to extract the characters prior to the space and when that did not produce
> a numerical value, I tried both VALUE and TIMEVALUE to convert it to a
> numerical value. Neither worked.
This seems to be correct, however
1) A2 '=NOW()'
2) B2 '=FIND(" ";A2;1)'
This gives problems, because the second parameter in FIND needs to be text.
The correct way to find the " " would be:
'=FIND(" ";TEXT(A2;"DD-MM- UU:MM:SS";1);1)'
The "DD-MM- UU:MM:SS" is because my locale setting is Dutch
Hmz, what happens if i save this, change locate, and re-open this
doc.
Yes, Mr Valentine, you are right, there is a lot of work to be
done... :'(
I Think this should be filed as a bug, wonder how OO does do this.
--
Luuk
--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Calc trumps Excel
On 25 February 2011 02:54, Luuk wrote: > On 25-02-11 05:41, T. R. Valentine wrote: >> Excel could NOT >> do it. > Or, you do not know how to do it? > (i've never worked with Excel2007, but did 'some' things in Excel2003) I would never claim a possible lack of knowledge! But, in this case, I am fairly certain it wasn't me. I used FIND to locate the space between the date and the time. I used LEFT to extract the characters prior to the space and when that did not produce a numerical value, I tried both VALUE and TIMEVALUE to convert it to a numerical value. Neither worked. Knowing where the space between the date and the time was and determing the LEN of the entire text string, I used MID to extract the characters following the space. When that did not produce a numerical value, I tried both VALUE and TIMEVALUE to convert it to a numerical value. Neither worked. On 25 February 2011 05:37, plino wrote: > > VALUE and TIMEVALUE apply to TEXT strings ONLY both in Excel and LibO > > If you want to parse a value field you have to use different functions See above., > How did you import the Tab delimited file to LibO? I did not. I had already done a lot of work with the information in Excel which I did not want to redo. I saved my work (in .xls instead of .xlsx) and opened that in Calc. Does Calc have issues with opening tab-delimited files? -- T. R. Valentine Your friends will argue with you. Your enemies don't care. 'When I get a little money I buy books; and if any is left I buy food and clothes.' -- Erasmus -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Re: Calc trumps Excel
VALUE and TIMEVALUE apply to TEXT strings ONLY both in Excel and LibO If you want to parse a value field you have to use different functions How did you import the Tab delimited file to LibO? -- View this message in context: http://nabble.documentfoundation.org/Calc-trumps-Excel-tp2573005p2574555.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
