[users] Re: Calc: remove ' character before number/mury

2011-03-29 Thread Brewster Gillett
On Tue, 2011-03-29 at 06:19 -0700, tinu_mury wrote: > I don't know if you solved it yet, but there is an easy way to eliminate that > ' character from the spreadsheet. > Insert a new column next to the one you want to work with and use the > "=value()" command. > For example: in column A cell 1 you

[users] Re: Calc: remove ' character before number

2011-03-29 Thread tinu_mury
I don't know if you solved it yet, but there is an easy way to eliminate that ' character from the spreadsheet. Insert a new column next to the one you want to work with and use the "=value()" command. For example: in column A cell 1 you have '2346, in column cell 1 enter: =value(A1) This will copy

Re: [users] Re: Calc: remove ' character before number

2010-01-05 Thread jonathon
On Tue, Jan 5, 2010 at 06:16, Tim Deaton wrote: > I hope that there'll be someplace we can download it after you release it. It will be distributed from http://www.e-sword-users.org > release it.  (And when is BibleTech 2010?) 26-27 March 2010 in San Jose, CA. Conference information is at http

Re: [users] Re: Calc: remove ' character before number

2010-01-05 Thread jonathon
On Mon, Jan 4, 2010 at 17:52, Andreas Saeger wrote: > jonathon wrote: > >> OOo 1.x included a dBase 3 compatible database engine.  Whenever the >> issue of "does OOo include a database?" came up, the answer was >> invariably  "no". >> > Wrong. You could connect, define queries, use form controls a

Re: [users] Re: Calc: remove ' character before number

2010-01-04 Thread Tim Deaton
jonathon wrote: On Sun, Jan 3, 2010 at 20:02, Dotan Cohen wrote: I'm writing documentation on creating and editing SQLite databases from within OOo, for users that have a vague idea of what a I'd like to see that, if you would. Off-list or on is fine. Thanks. I'll be rel

Re: [users] Re: Calc: remove ' character before number

2010-01-04 Thread jonathon
On Mon, Jan 4, 2010 at 19:15, Drew Jensen wrote: > Will you be giving a presentation at the conference and releasing the paper > as part of that? I'll be giving a presentation at that conference, but that specific documentation is, for all practical purposes, independent. (My aim is to release r

Re: [users] Re: Calc: remove ' character before number

2010-01-04 Thread Drew Jensen
I'll be releasing that at BibleTech 2010. That's excellent to hear Johnathon. Will you be giving a presentation at the conference and releasing the paper as part of that? Best wishes, drew - To unsubscribe, e-mail: user

[users] Re: Calc: remove ' character before number

2010-01-04 Thread Andreas Saeger
jonathon wrote: OOo 1.x included a dBase 3 compatible database engine. Whenever the issue of "does OOo include a database?" came up, the answer was invariably "no". Wrong. You could connect, define queries, use form controls and reports. http://homepage.ntlworld.com/garryknight/linux/oodba

Re: [users] Re: Calc: remove ' character before number

2010-01-04 Thread jonathon
On Sun, Jan 3, 2010 at 20:02, Dotan Cohen wrote: >> I'm writing documentation on creating and editing SQLite databases >> from within OOo, for users that have a vague idea of what a > I'd like to see that, if you would. Off-list or on is fine. Thanks. I'll be releasing that at BibleTech 2010.

Re: [users] Re: Calc: remove ' character before number

2010-01-03 Thread Dotan Cohen
> I'm writing documentation on creating and editing SQLite databases > from within OOo, for users that have a vague idea of what a > spreadsheet is, and literally no idea what a database is.  Whilst that > might sound good, the problem is that their only exposure to > spreadsheets, has been its abu

Re: [users] Re: Calc: remove ' character before number

2010-01-03 Thread jonathon
On Sun, Jan 3, 2010 at 18:01, Andreas Saeger wrote: >> That they want is a _simple_ way to enter data, and then retrieve it, when >> needed. > But this is exactly where the typical user fails while using a spreadsheet. > - People do not get the idea that 90% of all spreadsheet functionality is

Re: [users] Re: Calc: remove ' character before number

2010-01-03 Thread Dotan Cohen
2010/1/3 Andreas Saeger : > jonathon wrote: >> >> On Fri, Jan 1, 2010 at 15:30, Andreas Saeger  wrote: >> >>> I have never seen any reasonable argument why spreadsheets should be used >>> like this  (except for mere laziness). >> >> The typical user neither knows, nor cares what the difference betw

[users] Re: Calc: remove ' character before number

2010-01-03 Thread Andreas Saeger
jonathon wrote: On Fri, Jan 1, 2010 at 15:30, Andreas Saeger wrote: I have never seen any reasonable argument why spreadsheets should be used like this (except for mere laziness). The typical user neither knows, nor cares what the difference between a database and a spreadsheet program is.

Re: [users] Re: Calc: remove ' character before number

2010-01-03 Thread jonathon
On Fri, Jan 1, 2010 at 15:30, Andreas Saeger wrote: > I have never seen any reasonable argument why spreadsheets should be used > like this (except for mere laziness). The typical user neither knows, nor cares what the difference between a database and a spreadsheet program is. That they want

Re: [users] Re: Calc: remove ' character before number

2010-01-02 Thread Dotan Cohen
2010/1/1 Andreas Saeger : > Dotan Cohen wrote: >> >> any of the issues belong to different projects, most of which I am >> not the only member of. Although I have no fear of databases, it seems >> that Excel has many database-like features > > The database-like features *assume* database-like struc

[users] Re: Calc: remove ' character before number

2010-01-01 Thread Andreas Saeger
Dotan Cohen wrote: any of the issues belong to different projects, most of which I am not the only member of. Although I have no fear of databases, it seems that Excel has many database-like features The database-like features *assume* database-like structures without enforcing them by any me

Re: [users] Re: Calc: remove ' character before number

2010-01-01 Thread Dotan Cohen
> Your date time is a text column actually and all the problems you describe > on this list indicate that you are in desparate need of a database with > distinct field types and input forms with specialized form controls for the > field types. > Many of the issues belong to different projects, mos

[users] Re: Calc: remove ' character before number

2009-12-19 Thread Andreas Saeger
Dotan Cohen wrote: I have a spreadsheet with 1375 rows. One of the colums is a time column, with the format 'hh:mm:ss. Note the leading ' sign. In order to sum this column, I need to remove this character. However, the search and replace dialogue s not recognize this character. How can I remove t