Hi Kohei,
On Thu, Apr 14, 2005 at 10:54:22 -0400, Kohei Yoshida wrote:
For everyone's benefit, let me just post the following Basic code as
an example of inserting a page number and a page count into a
header/footer of a Calc document.
Nice. Could you please add it to the code snippets base?
Hi Jahn,,
On Tue, May 17, 2005 at 12:59:15 -0400, Jahn, Ray (R.) wrote:
possibly related OO issue 48147
If you actually subscribed to the mailing lists you're posting to you
would have noticed that your question was already answered 4 days before
you reposted it, also on the [EMAIL PROTECTED]
Hi M.,
On Tue, Sep 20, 2005 at 20:36:36 +0200, M. Fioretti wrote:
http://software.newsforge.com/article.pl?sid=05/09/09/192250tid=93
Thanks for the pointer.
Eike
--
OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer.
GnuPG key 0x293C05FD: 997A 4C60 CE41 0149
Hi Jody,
On Thu, Sep 22, 2005 at 14:04:59 -0400, Jody Goldberg wrote:
What is the goal of an open-formula specification ? I'd assume it is
to improve interoperability between versions and implementors of the
standard.
This is also what I assumed. Which left me even more puzzled why the
Hi Kohei,
On Tue, Oct 04, 2005 at 09:28:44 -0400, Kohei Yoshida wrote:
Thanks. I actually didn't realize that a BSD licensed code is
incompatible with ours.
It is, because of its advertising clause.
Just for a clarification, could I just take the same code which is BSD
licensed and
Hi,
Last year ;) Muthu Subramanian sent me a mail in which he asked whether
we're already working on specific issues he picked to work on. I asked
him to repeat the question on the mailing list because I want to keep
discussion public, but he didn't show up since. Nevertheless
I investigated the
Hi Sherrel,
On Sat, Aug 19, 2006 at 15:37:21 -0400, Sherrel D. Harris II wrote:
This is my first offer to volunteer for a programming project, so I am
not sure how to proceed.
First: welcome! :)
I noticed on of the items in the todo list is CSV import enhancements.
What type of
Hi Loiseleur,
On Wed, Aug 30, 2006 at 11:07:45 +0200, Loiseleur Michel wrote:
In that code, pFilterHtml and pFilterHtmlWeb are the two filters for
loading HTML files into Calc (normal HTML and WebQuery). Loading into
Writer/Web is done without executing any Calc filter detection code.
Hi Kohei,
On Sunday, 2006-10-01 11:57:36 -0400, Kohei Yoshida wrote:
The error message obviously calls for adding 'cliureversion.mk'
somewhere, but I'm not really sure where. Does anyone have a clue?
cliureversion.mk gets built in module cli_ure and is delivered to the
solver, you should
Hi Kohei,
On Thursday, 2006-10-05 21:55:07 -0400, Kohei Yoshida wrote:
menu items are controlled by the 'menubar.xml' file located in
sc/uiconfig/scalc. The question is, how do I conditionally exclude a
menu item from this xml file?
I may be wrong on this, but I don't think items can be
Hi Leonard,
On Tuesday, 2006-10-31 19:57:17 +0200, Leonard Mada wrote:
It's possible using ISERROR. One day, for compatibility, we'll need an
IFERROR-like function, which will also make such cases easier to handle.
Easier to handle sounds a little bit cynical. Here are the 2 search
Hi Leonard,
On Friday, 2006-11-10 17:13:00 +0200, Leonard Mada wrote:
unsigned int count = 0; // Counter for values
// DO WE NEED AN ??? fCount ???
Nah.. there won't be more than 2^32 matrix elements..
OR is (unsigned int) count OK
size_t respectively SCSIZE is preferred instead for clear
Hi Leonard,
On Friday, 2006-11-10 18:32:23 +0200, Leonard Mada wrote:
1. I forget a count++; in the first for LOOP
[inside the: if (!pMat1-IsString(i,j) !pMat2-IsString(i,j)) {} body]
2. because this count would be from 1 to n, the 2nd for LOOP should be
modified accordingly:
for(j
Hi Raghavendra,
On Friday, 2006-11-24 20:19:26 +1100, Raghavendra Rao wrote:
I'd like to help with the CSV import enhancements, what can I do?
Thanks for your offer, and welcome! Do you have any specific
enhancements in mind? We currently have at least these open issues and
requests for
Hi,
On Tuesday, 2007-03-06 10:37:03 +0100, Niklas Nebel wrote:
Please use IssueTracker for bugs (see
http://qa.openoffice.org/issue_handling/index.html).
Actually for non-members of the QA project a more comprehensible entry
page is at
Hi Kirill,
On Thursday, 2007-05-17 11:09:38 +0400, Kirill S. Palagin wrote:
One of our customers is greatly affected by the problem described in
http://www.openoffice.org/issues/show_bug.cgi?id=18728.
Is there a way of reducing the list or putting desired entry first in
the list (by way
Hi Muthu,
On Monday, 2007-05-28 21:51:39 +0530, Muthu Subramanian wrote:
I fixed i56202 in msba01.
[http://www.openoffice.org/issues/show_bug.cgi?id=56202]
Beside being on the wrong branch and needs to be resynced to SRC680,
as Niklas already mentioned, the CWS lacks the following
Hi Wojciech,
On Tuesday, 2007-06-05 02:07:15 -0400, Wojciech Gryc wrote:
Do I need to compile my add-ins in both Windows *and* Linux?
Yes, sure, executables compiled on/for one platform won't run on
another. That would only be possible if a package contained only
platform independent code,
Hi Kohei,
On Tuesday, 2007-06-05 14:46:55 -0400, Kohei Yoshida wrote:
With such changes, don't forget the file format. Filter settings are
saved, and we have to adhere to the specification about how they are stored.
Adding extra bits into the file format itself shouldn't be too hard.
Hi Wojciech,
On Tuesday, 2007-06-05 21:25:21 -0400, Wojciech Gryc wrote:
But for old add-ins, which are
only registered as service implementations, there is no such
notification, and you have to restart the application so the list is
updated.
Ah, makes sense! You're perfectly correct: I
Hi Leonard,
On Thursday, 2007-06-14 00:04:36 +0300, Leonard Mada wrote:
[I think there is some confusion here, see next paragraph.]
Basically, you cannot set a default *value* for the cell content. [see
later for usefulness]
You talk about _content value_ here
A. I still feel that NO-one
Hi Alan,
On Thursday, 2007-06-21 17:42:53 +0200, Alan Yaniger wrote:
over a million rows. What
is involved in implementing this feature in Calc? I'd like to look
into working on this, if it's manageable.
Niklas mentioned some obstacles. To hack up a test build see
Hi Muthu,
On Thursday, 2007-06-28 20:07:47 +0530, Muthu Subramanian wrote:
I have committed my changes to msba02 (based on src680-m212).
I wonder why you created the CWS based on m212, which is several weeks
old now, instead of using a more recent milestone. Already when we
talked about using
Hi tangquanfa,
On Thursday, 2007-06-28 16:30:13 +0800, tangquanfa wrote:
About issue 70277# has been fixed. I have attached the patch to the
issue70277#, please
check
Please see my answer in the issue's comment.
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n
Hi Muthu,
On Thursday, 2007-06-28 22:35:25 +0200, Eike Rathke wrote:
The problem now is that probably the cws won't be QA'ed in time anymore
before feature freeze of OOo2.3, which is 5th of July. Especially if it
has to be resynced again to a recent milestone.
I'm currently evaluating what
Hi,
On Friday, 2007-06-29 14:32:22 +0200, Eike Rathke wrote:
we'll do another
build with your changes included if appropriate.
Just a status update: it's on its way.
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
OpenOffice.org Engineering at Sun
Hi Noel,
On Monday, 2007-07-02 12:00:12 +0100, Noel Power wrote:
Finally go a chance to apply the changes from the cws and glad to say
these changes don't seem to affect the tests that I have :-)
Would changing the flags set in ScRange::ParseCols() and
ScRange::ParseRows() have an effect? It
Hi Regina,
On Thursday, 2007-07-05 10:34:37 +0200, Regina Henschel wrote:
For COVAR it looks like this (based on OOF680_m18):
Very nice, indeed. Could you do us a favor though and base your changes
on a recent SRC680 milestone (latest available now is m219) instead of
OOF680, chances then are
Hi Regina,
On Thursday, 2007-07-05 13:06:15 +0200, Regina Henschel wrote:
recent SRC680 milestone (latest available now is m219)
m219 is not on the mirrors and I have used CVS not yet. The m218
tarballs are available on the mirros. I would then have to do another 18
hours build. I own
Hi Leonard,
On Thursday, 2007-07-05 20:58:02 +0300, Leonard Mada wrote:
A spreadsheet with ALL functions defined inside the interpr*.cxx files
can be downloaded from:
I don't see what that should be good for. Developers working on the code
preferably have tools that dynamically create
Hi Kohei,
On Friday, 2007-07-06 11:55:43 -0400, Kohei Yoshida wrote:
On Fri, 2007-07-06 at 17:39 +0200, Niklas Nebel wrote:
Kohei Yoshida wrote:
How about making it invisible?
Property IsVisible. But in fact there is a problem: You can't set the
sheet's name to what it would be
Hi Frank,
On Thursday, 2007-07-12 10:03:07 +0200, Frank Stecher wrote:
for now I can't. Neither the French version nor the Russian one. WIll
try it again.
Please also try with different OOo locale settings and Windows regional
settings and time zones.
Thanks
Eike
--
OOo/SO Calc core
Hi Leonard,
On Monday, 2007-07-16 09:37:40 +0200, Leonard Mada wrote:
The reason is, that the page looks already too cluttered and I would
like to reorganise slightly the information. In this respect,
I consider that it becomes imperative to move some of the content to
a new page. I think of
Hi tangquanfa,
On Monday, 2007-07-16 16:46:48 +0800, tangquanfa wrote:
I commited a patch about issue60590,please check it!
I don't think that was the correct approach. First, what was the reason
that the file could not be loaded? Then, by changing the LOTUS_EOF
define from 0x01 to 0x08
Hi os-yunjingtao,
On Monday, 2007-07-23 10:59:48 +0800, os-yunjingtao wrote:
Does 'c' have any special
meaning when we name something or Is 'c' related to any convention in
R1C1
As the name R1C1 reference style may suggest, the C stands for column
as R stands for row. A reference R1C1
Hi Alan,
On Tuesday, 2007-07-31 18:13:51 +0300, Alan Yaniger wrote:
Where can I find the code which displays a dropdown list box containing
valid values for a cell?
source/ui/view/gridwin.cxx ScGridWindow::DoAutoFilterMenue(), data
obtained via ScDocument::GetDataEntries(). Note that the
Hi yunjingtao,
On Thursday, 2007-08-02 10:53:08 +0800, yunjingtao wrote:
2.View-Toolbars-Form Controls
3.Design MOde On/Off-Check Box-Text Box-Push Button-List Box-...
4.You can find that all the icons are on at the same time.
I'm not quite sure I understand what you're referring to. Do you
Hi yunjingtao,
On Thursday, 2007-08-02 11:49:44 +0800, yunjingtao wrote:
2.input letters at the end of any row
3.select any cell except the row that has letters
4.click right button-Insert Cells-Shift cells right-OK
5.it will warn you that filled cells cannot be shifted beyond the sheet.
Of
Hi Max,
On Tuesday, 2007-07-31 21:55:18 +0200, Max Giesbert wrote:
The constructor gets a XComponentContext passed over. Now how do I get
the XComponent of the actually opened spreadsheet from it?
XComponentContext is not related to the current application or
documents. It provides
Hi Wojciech,
On Thursday, 2007-08-02 22:48:32 -0400, Wojciech Gryc wrote:
I'm very happy with this version because it features a new (and probably
final major user interface addition) coding window... Now you can write R
code and get various properties inserted directly into the spreadsheet.
Hi Oliver,
On Sunday, 2007-08-05 13:42:07 +0200, Oliver Brinzing wrote:
everything works fine, but if i change to the print preview *and* back to the
sheet, oo crashes ...
any hints ?
No, but crashing surely is a bug. Please file an issue.
Thanks
Eike
--
OOo/SO Calc core developer.
Hi Jonathan,
On Monday, 2007-08-06 16:45:13 -0400, Jonathan Pryor wrote:
Unfortunately, the obvious way of doing this mapping would be to add
constants to the FilterOperator enum in
offapi/com/sun/star/sheet/FilterOperator.idl, and changing this file
breaks my build because it breaks the ABI
Hi gaozm,
On Wednesday, 2007-08-08 16:11:52 +0800, gaozm wrote:
Here is a compatible problem between Calc and Excel, it can be described
as follows: Open a Excel document who contains only one whole page(47 rows
and 9 columns) with Calc, it will show two pages.
I hope it shows only one
Hi Frank,
The spec
http://specs.openoffice.org/calc/ease-of-use/Enhanced_Formula_Input.odt
for issue http://qa.openoffice.org/issues/show_bug.cgi?id=20496 states:
++ Number Formula: =++Number
Why should a leading ++ trigger conversion to formula?
-- Number Formula: =--Number
Again, why
Hi Leonard,
On Thursday, 2007-08-09 20:51:26 +0300, Leonard Mada wrote:
Excel converts +number+number to =number+number and ++number
to =+number, but converts +name to =+name
Note that Excel does not convert single numbers like +1 or -1 but does
convert ++1 to =+1, --1 to =--1, +-1 to =+-1
Hi Wojciech,
On Wednesday, 2007-08-15 23:15:33 -0400, Wojciech Gryc wrote:
After playing around some more, I figured out the problem (dealt with
getting the services correctly). Just to let everyone know, I added
information on how to embed images in a Spreadsheet (rather than link to
them)
Hi gaozm,
On Wednesday, 2007-08-15 14:08:12 +0800, gaozm wrote:
2. Input characters into any column,for example between a1 and a21 input
figures from 1 to 21
3.Select the whole column a1,data-filter-standard
filter,condition-smallest %; value-10; ok
Result: It will show 3 rows.
Hi Takashi,
On Tuesday, 2007-08-21 13:45:53 +0900, Takashi Nakamoto wrote:
3) Store that as a cell attribute. If I understand correctly, Writer
uses this approach.
That sounds easiest from a first glance, but it dissects content into
attribution, which sooner or later will
Hi Leonard,
On Wednesday, 2007-08-22 21:20:49 +0300, Leonard Mada wrote:
- The dialog txt files aren't found without strange CLASSPATH settings.
- On Windows, R doesn't seem to like the backslashes in the path to
the jpeg file. Replacing them with forward slashes seems to work, I
didn't
Hi Leonard,
On Tuesday, 2007-08-28 21:42:06 +0300, Leonard Mada wrote:
8.) CalcStaR = Calc statistics with R
I like that one. Quite in the spirit of StarCalc.
The current RCalc is fine too, but overlaps with others, e.g. rCalc
http://rcalc.sourceforge.net/ a scientific calculator for the
Hi,
I'm back from vacation. In case you sent mail to the lists or to my
personal account(s, if sent to [EMAIL PROTECTED] or [EMAIL PROTECTED] you
should had received a vacation notification, if sent to [EMAIL PROTECTED] you
did not, see .signature below) or comments on issues that need my
Hi Leonard,
On Friday, 2007-10-12 00:06:19 +0200, Leonard Mada wrote:
There were some interesting suggestions. The most tempting one is in my
opinion: R4Calc.
Looks good.
http://ux.openoffice.org/servlets/ReadMsg?list=discussmsgNo=807
proposes much longer names; I am not sure that these
Hi Cor,
On Thursday, 2007-10-18 11:38:21 +0200, Cor Nouws wrote:
Frank Stecher wrote (18-10-2007 10:03)
The problem is the unsorted search vector used with the VLOOKUP
functions in column H. Excel requires a sorted search vector for the
vlookup as used in the column as well as Calc do.
Hi Noel,
On Tuesday, 2007-10-23 12:32:25 +0100, Noel Power wrote:
yes you are right, I am just passing SCA_VALID as the nMask so I didn't
see this. Given if we change this there is a possibility that someone
somewhere depends on the full set of range flags being set
do you mean either
Hi YunJingtao,
On Tuesday, 2007-11-13 16:33:44 +0800, YunJingtao wrote:
A patch for i71814 was submitted.Check it! I don't know whether
it's satisfied, if not, please give some advice.
It would be nice if you not just attached some patch to the issue but
also explained what your
Hi maoyg,
On Wednesday, 2007-11-14 12:59:20 +0800, maoyg wrote:
I have sent the mail to [EMAIL PROTECTED] and I also created the wiki page:
http://wiki.services.openoffice.org/wiki/Page_margins.
What purpose is the wiki page meant for?
Eike
--
OOo/SO Calc core developer. Number
Hi maoyg,
On Thursday, 2007-11-15 10:20:13 +0800, maoyg wrote:
I created the wiki page because I want to put Page_Margins_Specification on
it.
Ah, I see, you uploaded the specification document to the wiki as well.
Ok, as this is about drafting a Calc feature I just moved the page to
Hi YunJingtao,
On Thursday, 2007-11-15 17:13:34 +0800, YunJingtao wrote:
aLogicEdit is to show the area of hyperlink with mouse,when the text is
beyond the cell border, border of aLogicEdit has to be coordinated with cell.
the coordinates of text and mouse are different, and it leads to
Hi gaozm,
On Thursday, 2007-12-06 17:11:46 +0800, gaozm wrote:
You have added 3 issues to the wiki, but some of them are the same as our
featrue, for example: Empty and Non-Empty conditions in AutoFilter and so on.
That's why I added the issues, because they touch the same topic.
Hi Cor,
On Tuesday, 2007-12-04 21:49:26 +0100, Cor Nouws wrote:
I can't find any spaces in the HTML.
Not even in the raw HTML source? Note that there are several kinds of
blanks, even non-spacing blanks that you won't see in a browser display
but may get transformed into usual blanks when
Hi Lvyue,
On Monday, 2007-12-10 15:31:26 +0800, Lvyue wrote:
I have submitted a patch for issue 38759.
Please see my answer in the issue's comments.
If you need some help or there's anything to clarify please write to the
mailing list. Btw, when starting a new topic please don't reply to
a
Hi Kohei,
On Friday, 2007-12-07 10:09:50 -0500, Kohei Yoshida wrote:
The rough idea I've just come up with is to do what web applications do:
provide a date input box. This way Calc also knows that the user is
about to enter a date, and try not to even parse an input as a date if
the date
Hi Leonard,
On Monday, 2007-12-10 00:19:55 +0200, Leonard Mada wrote:
Aloow the user to specify, what should be interpreted as a date (and how).
E.g., IF the user specifies that dates are only strings of the form:
dd.mm.yy or dd.mm., then only such strings would be converted to dates
Hi gaozm,
On Friday, 2007-12-07 17:06:36 +0800, gaozm wrote:
I'm glad to hear that, so we should continue discussing the spec. with
UX, right?
Yes.
But now, we have not get any feedback about this featrue from UX.
I want to know how can we get their replies, and now what should we do
Hi Lvyue,
On Tuesday, 2007-12-11 10:35:18 +0800, Lvyue wrote:
I want to ask if there is no numeric value, but string value in a cell, range
or matrix, should MIN/MAX return 0?
Yes. Only if there are no other numeric values that would result in
a different min/max, of course. Short
Hi Lvyue,
On Tuesday, 2007-12-18 15:20:21 +0800, Lvyue wrote:
I have submitted the third patch, please check it.
Better, but not to the point. Maybe there's still some misunderstanding
about what the outcome should be. With the patch the function currently
treats bEmptyCells=true if already
Hi Cor,
On Tuesday, 2007-12-11 09:05:10 +0100, Cor Nouws wrote:
How about problems when entering by key board?
If those are rare, maybe an option to turn of auto-date by
importing/pasting is enough?
There are enough complaints that when entering 1.2 in a locale where the
dot is not the
Hi Muthu,
after xmas vacation..
On Monday, 2007-12-24 14:40:49 +0530, Muthu Subramanian wrote:
I was contemplating on looking at this issue.
I saw that the issue was assigned to requirements - is it ok if I look
at it?
Sure.
(I mean, since the requirements might not be clear as yet).
Hi Lvyue,
On Monday, 2008-01-21 10:20:57 +0800, Lvyue wrote:
I submitted a patch for issue71158 on last Friday.
Sorry, I forget to tell you.
No need to be sorry, and no need to explicityl notify me (of course you
can if you wish), as submitter/owner/CC of an issue get an automatic
Hi Regina,
On Thursday, 2008-01-31 12:57:35 +0100, Regina Henschel wrote:
I'm working on issue 15090
Yes, I received a mail from IZ on your comment saying so, thank you!
(1)
The error result for Nper=0 is not implemented yet. I have seen
SetError(errIllegalArgument), SetIllegalArgument(),
Hi Regina,
On Sunday, 2008-02-03 01:27:55 +0100, Regina Henschel wrote:
a remark on the ODFF-spec:
The parameter 'PaymentType' has got type 'number'. In the description only
the values 0 and 1 are mentioned. But there is no constraint to {0;1}. The
description doesn't say what to do with
Hi Kohei,
On Monday, 2008-02-11 10:37:05 -0500, Kohei Yoshida wrote:
I just had a minor build issue on Linux with gcc 4.1.2. The attached
patch fixed it.
Thanks, I applied that to the CWS.
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign
Hi,
On Monday, 2008-02-11 12:56:00 +0100, Eike Rathke wrote:
the filters aren't essential anyway.
This if course was not meant to misclassify Daniel's great work! The
filters are just not needed for the area Regina works on.
Sorry if that could had been mistakable..
Eike
--
OOo/SO Calc
Hi Lvyue,
On Wednesday, 2008-02-20 14:19:13 +0800, Lvyue wrote:
In Excel:
Negative will cause error, no matter how small it is.
I have tried -1.00E-307, GCD still return err.
And in Gnumeric:
The handle of negative is the same to Excel.
Shall we be consistent with them, or keep our
Hi Lvyue,
On Friday, 2008-02-22 15:37:42 +0800, Lvyue wrote:
About i86171, I find 7 functions using bTextAsZero.
They are MIN, MAX, AVERAGE, VAR, VARP, STDEV and STDEVP.
They all have the same result as MINA(range)=MIN(range),
and it's not right.
As expected..
I made some change, and
Hi Yue,
On Wednesday, 2008-03-05 11:00:37 +0800, Lvyue wrote:
I have made a little change on issue86643.
now COUNT() can ignore errors, and give correct count of numbers.
See also the comment I added to the issue.
but I found it ignores all errors.
for example, if the cell A1 has a formula
Hi Regina,
On Monday, 2008-03-10 18:15:29 +0100, Regina Henschel wrote:
significant digits. I looked around for some better coefficient and
found them in Apache Library
Are we allowed to use this values?
You mean to use only the coefficient values? I have no idea whether
coefficient values
Hi David,
On Monday, 2008-03-17 21:23:07 +, David King wrote:
On the other hand ;) in Calc {=ISLOGICAL({TRUE;cat;dog})}
returns {FALSE;TRUE;TRUE}
Can I raise that one as an issue? Can't be right, can it?
That indeed is a bug, please file an issue.
Thanks
Eike
--
OOo/SO Calc
Hi Kohei,
On Monday, 2008-03-17 21:23:11 -0400, Kohei Yoshida wrote:
[... separators at ScAddress::Convention ...]
Well, that code was implemented before ScGrammar arrived in DEV300_m2.
So, I couldn't have used ScGrammar at the time I implemented.
Understood.
Of course now that we have
Hi Kohei,
On Tuesday, 2008-03-18 14:13:43 -0400, Kohei Yoshida wrote:
I'd like to make sure one thing before I go with this. It seems to me
that, if we tie the separators to ScCompiler::mxSymbolsNative, then it
will not be possible to switch between the Excel style separators and
the
Hi Yue,
On Tuesday, 2008-03-18 15:07:56 +0800, Lvyue wrote:
I began to work on issue78781 yesterday.
Fine, thanks.
Compared with Excel, I found there are two things I should modify.
1. while input: =INDEX($D$27:$P$27;2)
the result should be value of E27.
Correct. For a row vector the
Hi Mathias,
On Tuesday, 2008-03-18 13:28:25 +0100, Mathias Röllig wrote:
Should using labels work also in a array formula?
Today it doesn't.
Indeed, that's an error. In array context using a label should not
generate a position dependent reference. Probably correct would be to
generate an
Hi Kohei,
On Tuesday, 2008-03-18 18:19:01 -0400, Kohei Yoshida wrote:
I said what I said because the code looked like once the symbol maps are
initialized at start-up they don't get modified during run-time.
Up to now they weren't, it wasn't necessary.
But I
guess I could change it to make
Hi Kohei,
On Wednesday, 2008-03-19 01:03:02 -0400, Kohei Yoshida wrote:
Just finished. Now I don't use ScAddress::Convention all over the place
but simply put the localized separators in the mxSymbolsNative and
mxSymbolsEnglish.
I'm not sure if we really want that in mxSymbolsEnglish.
Hi Kohei,
On Wednesday, 2008-03-19 09:27:11 -0400, Kohei Yoshida wrote:
Well, if it's not used in the UI, I guess we can leave the English
symbols alone. I'll change the implementation.
Btw, please don't use direct bit operations on the grammar value:
if ((eGrammar
Hi maoyg,
On Thursday, 2008-03-20 17:16:25 +0800, maoyg wrote:
In suggestion 8,they want to add a down arrow(↓).
Whatever encoding you used to insert that character, your mailer didn't
declare it, so I just see a sequence of garbled characters. Assuming
that's utf-8 it indeed would be a
Hi JoJo,
On Thursday, 2008-03-27 13:40:19 +0530, JoJo jojo wrote:
How to run OO.o calc (from 2.4.0, windows) without installing it ?
You can't.
sort of like
http://portableapps.com/apps/office/openoffice_portable
only *.exe installers are available for download.
The installer is to be
Hi Regina,
On Tuesday, 2008-04-08 15:24:33 +0200, Regina Henschel wrote:
Therefore the constraint should be
N in setR setminus setZ sup{=0}
(use OOo Math to see the formula)
Thanks, I just gave the ODFF-SC a heads-up on this.
Eike
--
OOo/SO Calc core developer. Number formatter
Hi Niklas,
On Monday, 2008-04-14 16:53:53 +0200, Niklas Nebel wrote:
=LOOKUP(6.1;[.B51:.B57];[.C51:.C57])
I believe the correct result there is 19, not 11. DEV300_m5 gives 19.
Did you enter the formula in a locale where 6.1 is parsed as a date (with a
value larger than those from the
Hi YunJingtao,
On Tuesday, 2008-04-15 09:43:32 +0800, YunJingtao wrote:
hi, Daniel
As you Cc'ed Daniel's personal account I assume that he answered
directly, as usual. However, for transparency I'd prefer if people
didn't Cc personal accounts if the receiver reads the mailing list
anyway, in
Hi Cor,
On Thursday, 2008-04-17 10:10:19 +0200, Cor Nouws wrote:
Easy to fix as you suggested. Only saving as xls and re-opening, again
shows #NA ...
Saving as ods does save the results.
It seems that interim results of external references aren't saved to
Excel file format. Daniel?
Eike
Hi Leonard,
On Tuesday, 2008-04-29 22:54:02 +0300, Leonard Mada wrote:
1.) AUTOMATIC DATE RECOGNITION
I strongly support modifying this behaviour in a short timeframe and
implementing a date input-mask, where every user can accurately direct OOo
as to what input is a date (e.g. only
Hi Yue,
On Tuesday, 2008-05-06 15:59:29 +0800, Lvyue wrote:
I will attach a patch on i46681, which only changed a few functions,
including ScIfJump(), JumpMatrix(), ScMatRef(), MatAdd(),
ScMatrix::Get() and ScMatrix::GetDouble().
See your IRC log from today ;-)
and another thing is that,
Hi Leonard,
On Friday, 2008-05-02 00:26:50 +0300, Leonard Mada wrote:
2.) TEXT-vs-NUMERIC
Let's ask a simple question:
I cannot hide my disappointment that no one did try to answer these
questions.
Well, your previous mail was dated May 1, I don't know about your
country, but in Germany
Hi,
I'll be on vacation until May 28, please have patience.
Thanks
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412
OpenOffice.org Engineering at Sun:
Hi Regina,
On Sunday, 2008-05-25 18:58:20 +0200, Regina Henschel wrote:
SetError( errNoConvergence);
[...]
if (nGlobalError)
OK, that's clear. I have used it now in the gamma function and it works.
But what to do, if I detect a NoConvergence in a function, that is not
member
Hi David,
On Wednesday, 2008-06-25 20:55:12 +0100, David King wrote:
Say we have A1:C1 = {7|6|5}
In cell A2 we enter, as an array formula:
=PROB({5;6;7};{0.2;0.3;0.5};A1:C1)
and, correctly, A2:C2 = {0.5|0.3|0.2}.
Now in cell D4 we enter, as a normal (non-array) formula:
Hi Regina,
On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote:
I'm working on BETADIST. For certain inputs my version of that function
returns a value, which is near to 1. The formula in the cell is
=BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result
Hi Yue,
On Thursday, 2008-06-26 16:56:14 +0800, Lvyue wrote:
Really long time no see. :)
Our network ultimately works today :-/,
and I was sorry that we can not talk on IRC.
No problem. We'll meet again next week. If you feel the need to discuss
things in between, we could arrange some day
Hi Niklas,
On Thursday, 2008-06-26 14:30:11 +0200, Niklas Nebel wrote:
Eike Rathke wrote:
On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote:
I'm working on BETADIST. For certain inputs my version of that
function returns a value, which is near to 1. The formula in the
cell
1 - 100 of 202 matches
Mail list logo