On Sun, 17 Nov 2013 19:57:10 -0700
Oogie McGuire wrote:
>
> On Nov 17, 2013, at 4:41 PM, Paul wrote:
>
> >> Or if I know they are text (but there is ABSOLUTELY NO WAY TO SEE
> >> THAT IN LO)
> > How would you see it in Excel? I recall the display in Excel being
> > the same as in LO. The only
ve always heard.
Thanks and regards from
Tom :)
On 18 November 2013 17:37, Oogie McGuire wrote:
> Forgot to include the list on my answer
>
> Begin forwarded message:
>
>> From: Oogie McGuire
>> Subject: Re: [libreoffice-users] CALC convert text to numbers
>> Date:
Hi :)
Where do you post to? I've never known anyone else say that MS Office
changed direction on anything in order to accommodate a user's
suggestion so this is a bit of a first. Usually users are just told
they can't be having the problem or get told to upgrade.
MS don't claim to listen to indi
Forgot to include the list on my answer
Begin forwarded message:
> From: Oogie McGuire
> Subject: Re: [libreoffice-users] CALC convert text to numbers
> Date: November 18, 2013 10:23:07 AM MST
> To: Tom Davies
>
> It's been over 13 years ago, At that time I b
Yes and no,
Yes everything changes from version to version in Microsoft Office. As I
mentioned in another message the version I have is from 2000.
No in that you can submit feedback and changes to MS Office, and in fact from
rev 1 (I was an Office User from the very beginning) to the last vers
My Excel was from 2000. It worked there, I have never upgraded it past that
version.
On Nov 18, 2013, at 1:13 AM, Stefan Weigel
wrote:
> I just tried in Excel 2013 and it´s simply not true. ;-)
>
> Changing the number format of a cell does not convert a text value
> into a number value.
Euge
Hi :)
MS Office 2013 is different from 2010 is different from 2007 is
radically different from 2003. Formats change and sometimes cause
problems. The layout of the ribbon-bar changes. The macro language
changes quite a lot. What might have happened in one version
sometimes vanishes from the nex
No it does NOT appear on the input line on my machine. I can't attach a screen
shot to this message but I can send one to you if that would help.
On Nov 17, 2013, at 8:19 PM, Brian Barker wrote:
> 'Cause it's not there! (It appears only in the Input Line.)
Eugenie (Oogie) McGuire
Desert Wey
Hi,
>> What I am used to doing in Excel is copy everything in, then
>> format the cells to be numbers and they are converted to
>> numbers and my formula work.
> Really? I'm surprised. I didn't know Excel did this conversion
> just on formatting.
I just tried in Excel 2013 and it´s simply not t
At 13:54 17/11/2013 -0700, Oogie McGuire wrote:
Or if I know they are text (but there is ABSOLUTELY NO WAY TO SEE
THAT IN LO) ...
Er, this is easy, in fact (and shouting doesn't change
that!). Providing that you have not imposed any alignment or
justification choice on your cells, text will
On Sun, 17 Nov 2013 13:54:59 -0700
Oogie McGuire wrote:
> What I am used to doing in Excel is copy everything in, then format
> the cells to be numbers and they are converted to numbers and my
> formula work.
Really? I'm surprised. I didn't know Excel did this conversion just on
formatting. In LO
Hi.
I have sort of been following this in the background. Is this a recent
issue in LO. I frequently open csv files with numbers and copy and paste
into other sheets and the numbers work in formulae.
Steve
On 2013-11-18 09:54, Oogie McGuire wrote:
I'm with Charles on this one. I was the OP o
I'm with Charles on this one. I was the OP on the problem.
Nearly all of my issues are because I have my LO spreadsheet and then a CSV
file. If I open the CSV file in LO it looks fine. I can't just import it into
my existing spreadsheet because the data in it need to go into small subsets of
m
On Mon, 11 Nov 2013 16:26:28 -0700
Oogie McGuire wrote:
> Try it, or I can send you a spreadsheet that fails to change the
> fonts and you can sew what I mean.
I just tried it on a simple spreadsheet. Running LO 4.1.1.2 on Windows
7. I put some random text and numbers into a new spreadsheet, and
At 05:51 11/11/2013 -0500, William Drago wrote:
I just tried this extension. It's easy to use and seems to work very
well. Is there a way to move its icon to a different place on the tool bar?
Yes.
o Click the down-arrow at the right end of the relevant toolbar and
select Customize Toolbar...
ber 11, 2013 09:17
To: Joel Madero
Cc: Brian Barker; users@global.libreoffice.org
Subject: Re: [libreoffice-users] CALC convert text to numbers
For me dealing with an extension, installing it, making sure it doesn't
conflict with something else was more effort than creating a column, using
V
Try it, or I can send you a spreadsheet that fails to change the fonts and you
can sew what I mean.
On Nov 11, 2013, at 1:25 PM, Paul wrote:
> This doesn't work for you? I'm surprised. I haven't checked, but I'm
> fairly sure it works as expected for me.
Eugenie (Oogie) McGuire
Desert Weyr htt
On Mon, 11 Nov 2013 10:12:55 -0700
Oogie McGuire wrote:
> What I would consider a bug is that changing the format of a cell
> doesn't change the data.
And it shouldn't, it changes only the *format* of the data, not the
data itself.
I often get confused by this, expecting that when I change the f
Not in my version I just verified it. Had to go install Excel again to see but
it works as I expect
Macintosh Snow Leopard running MS Excel X for mac.
On Nov 11, 2013, at 10:34 AM, Stefan Weigel wrote:
> That´s not true. I just tried in Excel. The leading ' stays, no
> matter what format you w
Could this possibly be a 'feature' associated with a certain version of
office\excel?
Steve Gruspier
Electrical Engineering
On 11/11/2013 12:34 PM, Stefan Weigel wrote:
Hi,
Am 11.11.2013 18:17, schrieb Oogie McGuire:
What's a problem is that in Excel even though it also uses the
leading ' t
Hi,
Am 11.11.2013 18:17, schrieb Oogie McGuire:
> What's a problem is that in Excel even though it also uses the
> leading ' to format text as numbers, if you change the format of
> a cell the conversions happen without any problems.
That´s not true. I just tried in Excel. The leading ' stays,
For me dealing with an extension, installing it, making sure it doesn't
conflict with something else was more effort than creating a column, using
Value() and then pasting special.
What's a problem is that in Excel even though it also uses the leading ' to
format text as numbers, if you change
What I would consider a bug is that changing the format of a cell doesn't
change the data.
If I set a cell to be number then even if the text was defined as a text field
using the ' sign I expect that to be stripped out and the field displayed and
function properly as a number.
Just like i c
I ended up using this option for this time, create a column using the VALUE
function, then copy and paste special numbers only.
For future I will look at other options. This is something that will be done a
lot for the next year or so.
I am in the process of converting my sheep records from a L
I just tried this extension. It's easy to use and seems to
work very well.
Is there a way to move its icon to a different place on the
tool bar?
Thanks,
-Bill
On 11/10/2013 5:08 PM, Joel Madero wrote:
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates
Le 11/11/2013 07:44, Brian Barker a écrit :
> At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote:
>> Call the menu Data / Numbers as text (freely translated from my FR
>> install) ...
>
> In English, that's Data | Text to Columns... .
>
thanks!
--
Jean-Francois Nifenecker, Bordeaux
--
At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote:
Call the menu Data / Numbers as text (freely translated from my FR
install) ...
In English, that's Data | Text to Columns... .
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.li
ooops! forgot to specify the first step:
1. select the column to set as numbers first.
Le 11/11/2013 07:03, Jean-Francois Nifenecker a écrit :
>
2. do that:
> Call the menu Data / Numbers as text (freely translated from my FR
> install) then just click OK in the window that opens without chang
Le 10/11/2013 22:57, Oogie McGuire a écrit :
> I have a spreadsheet that is the output of a SQLite Database on
> Android. It contains numbers that have been formatted as text. When I
> copy the columns into my LibreOffice Spreadsheet I want to make sure
> that they are interpreted as numbers.
This
On 11/10/2013 07:10 PM, Ady wrote:
Why is everyone straying away from the fact that there is a simple
extension developed by Cor (one of our brilliant devs) which
accomplishes all of this? Just curious if there's a benefit to doing
these formula techniques instead of just pushing a button on a ni
> Why is everyone straying away from the fact that there is a simple
> extension developed by Cor (one of our brilliant devs) which
> accomplishes all of this? Just curious if there's a benefit to doing
> these formula techniques instead of just pushing a button on a nice gui
I could ask you t
On 11/10/2013 07:05 PM, Brian Barker wrote:
At 18:43 10/11/2013 -0800, Joel Madero wrote:
Why is everyone straying away from the fact that there is a simple
extension developed by Cor (one of our brilliant devs) which
accomplishes all of this? Just curious if there's a benefit to doing
these f
At 18:43 10/11/2013 -0800, Joel Madero wrote:
Why is everyone straying away from the fact that there is a simple
extension developed by Cor (one of our brilliant devs) which
accomplishes all of this? Just curious if there's a benefit to doing
these formula techniques instead of just pushing a b
> Why not set a cell to the formula "=right(len(CELL)-1) which returns the
> all the characters except for the first.
> --
No, that won't work. You probably meant:
=RIGHT(A1,LEN(A1)-1)
where "A1" is the 'text' cell. But that one will fail too, because
the initial single quotation mark is not
On 11/10/2013 06:32 PM, Brian Barker wrote:
At 21:17 10/11/2013 -0500, Jay Lozier wrote:
Why not set a cell to the formula =right(len(CELL)-1) which returns
the all the characters except for the first.
That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote
mark because it's *not
At 21:17 10/11/2013 -0500, Jay Lozier wrote:
Why not set a cell to the formula =right(len(CELL)-1) which returns
the all the characters except for the first.
That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote
mark because it's *not there*! The simpler formula
=RIGHT(Xn;LEN(X
On Mon, 2013-11-11 at 03:40 +0200, Paul wrote:
> On Mon, 11 Nov 2013 02:56:51 +0200
> Ady wrote:
>
> > As a simple user, I see this "hidden" addition of the initial single
> > quotation mark as a _BUG_, and as one of those basic "features" that
> > work poorly in LibreOffice Calc than in sever
> > As a simple user, I see this "hidden" addition of the initial single
> > quotation mark as a _BUG_, and as one of those basic "features" that
> > work poorly in LibreOffice Calc than in several other spreadsheet
> > tools. I don't know if this behavior can be "corrected" or improved.
>
> As
At 02:56 11/11/2013 +0200, Ady Noname wrote:
If the numbers (formatted as text) are already saved in your
spreadsheet, I would normally suggest a simple procedure involving
"paste special" and multiply (by "1"). This has worked for me in
several other spreadsheet tools. But Calc will (currently
At 14:57 10/11/2013 -0700, Oogie McGuire wrote:
I have a spreadsheet that is the output of a SQLite Database on
Android. It contains numbers that have been formatted as text. When
I copy the columns into my LibreOffice Spreadsheet I want to make
sure that they are interpreted as numbers. Howeve
> If you are importing a txt or csv file into Calc you can use INSERT >>
> SHEET FROM FILE. The first part of the wizard will you can click OK. The
> second dialog has a section "Other Options". In this section check
> "Detect Special Numbers". There is a preview screen which shows what the
> data
On Mon, 11 Nov 2013 02:56:51 +0200
Ady wrote:
> As a simple user, I see this "hidden" addition of the initial single
> quotation mark as a _BUG_, and as one of those basic "features" that
> work poorly in LibreOffice Calc than in several other spreadsheet
> tools. I don't know if this behavior
At 14:57 10/11/2013 -0700, Oogie McGuire wrote:
I have a spreadsheet that is the output of a SQLite Database on
Android. It contains numbers that have been formatted as text. When
I copy the columns into my LibreOffice Spreadsheet I want to make
sure that they are interpreted as numbers. Howeve
On Mon, 2013-11-11 at 02:56 +0200, Ady wrote:
> > I have a spreadsheet that is the output of a SQLite Database on Android. It
> > contains numbers that have been formatted as text. When I copy the columns
> > into my LibreOffice Spreadsheet I want to make sure that they are
> > interpreted as n
> I have a spreadsheet that is the output of a SQLite Database on Android. It
> contains numbers that have been formatted as text. When I copy the columns
> into my LibreOffice Spreadsheet I want to make sure that they are interpreted
> as numbers.
>
> However they come in as text and the man
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates
That extension should do the trick - we're trying to incorporate it into
the core code but so far you need the extension.
All the best,
Joel
On 11/10/2013 01:57 PM, Oogie McGuire wrote:
I have a sprea
I have a spreadsheet that is the output of a SQLite Database on Android. It
contains numbers that have been formatted as text. When I copy the columns into
my LibreOffice Spreadsheet I want to make sure that they are interpreted as
numbers.
However they come in as text and the manuals and help
47 matches
Mail list logo