I don't know how big your numbers are but ...
The spreadsheet in question sees rounding in two places. In one sheet,
this number 317907988 was rounded to 317908000 in one row, but in
a later row was not rounded. In another sheet, the number 330476211
was rounded to 330476000. All these fields
Brian Barker wrote:
At 20:55 13/07/2009 -0400, Ponly Jonly Honly wrote:
I created a table by inserting a CSV file and using convert text to
table. The resulting table was full-width. I made it narrower
hoping to be able to add text to the right of that table, but I
cannot get an insertion
Manfred J. Krause wrote:
Hi,
On Tue, Jul 14, 2009 at 06:15, Girard Aquino wrote:
Hi. I wonder if someone could help me out.
I just discovered a problem with OOo having trouble opening my default email
client (thunderbird) when choosing to send the document as email. I have OOo
3.1 on XP. I've
2009/7/14 Dotan Cohen dotanco...@gmail.com
I don't know how big your numbers are but ...
The spreadsheet in question sees rounding in two places. In one sheet,
this number 317907988 was rounded to 317908000 in one row, but in
a later row was not rounded. In another sheet, the number
Have you still got the sheet with the number correct in one cell and rounded
in another? If so you could have a look in the content.xml [sub-]file to see
how they are being stored. To do this, open the .ods file with something
like WinZip or gzip or 7-Zip and look at the content.xml file it
2009/7/14 Dotan Cohen dotanco...@gmail.com
Have you still got the sheet with the number correct in one cell and
rounded
in another? If so you could have a look in the content.xml [sub-]file to
see
how they are being stored. To do this, open the .ods file with something
like WinZip or
There are options in the Paste Special menu that
add/subtract/multiply/divide the copied value to/from/by/by the target cell
before overwriting that cell. So, if you Copy 100 and Paste Special with
Subtract turned on into a cell containing 1234567 you'll end up with
1234467. Paste Special
2009/7/14 Dotan Cohen dotanco...@gmail.com
There are options in the Paste Special menu that
add/subtract/multiply/divide the copied value to/from/by/by the target
cell
before overwriting that cell. So, if you Copy 100 and Paste Special with
Subtract turned on into a cell containing
I need to run a php script from cron.
I will be developing it from the console using the cli.
for debugging use, do echo statements echo to the console or do I need
to explicitly open the console for output ?
when I finish the testing and want to start it from cron, would I use
php
I have to many users groups - this was obviously intended for a ubuntu
group, sorry.
--
Bill Drescher
william {at} TechServSys {dot} com
PJH wrote:
Manfred J. Krause wrote:
Hi,
On Tue, Jul 14, 2009 at 06:15, Girard Aquino wrote:
Hi. I wonder if someone could help me out.
I just discovered a problem with OOo having trouble opening my
default email
client (thunderbird) when choosing to send the document as email. I
have OOo
On 07/14/09 03:00, Harold Fuchs wrote:
On 14/07/09 01:18, Gene Kohlenberg wrote:
Harold Fuchs wrote:
On 14/07/09 00:38, Gene Kohlenberg wrote:
I finally remembered that there is an option to choose which monitor
is used for the presentation.
...
...
I'm surprised your Sun Console
1234567898765 1234567898765
12345678987654 12345678987654
123456789876543123456789876543
*1234567898765432 1234567898765430 *
I´ve just tried Excel (version 2002, aka MS Office XP, on a WIN XP
machine, SP3)
I got just the same result, see the blue-marked numbers.
I
THIS IS MY SECOND REQUEST.THANK YOU.
**An Excellent Credit Score is 750. See Yours in Just 2 Easy
Steps!
(http://pr.atwola.com/promoclk/100126575x1221323036x1201367247/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072hmpgID=62bcd=Jul
yExcfooterNO62)
mian...@aol.com wrote:
THIS IS MY SECOND REQUEST.THANK YOU.
**An Excellent Credit Score is 750. See Yours in Just 2 Easy
Steps!
(http://pr.atwola.com/promoclk/100126575x1221323036x1201367247/aol?redir=http://www.freecreditreport.com/pm/default.aspx?sc=668072hmpgID=62bcd=Jul
On Jul 14, 2009, at 12:45 PM, Per wrote:
Is it a sort of handling the numbers in Works, Calc and Excel that
causes the round-up effect???
I think these results are more correctly called truncation and
result from the inherently limited numerical precision of digital
computers. It's not
I think these results are more correctly called truncation and result from
the inherently limited numerical precision of digital computers. It's not
surprising that Excel and Calc exhibit the same problem if they use the same
precision (i.e., single, double, whatever) for storing numbers in
My goal is not to recover the data, Harold, as I already have it. My goal is to
figure out why the numbers are rounded.
Dohan..
Is the numbers being rounded up at once when the users put them in the
spreadsheet ???
Is there any strange formats in the row to the left of the numbercolumn???
On 14/07/09 17:45, Per wrote:
1234567898765 1234567898765
12345678987654 12345678987654
123456789876543123456789876543
*1234567898765432 1234567898765430 *
I´ve just tried Excel (version 2002, aka MS Office XP, on a WIN XP
machine, SP3)
I got just the same result, see
On 14/07/09 18:32, Dave Post wrote:
On Jul 14, 2009, at 12:45 PM, Per wrote:
Is it a sort of handling the numbers in Works, Calc and Excel that
causes the round-up effect???
I think these results are more correctly called truncation and
result from the inherently limited numerical precision
On 14/07/09 13:50, Uwe Fischer wrote:
On 07/14/09 03:00, Harold Fuchs wrote:
On 14/07/09 01:18, Gene Kohlenberg wrote:
Harold Fuchs wrote:
On 14/07/09 00:38, Gene Kohlenberg wrote:
I finally remembered that there is an option to choose which
monitor is used for the presentation.
...
...
Harold Fuchs wrote:
On 14/07/09 17:45, Per wrote:
1234567898765 1234567898765
12345678987654 12345678987654
123456789876543123456789876543
*1234567898765432 1234567898765430 *
I´ve just tried Excel (version 2002, aka MS Office XP, on a WIN XP
machine, SP3)
I got just
Is the numbers being rounded up at once when the users put them in the
spreadsheet ???
No, this is data that was entered somr time ago, and just now
discovered to be rounded.
Is there any strange formats in the row to the left of the numbercolumn???
If so, could this cause the round up..
At 04:51 14/07/2009 -0400, Ponly Jonly Honly wrote:
Brian Barker wrote:
o Format your page in two columns, with the table in one and the
text in the other. If necessary, insert a section with two
columns, so that this can apply only to part of a page or pages.
Have to be sure table reaches
Hi there,
I really appreciate all the help here.I'm trying to make an ebook and I
want to import a picture to my text document, how do I do that? Also, how do I
import clip art? I'm guessing it's the same function but just in case.
thanks so much,
Kathy
~Be good to yourself - the
Kathy Brown wrote:
Hi there,
I really appreciate all the help here.I'm trying to make an ebook and I want to import a picture to my text document, how do I do that? Also, how do I import clip art? I'm guessing it's the same function but just in case.
thanks so much,
Kathy
Kathy,
Manfred J. Krause wrote:
Hi,
On Tue, Jul 14, 2009 at 06:15, Girard Aquino wrote:
Hi. I wonder if someone could help me out.
I just discovered a problem with OOo having trouble opening my default email
client (thunderbird) when choosing to send the document as email. I have OOo
3.1 on XP.
I was testing OpenOffice for using it at our local Red Cross office. MS
Office is just too pricy for a small chapter.
I could only find the ability to open an Access 2007 database. Ours is in
Access 2000, but could become 2003 for conversion to Base.
Any Suggestions? Methods?
Thanks
Dear Support
i write for two personal problem using open office writer.
first - i need to adapt width of a column during word's
writing. i find only the function optimal width but after
writing but not during the process.
second - i need to make a rectangle around a word for
evidence it but not
Yes the automatic file extension is turned on, and the files are saved odt.
I finally got it to work by uninstalling the OO program and reinstalling it.
I don't have a clue what happened to cause this, but it seems to be working
now.
Thanks for the reply
Saundra
- Original Message -
Hi,
is it possible to disable the expansion of a regular expression
for just one cell (or a group of cells)?
Let's say the cell A1 holds 3+ and I want to use some
VLOOKUP(A1;). I'd like to supress the expansion of 3+ as a
regular expression just for this single cell (or for
Dear Madam, Sir,
Having already registred with Sun when downloading OpenOffice 3.1 on May
7th,09, I don't succeed in registering again with password and email address,
after some software program (safety) removed this entry in my PC. As a result,
I cannot open my database anymore.
Do you have a
Greetings:
I haven't done so for years, but recently I tried to inert an animated
GIF into my Writer documents (Mac 3.00 and up under 10.4.11) and found
out that it doesn't actually embed self-contained media files in the
document anymore like the old versions did, but instead relies on media
As I returned to macro programming after some time away from it, I find
I can no longer access the Macro toolbar in the Basic IDE editor.
Everything I was accustomed to seeing on the fourth line of the editor,
i.e. immediately below the Title bar, the Menu bar, and the Standard
toolbar with
i have open office 3.1and using it with windows xp home. the problem is that
when i try to
print i only get the first 20 or so items not the 167 in the database. any
ideas on how to
print all of it? thanks
On 07/13/2009 10:20 PM, Tamblyne wrote:
On Tue, 14 Jul 2009 00:13:43 -0500, Tamblyne tambl...@gmail.com
wrote:
I've taken a break from trying to do these cemetery transcriptions in
a spreadsheet. The date formatting tricks worked great, but it was
too clunky otherwise. So I switched to a
Hi,
I want to send a newsletter to people that Opt-in to get it. Nothing
fancy. Name, address, email, phone, fax, maybe a couple check boxes if
they want something else, also.
Should I use OOo to get the data input and use MySQL for the back end?
Or should I use OOo for the whole thing?
37 matches
Mail list logo
