)
explanation.
Hope that this helps.
Pradeep Srinivas
on Feb 05 2012, Sunday, 18:20 IST (which is GMT +05:30)
--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
On Tuesday 08 Feb 2011 06:19:58 John Jason Jordan wrote:
On Tue, 08 Feb 2011 10:52:29 +1100
Russell Butler russ...@rj-il-butler.com dijo:
On 08/02/11 04:43, John Jason Jordan wrote:
SNIPPED
Just a suggestion, could you make a template with the language set to
Spanish and use that for when
On Friday 24 Sep 2010 00:28:46 John Bowling wrote:
I have columns that contain addresses.
Column A is number and street as in '1234 N Main'
Column B is the building and unit number as in 'F456'
Column C is the address as it would be placed on an envelope: '1234 N
Main F456'
I need to
,
but it is not the final-frontier font.
Methinks the font is causing the issue (although I have zero knowledge
of fonts and types, and beg to be excused for incorrect conclusions).
Hope that this is of some use to you (and please take it with a
generous helping [not just a pinch] of salt).
--
Pradeep
-list.
Cheers
--
Pradeep Srinivas
on 25 May 2010, Tuesday, IST (which is GMT +05:30)
---
See first with your mind,
then with your eyes,
and finally with your body.
-- Master swordsman Yagyu Munenori
be of some small use to you.
--
Pradeep Srinivas
Bangalore, India
on 19 Feb 2010, Friday, IST (which is GMT +05:30)
---
Time wounds all heels.
-- Groucho Marx
or tr or awk), remove the offending double quotes for the required
column, and open the file again in OOo. It seems to do the trick for
me, although I have not tested it well enough. YMMV.
Apologies if this does not work for you...
--
Pradeep Srinivas
on 17 Dec 2009, Thursday, IST (which
the array G2:G1388 to the sum() function. Otherwise, it supplies the
value of Zero to the sum() function.
Perhaps you may want to look for Array Functions in the Calc help
section ?
--
Pradeep Srinivas
on 17 Dec 2009, Thursday, IST (which is GMT +05:30
On Thursday 17 December 2009 18:40:11 Dotan Cohen wrote:
I apologize for all the questions, but I have been going at this
all day and these are the areas where I am getting stuck.
I have a column (Column A) with dates in the mm/dd/ format, a
column with a text format (Column B), and a
?
--
Pradeep Srinivas
on 02 Dec 2009, Wednesday, IST (which is GMT +05:30)
---
The early bird gets the worm, but the early worm gets eaten.
---
Signature block
On Saturday 21 November 2009 15:50:22 AG wrote:
Pradeep Srinivas wrote:
On Saturday 21 November 2009 00:44:49 AG wrote:
Original Question and response thereof removed
SNIPPED
a new style sheet. I presume that that means using a page style?
Others in the List : My apologies for stating
and kerning,
you would need to set this on a per instance basis of numbering.
May I suggest that you do this using stylesheets to save yourself
hassles ?
I trust this has addressed, at least in part, your query.
Cheers,
Pradeep Srinivas
--
on 21 Nov 2009, Saturday, IST (which is GMT +05:30
the point
entirely ? In the latter case, my apologies.
--
Pradeep Srinivas
on 20 Oct 2009, Tuesday, IST (which is GMT +05:30)
---
Art arises when the secret vision of the artist and
the manefestation of nature agree to find new shapes
? Please see http://openproj.org/openproj for more
details.
Pradeep Srinivas
Bangalore, India
--
on 08 Oct 2009, Thursday, IST (which is GMT +05:30)
---
The higher my rank, the more humbly I behave.
The greater my power, the less I
the statement above, which, in any case, is hard-coded for the
specific problem you have mentioned in your original post ?
In any case, have fun figuring out the formula :-^) !
Hope this helps in some small way.
Pradeep Srinivas
--
on 26 Sep 2009, Saturday, IST (which is GMT +05:30
-- About) that you are using ?
Should you decide to send the information, I leave it to your
discretion to send this to me privately, or send it to the list.
I am glad that your problem was solved.
Cheers
Pradeep Srinivas
--
on 29 Aug 2009, Saturday, IST (which is GMT +05:30
,
and to Wade.
Wade : Please accept my apologies - I used , in place of ; (commas
in place of semi-colons).
Must be too much of Microsoft influence (grin)
Pradeep Srinivas
--
on 27 Aug 2009, Thursday, IST (which is GMT +05:30
hope this is of some assistance to you.
Pradeep Srinivas
Bangalore, India
--
on 26 Aug 2009, Wednesday, IST (which is GMT +05:30)
---
Adding manpower to a late software project makes it later
Pradeep Srinivas
Bangalore, India.
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
for ALL your documents. On the other
hand, should you want to change the document for just ONE specific
document, perhaps you may want to look at the settings on a per Style
basis.
I trust this has been of some use to you.
Pradeep Srinivas
--
Bangalore, India.
on 25 Aug 2009, Tuesday, IST
On Saturday 22 August 2009 05:46:57 Brian Barker wrote:
At 19:51 21/08/2009 +0200, Jonathan Kaye wrote:
Here is my second question, Pradeep, since you
know regular expressions quite well.
Sorry, I'm not Pradeep; will I do?
That, Brian, is an understatement :-)
And Jonathan, thanks, but
On Saturday 22 August 2009 07:20:27 Helen wrote:
I've searched the archives and see various problems with headers,
but haven't found how to get a header (company logo/address) to
appear on page one only. I can get the logo to appear on all
pages, or not on any, but how can I get it to only
On Thursday 20 August 2009 15:04:04 Harold Fuchs wrote:
2009/8/20 Jonathan Kaye jdkay...@gmail.com
Hi all,
SNIPPED by Pradeep
All suggestions are welcome.
TIA
Jonathan
In the Find Replace dialogue click More options and then check
Regular Expressions. Now, in the Find box, enter *
On Friday 21 August 2009 00:52:57 Johnny Rosenberg wrote:
2009/8/20 Jonathan Kaye jdkay...@gmail.com:
SNIPPED by Pradeep
Unfortunately I don't drink stuff with alcohol, but thanks anyway!
:)
I think that you can also type {:space:} instead of just a space.
Takes longer time to type, but
) with a ~ (tilde) to get actual spaces in
the formula. Namely,
reinvestment=left lbrace binom {a×p~if~p0} {0~otherwise} right none
It is a purely cosmetic change.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL
to the thumbdrive - this
helps to isolate the problems.
In the absence of any info from you on OS, versions etc, this is the best I
can do. Probably other list members could help in a better fashion.
Please respond ONLY to the list.
--
Pradeep Srinivas
Bangalore, India
the
string], then, the value of 135 is put into the cell.
Trust that this also helps. And, once again, sorry for the delay.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
the \n
syntax does not work (refer Don's mail on this), but I trust this would help
you in handling the replacements using RE alone (with due apologies to, as
you so aptly put it, the Le Maestro des Macros - Andrew Pitonyak.)
--
Pradeep Srinivas
Bangalore, India
-1.2320
Hope this helps.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
On Wednesday 11 Jul 2007, Harold Fuchs wrote (regarding Re: [users] Group Text
Box and Draw Object):
On 11/07/07, Pradeep Srinivas [EMAIL PROTECTED] wrote:
On Wednesday 11 Jul 2007, Harold Fuchs wrote (regarding [users] Group
SNIPPED
It's strange. About 75% of the time selecting the text box
, has a crystal ball, or reads tea leaves.
Therefore, what precisely are you talking about ? Please, pretty please : may
we have more information ?
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL
are so inclined to do so, send me a sanitized version (no ACTUAL
personal, price information) of your spreadsheet. Tell me what your
expectations are, and what output you expect to see.
Please send it to me OFF THE LIST, and I will see if I can help.
--
Pradeep Srinivas
Bangalore, India
it to something that a logical function (like
IF() ) can use ?
or
c. is there a function that behaves like the regular expression match
operator in awk (the ~ operator, as in $1 ~ Server )
--
Pradeep Srinivas
Bangalore, India
On Saturday 19 May 2007, Brian Barker wrote (regarding Re: [users] SEARCH
function - return value - help requested):
At 11:45 19/05/2007 +0530, Pradeep Srinivas wrote:
SNIPPED
Am I doing something fundamentally wrong ? If not, is there any
function that
would
a. return 0 if a search item
(however incompetent that help may be talk of the blind leading the
blind...)
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
...
Therefore,
in C3 put in =C2 + A3 - B3
and copy that to all the rows below C3.
If this is not what you want, please explain the situation once again to the
list.
Please respond to the list - NOT to me.
--
Pradeep Srinivas
Bangalore, India
, or equivalent) to do this ?
Any responses welcomeas usual!
--
Pradeep Srinivas
Bangalore, India
On Sunday 22 Apr 2007, John King wrote (regarding [users] Re:
Writer:Bullets:Right alignment):
Pradeep Srinivas wrote:
List:
Is there a method by which I can get the bullet portion (or the
numbered bullet portion) of a list to be right aligned ?
SNIPPED
John King replied:
Use Format
*for
your type of work*
(What a way to spend a vacation!)
Yep, that feeling is familiar to me.after 23 years in the support
field
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
On Thursday 19 Apr 2007, NoOp wrote (regarding [users] Re: OpenOffice +Jexec
+ Nautilus):
On 04/19/2007 01:56 AM, Pradeep Srinivas wrote:
On Thursday 19 Apr 2007, NoOp wrote (regarding [users] Re: OpenOffice
+Jexec + Nautilus):
SNIPPED - large volumes
Hi Gary,
Did more work through
On Thursday 19 Apr 2007, NoOp wrote (regarding [users] Re: OpenOffice +Jexec
+ Nautilus):
On 04/18/2007 10:39 PM, Pradeep Srinivas wrote:
On Thursday 19 Apr 2007, NoOp wrote (regarding [users] Re: OpenOffice
+Jexec
+ Nautilus):
On 04/18/2007 10:08 PM, Pradeep Srinivas wrote
On Thursday 19 Apr 2007, Michael Adams wrote (regarding Re: [users] Re:
OpenOffice +Jexec + Nautilus):
On Thu, 19 Apr 2007 10:38:53 +0530
Pradeep Srinivas wrote:
Large Chomp
If it was a browser, and recent enough, search the browser history.
If it was curl or wget the console history may
sorrows in a pint of beer. :-)
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
=E736D3AC9269D49920CA4DC68089EE91
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6510610
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6211008
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED
On Thursday 19 Apr 2007, NoOp wrote (regarding [users] Re: OpenOffice +Jexec
+ Nautilus):
On 04/18/2007 08:29 PM, Pradeep Srinivas wrote:
List:
This thread is a new one, even though it *may* have some relevance to the
thread Potential Virus opened by Kurt Rottmann and replied to by NoOp
On Thursday 19 Apr 2007, NoOp wrote (regarding [users] Re: OpenOffice +Jexec
+ Nautilus):
On 04/18/2007 10:08 PM, Pradeep Srinivas wrote:
On Thursday 19 Apr 2007, NoOp wrote (regarding [users] Re: OpenOffice
SNIPPED
No problem. I'll download directly. I can confirm
http://bugs.sun.com
telepathic [ tele-pathetic ? ] in my old age
grin.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
the cellOP, please confirm, and if I am not right,
ignore this message
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
were preserved, but agreed
with Terry that the additional language dictionaries were lost
Thanks a lot, people, and I appreciate your help and inputs.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED
on
Many thanks !
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
On Thursday 22 Mar 2007, Hylton Conacher (ZR1HPC) wrote (regarding Re: [users]
OO Calc 2.04 Cell linking and Copy and Paste error):
Pradeep Srinivas wrote:
Snipped LARGE amounts of correspondence
Hylton:
Sorry, I tried to recreate your problem, and therein a solution. I regret I
could
On Sunday 11 Mar 2007, Brian Barker wrote (regarding Re: [users]
Calc::Updating Calculated (text) cell values):
At 10:23 11/03/2007 +0530, Pradeep Srinivas wrote:
OP's original mail SNIPPED by the OP
I see the same behaviour.
One workaround is to use Ctrl+Shift+F9 instead, which recalculates
On Sunday 11 Mar 2007, TerryJ wrote (regarding Re: [users] Calc::Updating
Calculated (text) cell values):
Pradeep Srinivas wrote:
SNIPPED: OP's mail, Brian's response, OP's response
Now, if someone can tell me how to get Calc to do the recalculation
automatically..
I believe that would
the spreadsheet.
I have tried F9 (recalculate) to force the calculation, but it does not seem
to do anything in **this** specific instance.
Am I missing something (either in the formula, or in the configurations)? Any
help is appreciated !
--
Pradeep Srinivas
Bangalore, India
: [EMAIL PROTECTED]
Jason, pardon my ignorance, but I do not think that this happens to be a OOo
problem. Probably a problem with Gnome ? I run OOo 2.1 on KDE, and the
fonts look fine to me.
Other members: please correct me if my statement above is not right
--
Pradeep Srinivas
Bangalore, India
(rest of the list, my apologies)
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
the whole formula.
SNIPPED
Johnny,
The help section says Control+Shift+F9 will recalculate. Perhaps you could
try that ?
Sorry, cannot help with your own function right now, let me investigate, and
if I have anything to contribute, will do so.
Pradeep Srinivas
Bangalore, India
PROTECTED]
SNIPPED
Uh, rlshadow, I think Marc meant that the wordings on the
openofficetechnology.com site had that clause - not the one OpenOffice.org.
Or am I mistaken, Marc ?
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e
file, which, when
read by Writer can set the correct style till it meets the next tag ?
I had used such a functionality, a very long time ago, in PageMaker...
Any responses would be well appreciated.
--
Pradeep Srinivas
Bangalore, India
On Tuesday 30 January 2007 20:31, Harold Fuchs wrote (regarding Re: [users]
OOo:Writer:Tags capability):
On Tuesday, January 30, 2007 1:24 PM [GMT+1=CET],
Michele Zarri [EMAIL PROTECTED] wrote:
On 1/30/07, Harold Fuchs [EMAIL PROTECTED] wrote:
On 30/01/07, Pradeep Srinivas [EMAIL PROTECTED
notation ( 27 ^ (-3) ) is incorrect: you should be
doing (27 ^ ( 1/3)), which will get you the right answer of 3.
In general, if you have the number in A1, and the nth root you require in B1,
then, your formula should look like =A1 ^ (1/B1).
Hope this helps.
Pradeep Srinivas
Bangalore, India
. If it does not, errrmy apologies.
H. anyone on the list have a more elegant, easy solution ?
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
use).
--
Pradeep Srinivas
+91 994 002 2692
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
if this is normal ? PS:, sorry,
did not mean to hijack the thread.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
considerate manner, keeping in
mind that all the respondents of this list are volunteers.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
figured
out. If anyone wants to see a draft once I get it to point I would be
willing
to show someone, I will happily post a link to the list (or off-list).
Yes please, Robert, I would be interested. Please do post me a copy when you
are ready with it.
Many thanks.
--
Pradeep Srinivas
, please** do NOT post to the list, but
send it to my id alone.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
On Friday 05 January 2007 11:40, Thomas W. Cranston wrote (regarding [users]
[Fwd: [Spam] [users] Tomorrow night..]):
Anybody else get this?
For what it is worth, I got this 3 times today.yecch!
--
Pradeep Srinivas
Bangalore, India
returned by SEARCH() changes everywhere.
Is this what you want, or have I, as is my norm, completely mistaken your
requirements ? Do ask, and if you want me to send you the worksheet, let me
know.
--
Pradeep Srinivas
Bangalore, India
mailsthe dang system is now asking for the RR's for
all mails. Now, if only I can get my system to co-operate with me
Till then, please put up with me.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail
of all headers, titles or any other text. If that's
a problem, there's an easy way around that, just ask., and ask you for help
on how to overcome this ?
Many thanks, once again.
--
Pradeep Srinivas
Bangalore, India
On Thursday 04 January 2007 15:03, Harold Fuchs wrote (regarding Re: [users]
Finding Several Numbers in Calc):
On Thursday, January 04, 2007 3:00 AM [GMT+1=CET], Pradeep Srinivas
[EMAIL PROTECTED] wrote:
On Thursday 04 January 2007 05:49, Harold Fuchs wrote (regarding
[users] Finding
bold.
In short - is there a method of getting a **paragraph style** to make the
first word bold, and the remaining words regular ?
Any suggestions would be greeted with open arms, and (more importantly) an
open mind.
--
Pradeep Srinivas
Bangalore, India
not understand regular expressions in the find
text portion of the function (i.e., the first argument to the function) and
therefore, cannot interpret the [a-c] as a, b, or c.
I also tried out the SEARCH function, and it works the way Joe said it worked.
--
Pradeep Srinivas
+91 994 002 2692
not understand regular expressions in the find
text portion of the function (i.e., the first argument to the function) and
therefore, cannot interpret the [a-c] as a, b, or c.
I also tried out the SEARCH function, and it works the way Joe said it worked.
--
Pradeep Srinivas
+91 994 002 2692
(highlight all the cells below C3, and press Control-V).
See if this does the job for you - as I said, it is very rudimentary, and has
NO error, or bounds checking.
If this does what you want, cheers! Else, email either the list, or me, off
the list, and we can see what can be done.
--
Pradeep Srinivas
as well:
\5|\7|9\
This would find a 5 or a 7 at the start of the line, but not at the end (or
anywhere else), or a 9 at the end of the line, but not anywhere else.
--
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail
with user profiles. Unfortunately, I do
not remember what we did to sort this out for 2.1 (was too late in the night,
and the gray matter was in abeyance - not to mention the fact that senility
is fast catching up with me).
Pradeep Srinivas
Bangalore, India
as I can acertain, there is **no** way to paste any value into either a
set of disjoint cells, or even adjoining cells at the same time.
Anyone with a different answer ?
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail
multiple values
go into disparate cells), I still think it **cannot** be done.
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
be reverted with a single EditUndo so that you can find
different values without confusing things.
Harold Fuchs
London, England
Harold,
Brilliant
Now, why did I not think of it
Pradeep Srinivas
Bangalore, India
On Friday 22 December 2006 15:12, Harold Fuchs wrote (regarding Re: [users]
Re: Finding Several Numbers in Calc (was Re: [users] [moderated] YOU MUST
GIVE A SUMMARY HERE)):
On Friday, December 22, 2006 5:28 AM [GMT+1=CET], Pradeep Srinivas
[EMAIL PROTECTED] wrote:
On Thursday 21 December
2.6.18-1.2254
Hope this helps.
Pradeep Srinivas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
2.6.18-1.2254
Hope this helps.
Pradeep Srinivas
Bangalore, India
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
versions of OOo on other platforms.
Pradeep Srinivas
Bangalore, India.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
, and/or you are not on
Windoze, my apologies, and you do know where the delete key is :-)
Pradeep Srinivas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
On Thursday 07 December 2006 15:06, Guy Voets wrote (regarding Re: [users] MS
Word Markup and track changes Equivalent in Writer):
2006/12/7, semaj3000 [EMAIL PROTECTED]:
What is the Openoffice Writer equivalent of M$ Word Track changes and
markup?
I had a word (doc) filed originally
87 matches
Mail list logo