In fact I don't really know what does "gen led account" and "gl account" (i
guess they are the same thing... either way, I don't know what is it).
Another way to do it is with cell range names.
For example, imagine the January range you want to sum is from N1:N18, and
the february range is from N
Hi.
Imagine you have your data in the range C7:C19
You could use something like this:
=SUMPRODUCT(1*(C7:C19>4)*(C7:C19<7))
Well, the first "1" is not needed, but I use it for clarity.
What this formula does is:
a) whenever a value in the range is grater than 4, the section "(C7:C19>4)"
equals
2009/2/6 M Henri Day
> 2009/2/6 Richard
>
> > Russell Butler wrote:
> >
> >> Richard wrote:
> >>
> >>> Richard wrote:
> >>>
> It used to be that when a file was being used from a file server at a
> work station, should someone else open the same file, editing would be
> impossible
2009/2/5 Brian Barker
> At 18:38 05/02/2009 -0600, Ely Schoenfeld wrote:
>
>> The precision error didn't happen when I added 2.34 plus -2.73, it only
>> happened when adding 18282.34 plus -18282.73 so it must have to be related
>> with the "size" of the op
2009/2/5 Brian Barker
> At 13:28 04/02/2009 -0600, Ely Schoenfeld wrote:
>
>> I discovered something odd with OOo 3.0.1 Calc.
>> [...]
>> If I add more decimals to the cell format, I get something like -0.39,
>> that's ok.
>> But If I copy the last c
See below
2009/2/5 Web Kracked
> Guy Voets wrote:
>
>> However, I do not see any mention on the sending of email attachments to
> the List.
> Thank you.
>
> On the link you posted, select mailing lists, item # 4 is;
"4 Please do not send attachments with your message,
see bellow.
2009/2/5 Marc Schwartz
> Ely Schoenfeld writes:
>
> > Hello all.
> >
> > I discovered something odd with OOo 3.0.1 Calc.
> >
> > Hope someone could verify this for me.
> >
> > a) Put in two different cells the numbers:
> >
>
Thank you for taking the time to answer.
I really appreciate it.
About the problem. See below.
2009/2/4 JOE Conner
> Ely Schoenfeld wrote:
>
>> Hello all.
>>
>> I discovered something odd with OOo 3.0.1 Calc.
>>
>> Hope someone could verify this for me.
>
If you go to http://www.openoffice.org/index.html and then click on the "I
want to download OpenOffice.org" link, you will see there appears a green
area where you can download it. If you look closely, bellow that, also
appears a "more platforms and languages" link, that points to:
http://download
Hello all.
I discovered something odd with OOo 3.0.1 Calc.
Hope someone could verify this for me.
a) Put in two different cells the numbers:
18282.34 (For example A1)
-18282.73 (For example A2)
b) Add them in another cell. (For example A3)
Doesn't matter if you use the "SUM" formula or just
res the formula
wirtten by the user against the English strings in case it isn't found in
the translated ones.
I don't know... maybe I just don't know enough.
Or... is not worth enough?
Ely
2009/2/3 Jean-Baptiste Faure
> Le 03.02.2009 21:46, Ely Schoenfeld a Ă©crit :
> >
English version
before they release the Spanish langpack.
Cheers.
Ely
2009/2/3 Ely Schoenfeld
> Hello everybody.
>
> I want to open an issue about this, but I think it's better to discuss this
> here before I do. I don't know if there is already one open, by the way.
>
>
Hello everybody.
I want to open an issue about this, but I think it's better to discuss this
here before I do. I don't know if there is already one open, by the way.
I really think all translated versions of OOo Calc should also understand
the English version of formula names mainly because of tr
Sorry, but I can't see any relationship between OpenOffice and those
programs.
I don't think OpenOffice can do any thing that prevents yahoo messenger or
WindowsLiveMessenger etc. Unless you changed your Java Runtime Environment
to a very very old one or something like that. But that doesn't have
The formula translations can be found at:
http://www.sunvirtuallab.com:32300/es/openoffice_org/sc/source/core/src.po?translate=1&view=1
the "es" part of the link means Spanish. If you want, for instance, the
Russian ones go to :
http://www.sunvirtuallab.com:32300/ru/openoffice_org/sc/source/core
Hi.
Just wanted to say that this formula doesn't work as you expect.
Look bellow.
2008/10/22 Michael D. Roush <[EMAIL PROTECTED]>
> Hedley Finger wrote:
>
>>
>> I can do most of it if I drink a gin or two. But the tricky bit is "So I
>> want to subtract the deadline date from the actual submi
Sry... forgot to add the fixed one:
=SI(B4>A4;C4*(1-((B4-A4)*0.05));C4)
2008/10/27 Ely Schoenfeld <[EMAIL PROTECTED]>
> Hi.
>
> Just wanted to say that this formula doesn't work as you expect.
>
> Look bellow.
>
> 2008/10/22 Michael D. Roush <[EMAI
Maybe this is old... sorry if it is.
I use another way to accomplish this. I learned this function here, in the
mailing list. I'm just applying it differently.
Imagine you have a calc document with dates on column b, status on column c
and student name on column d.
First of all... you must agree
I guess you should download it again, and make sure the MD5 checksum
calculation matches the ones from the web page at:
http://download.openoffice.org/3.0.0/md5sums.html
Sometimes the downloads have errors in them.
If you don't know how to check for this, just go to:
http://www.openoffice.org/d
To add a free pdf printer in Windows XP I've used this very detailed
instructions:
Configure Free PDF on Microsoft Windows™ XP
http://www.geocities.com/thompso_m1/freepdf/winxp/index.html
Hope it helps.
Ely.
> Ely Schoenfeld wrote:
>
>> You might have added a box (or an arrow or somethi
I new there should be an easier way.
:)
2008/10/21 Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
> John Jason Jordan wrote:
>
>> On Mon, 20 Oct 2008 21:46:41 -0700
>> John Jason Jordan <[EMAIL PROTECTED]> dijo:
>>
>>
>>
>>> OK, took the plunge and installed 3.0 on Ubuntu Hardy x86_64. There are a
You might have added a box (or an arrow or something from the draw toolbar)
and changed the background transparency.
Do the following if you want to change the transparency setting.
a) go to "view/toolbars" menu
b) select the "draw" toolbar
c) click on the little blue square
d) click somewhere in
My answer is down there.
2008/10/18 Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
> Ely Schoenfeld wrote:
>
>> Now I get it. I have just discovered why nobody answers to my last few
>> mails. WRONG "FROM" ADDRESS! ha ha ha.
>>
>>
>
> I usuall
How are you getting the csv file into OOo calc?
When you open it, there should appear a window where to change settings of
"comma" or "tab" as separator and those things.Below that, appear a few
lines of the file showing how columns will be imported.
If you look closely, on top of each column, th
You can download the example from:
http://www.mitalteli.com/tmp/ootest_HelpNeededToDeleteLinksToOtherCalcDocuments-20081013.zip
2008/10/16 Ely Schoenfeld <[EMAIL PROTECTED]>
> Now I get it. I have just discovered why nobody answers to my last few
> mails. WRONG "FROM" ADDRE
ffice.org/wiki/Documentation/DevGuide/Spreadsheets/DDE_Links
Maybe someone has the sources installed, and maybe could take a look on how
the "break" (or whatever is called in the English version) button at Edit /
Links menu works
Any help will be really appreciated.
Ely.
-- Forward
ink to the relevant part of the api I would
appreciate it too.
Thank you all, again.
Ely
2008/10/14 Ely Schoenfeld <[EMAIL PROTECTED]>
> Hi.
>
> It's me again.
>
> I've found the following at:
> http://www.oooforum.org/forum/viewtopic.phtml?t=24192&hig
at is happening?
or
How could I break those links instead of "refresh" them?
Thank you all in advance.
2008/10/13 Ely Schoenfeld <[EMAIL PROTECTED]>
> My answers appear bellow.
>
> 2008/10/12 Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
>
> Ely Schoenfeld w
(The remote cell I want to
link to)
Every time the formula is entered, the link to that specific cell is added,
and every time the formula es deleted, the link is deleted automatically.
(OO3.0RC4, Win XP)
Either way... I still think there is a bug with the
"='file:///path/to/file.ods'
My answers appear bellow.
2008/10/12 Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
> Ely Schoenfeld wrote:
>
>> First of all, thank you for taking the time to answer.
>>
>> My answers appear later on.
>>
>> 2008/10/11 Andrew Douglas Pitonyak <[EMAIL
First of all, thank you for taking the time to answer.
My answers appear later on.
2008/10/11 Andrew Douglas Pitonyak <[EMAIL PROTECTED]>
> Ely Schoenfeld wrote:
>
>> Sorry, I forgot to add the question:
>>
>> Does some one knows how to delete the links to o
Hello all.
I discovered that if you go to "Edit/Links...", select a linked file, click
on "break link" button (or however is called in English) and press the "ok"
button then you aren't able to add new linked data ever again.
I have OO3.0RC4 on Windows XP
To reproduce do the following:
1) Creat
Sorry, I forgot to add the question:
Does some one knows how to delete the links to other documents from a
macro/function/button?
Ely.
Hello all.
I'm not sure if this list is the right place to ask for help with this, I
hope someone can redirect me to an appropriate place.
I have a problem with inked data between some calc documents.
Every month I need to create a new document, and copy the "ending balance"
from the previous mo
Hi.
Here is a conversation of Joe Smith with James Elliott: (Last Sat, 20 Sep
2008 00:11:42 -0400)
*** BEGIN
James Elliott - WA Rural Computers wrote:
> ...
> So, in Calc (forget Excel) we can use either of these formats, can we?:
>
> =SUMPRODUCT(
acters fine, and put the same in your laptop.
Hope it helps.
Ely.
2008/9/12 Harold Fuchs <[EMAIL PROTECTED]>
>
>
> >
> >
> > 2008/9/11 Brian Barker <[EMAIL PROTECTED]>
> >
> > > At 23:20 11/09/2008 +0100, Harold Fuchs wrote:
> > >
>
le .po file contents.
Just in case someone needed to know. The calc file Brian sent is more than
enough for me.
Thanks again to Harold and Brian.
2008/9/11 Ely Schoenfeld <[EMAIL PROTECTED]>
> WOW
>
> THANKS a LOT
>
> I really appreciate your help.
>
>
> 2008
WOW
THANKS a LOT
I really appreciate your help.
2008/9/11 Brian Barker <[EMAIL PROTECTED]>
> At 23:20 11/09/2008 +0100, Harold Fuchs wrote:
>
>> On 11/09/2008 20:23, Ely Schoenfeld wrote:
>>
>>> I'm having trouble finding some formulas in calc
Hello all.
I'm having trouble finding some formulas in calc because I learned them in
English, but I've now installed OO in Spanish. I need to find an easy way to
see how they are translated.
It would really be great if OpenOffice Calc had a way to "Use formula in
English" or a way to "Translate
ent limitation of OOo?
>
> There are some minor correction in your steps which I have corrected
> below (for posterity) :
>
> Ely Schoenfeld wrote:
> > Yes, it does.
> >
> > At least if you use the standard styles.
> >
> > You need to modify the table, though. A
Sorry, wrong link for the issue:
This is the correct one:
http://www.openoffice.org/issues/show_bug.cgi?id=3356
"Additional styles not included in hyperlinking from TOC"
2008/8/26 H.S. <[EMAIL PROTECTED]>
> Hello,
>
> Does anybody know if OOo 2.4.1 makes hyperlinks in its tables and
> indexes? F
Yes, it does.
At least if you use the standard styles.
You need to modify the table, though. After you insert the TOC, right-click
on it, select "edit toc/index" (or some thing like that)
a) On tab "Entries"
b) Select the level of the TOC that you want to convert inito a link
c) In the right sid
You could do some thing like:
=CONCATENAR("Option ";M33)
(my version of OO is in Spanish, but I think you could find that function
easily)
Hope it helps.
Ely
2008/8/21 Mark Knecht <[EMAIL PROTECTED]>
> Hi,
> I'm looking at a prebuilt spreadsheet in Excel and trying to
> duplicate some of it
if all they where entered manually. Or a way to "CONVERT ALL
VARIABLE FIELDS TO SIMPLE TEXT".
Anyway, I don't know if there is enough people who needs it.
Ely.
2008/8/21 Uwe Fischer <[EMAIL PROTECTED]>
> Ely Schoenfeld wrote:
>
>> I've found some people asking ab
Yes, you can.
Do the following:
a) Put the cursor at the beginning of the string
b) Open the "find-replace dialog" (In the edit menu)
c) Put the following in the "search" field [ don't forget the dot just after
the first "(" ]:
(.{10})
d) Put the following in the "replace" field:
$1\n
e) Th
Thank you very much for this link.
I did find it before, but never thought in there was explained how to split
a file. It does.
My problem now is that each file is still with wrong page numbers/chapter
numbers/references.
My document isn't that big. What I'm going to do is to divide the document
I forgot to say:
I'm using Openoffice 2.4.1 in spanish.
My OS is Windows XP.
--
**
Ing. Ely Schoenfeld Phone:+52 55 5682 9176
On Wed, August 20, 2008 10:15 am, Ely Schoenfeld wrote:
> Hi all.
>
> I'v
te I studied at, in order to deal with all the
graduation proceedings quickly.
Does someone has any suggestion?
I wouldn't mind to uncompress the odt file and "fiddle" with it. Any thing.
Any help would be really appreciated.
Thanks in advance.
--
***
48 matches
Mail list logo