On Fri, 26 Aug 2005 11:15:46 -0500
Dan Lewis <[EMAIL PROTECTED]> wrote:
> On Friday 26 August 2005 10:19 am, Pere Castañer Sarda wrote:
> Is there some way you can get the private Administration program to
> export the data in the correct format? (#.###,00)
I've talked to them and these settings are not parametrizated in his
private AD program.
> What I noticed in your sample spreadsheet could be the problem:
> every cell entry began with an apostrophe. That made all the cells
> appear as text. (You will only notice this apostrophe in the input line
> at the top when you select a cell. It does not appear in the cell
> itself.)
> If this is the problem (and it could be), add one more column (say
> column F) that is formated correctly for the numbers you need
> (#.###,00). In cell F1 enter
> =Value(D1)
> Select cell F1 again so that it has a "handle" (little square box at the
> lower right corner of the cell). Drag that handle down the column to
> include the last row with data in Column D. Create your sum function in
> Column F.
Yes but this cell isn't the one that I need to operate. The problem is in 4th
column and these numbers doesn't have any aphostrofe.
I've done all you posted and don't works. The cell with the funcion
Value(ColumnRow) returns "Err:502 Argumento inválido".
I come to my mind that oo2 doesn't has an conversion data assistant like MS
excel that can read text data and detects it as a numbers and you can set the
decimal separator character and other things. Perhaps the best way to do this
is implementing a similar tool.
What do you think about it?
----
--
Pere Castañer Sardà
Servei informàtic DIBOSCH S.L
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
