Kohei Yoshida wrote:
In this blog entry by well-respected Mr. Tenhumberg
http://blogs.sun.com/roller/page/dancer/20050404#just_switch_staroffice_add_in
near the end of the article, there is a mention of a statistical tool
that is used within Sun. I hope I'm not being too nosy, but is this
Sander Vesik wrote:
how do I get the value of a cell to be +INF / -INF? the obvious way doesn't
work :(
Infinity isn't supposed to be in a cell. An infinite result from a
formula is considered an error, and the error message (Err:503) is
shown. Issue 47724 exists to distinguish between
Kohei Yoshida wrote:
All went well, but now I need to make some arguments in some functions
optional, by providing a default value for them. How do I do that?
Do I do it in the IDL definition, or in one of those overloaded member
functions of com.sun.star.sheet.XAddIn ?
In the IDL. Among an
Lakin Wecker wrote:
I assume these discrepancies are the result of caching formula results.
The assumption is that Excel stores the previously calculated results of
the formulae in the spreadsheet and uses these values at load time,
while OO.o ignores these and fully recalculates the formulae on
M. Fioretti wrote:
a couple of months ago I asked about this:
http://www.mail-archive.com/dev@sc.openoffice.org/msg00139.html
I just wanted to ask is there has been any news about this (especially
openformula adoption) and where I could read it. Any comment is
obviously appreciated.
I
Daniel Miller wrote:
As I close out the last week of the summer of code, I have finished the
test cases, deployed them in the code and rendered results. I am
finishing up the final documentation to hand in to my mentor Niklas by
Tuesday. If you have any comments or questions on this project
Hi everybody,
I have put a file possible performance improvements.sxw into the
Performance folder under
http://sc.openoffice.org/servlets/ProjectDocumentList.
It lists a few improvement ideas for loading and saving files in Excel
XLS as well as our own format. This was collected last year,
Eike Rathke wrote:
Not sure if this is related to this formula standardization issue, but
would such a standardization address the argument separator
inconsistency i.e. ',' vs ';' ?
Note that OpenFormula is about the file format, no the representation in
the UI.
The draft does have a section
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. If that is the case then there is already a standard, MS
Excel. Given the complexity and prevalence of it's evaluation
Kohei Yoshida wrote:
Also, refer to Niklas's comment on this list a while ago:
http://sc.openoffice.org/servlets/ReadMsg?list=devmsgNo=1598
So I might as well give a little update on some items from that list:
- Access to simple (non-formatted) cell content has been changed to
direct calls,
Kohei Yoshida wrote:
What's the latest word on natural sort? Will this feature ever stand
a chance for integration?
http://qa.openoffice.org/issues/show_bug.cgi?id=26565
With UI changes and file format extension, that seems to be something
for the next major version (3.0, or whatever it
Kohei Yoshida wrote:
Thanks for letting me know. Would, myself creating a CWS and having
someone QA it help take some load off your shoulder, or not really?
Just a hypothetical scenario, as I don't know if I could find an
appropriate QA personnel... But just a thought.
Last 2.0.1 CWS
Norm Byers wrote:
Dear Sirs,
Long ago, in a galaxy far away... I was the developer of the Saturn-Calc
Spreadsheet application for the PDP-11 (RT-11,TSX,RSX,RSTS O/S), VAX (VMS),
and PC (DOS only). Though a couple of $million worth were sold it met its
demise with the demise of DEC and the rise
Pablo Rodríguez Rey wrote:
We hope if your team have any time you can make a WQ1/WB3 Quattro Pro
file format importer from Corel WordPerfect Suite v6,7,8. We have a
lot of documents in this format and we are trying to upgrade to
OpenOffice 2.0, but this characteristic is basic for us.
A
Oliver Brinzing wrote:
it seems, the text:span text:style-name=T1/ has been removed, T1 was:
style:style style:name=T1 style:family=text
style:text-properties fo:language=de
fo:country=DE/
/style:style
is it a change or is it my fault,
JC Helary wrote:
Neither in Excel nor in Calc are the linked files/sheets originally
displayed. I am only translating the displayed information in the
files, I am not the creator so I don't know what was the purpose of
linking the tables in the first place.
It's a hidden sheet. You can
JC Helary wrote:
You mean that OOo considers a line break to be a paragraph in any
context ?
|You mean that |
|OOo considers |
|a line break to |
|be a paragraph |
|in any context ?|
Here my whole box uses the same style for each of the line break
JC Helary wrote:
|You mean that |
|OOo considers |
|a line break to |
|be a paragraph |
|in any context ?|
I was wondering why OOo considers the necessity to convert a line break
to a series of paragraphs in the context of a shape (is that what text
Terry North wrote:
I'm not a programmer but I've been using spreadsheets
for a long time, including Lotus, which went through a
number of changes. I hope that reading this does not
take too long, if my suggestion has no merit.
Sorry for the late reply. It's good to see some suggestions,
Laurent Godard wrote:
reading some press article, it is claimed that the next xls monster will
handle 1 000 000 of lines and thousands of columns
i think it is ridiculous but for a end-user point of view it will be a
difference. And communication by microsoft seems to oriented in this
Laurent Godard wrote:
MAXCOLCOUNT_DEFINE, but I'm not sure if all code that deals with
column names can handle more than two letters.
yes i found it (was not so hard ;-) )
i'll try and see for the letter support
a pointer on the source where to do handle it ? (well, optional)
The code in
Kohei Yoshida wrote:
On 3/6/06, KamiHír [EMAIL PROTECTED] wrote:
As you probably know I am not a programmer, but I would like to add one
small functionality to SC.
If you click twice on first field ofWriter's statusbar the Navigator
shows up. You can not start the navigator same way in Calc. I
jim wrote:
(e) What is the solution?
This is a matter of opinion. My view is that an improvement for one type of
case is a step forward, and it does not matter if other cases remain as they
are now.
We know about the case when drag or copy is done from a single row, onto a
range of filtered
Alexandro Colorado wrote:
Is it possible to make a live spreadsheet, meaning that the content of
the cells are provided by a live XML feed from an APi. The idea is to
have stock charts/currency exchange/ and/or pricing of products directly
inserted into a Calc spreadsheet and users can add
eric ehlers wrote:
how do i troubleshoot problems with OOo calc loading a custom addin
(DLL) from the program directory?
on my old windows machine i have an addin which successfully compiles
under VC6 and loads into calc version 1.1.
on my new windows machine i take the same source code and
Oliver Brinzing wrote:
I have a problem using cut paste on non protected cells (input area) on
password protected sheets:
Example:
A user insert values into non protected cells to do some calculations.
The sheet is password protected, the user can not change the formulas.
Now the user uses
Niklas Nebel wrote:
less than an hour after the suggestions were published
Er, forget about that part (times listed in too many different time
zones)...
Niklas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Oliver Brinzing wrote:
maybe i am blind, but i am looking for a simple way to stop the cell editing,
if a user presses a control element (for example an ok button)
background:
the users has to insert values into some spreadsheet cells.
after that he has to press a button to do some calculation
Vagmi Mudumbai wrote:
I have recently moved my laptop into the all unix world with Ubuntu. I
am now participating in a Management course. Lot of the quantitative
techniques demostrated use the solver addin for Excel. I was surprised
that I could not find a relevant component in Calc. Alhough
Oliver Brinzing wrote:
yes, i can do so, but i think it's just a workaround ...
what about an interface with the following methods
isCellEditable()
isEditing()
startCellEditing()
stopCellEditing()
cancelEditing()
Is there any deeper meaning to the inclusion of Cell into only some of
the
Oliver Brinzing wrote:
No, i had a look at some java classes (javax.swing.AbstractCellEditor,
javax.swing.plaf.TreeUI,...) and found a mixture of names indeed
i would prefer the method names without Cell ...
Which might lead to the expectation that editing of text in shapes is
included,
Kohei Yoshida wrote:
I've uploaded a new snapshot of Calc Solver to my website. The
difference from the previous snapshot is mainly to combine the two
separate UNO packages into one, by statically linking to lp_solve, and
removing some preprocessing of models which prevented lp_solve from
Kohei Yoshida wrote:
The static linking is done only for the standalone UNO package that is
to be distributed outside OO.o (i.e. via my personal website). I
would think this should pose no problem since my UNO package is
distributed separately from the main OO.o build.
As far as integration
Kohei Yoshida wrote:
My question is, is it possible to disable repainting of cells while
their data are being modified? Something like:
disableCellUpdates();
convert models
enableCellUpdates();
would be the most desirable, but I'm not sure if such API exists.
You can use lockControllers /
Gerrow, Darryl wrote:
I am looking to contribute to the projects of:
*- OpenOffice.org Calc: Validation of spreadsheet functions*
*- OpenOffice.org Platform Technology: Layout Manager Widget*
Please let me know how I can join and help in these projects. Thanks.
Validation of spreadsheet
Oliver Brinzing wrote:
IMHO this should be treated as a bug, cause the linebreak char is
changed into a space (code 32) ...
The first cell doesn't contain a line break character. It contains two
paragraphs.
Niklas
-
To
Oliver Brinzing wrote:
this is true, if one acesses the cell via basic getString() method ...
' result: 10 - ok
but if one uses a formula
=CODE(TEIL(A1;6;1))
the result is 32 ... :-(
Sure, different interfaces for different uses. This by itself is not a
problem and was done on
Leandro Silveira Monteiro da Silva wrote:
My name's Leandro Silveira and I'm a Brazilian computer programmer just
trying to find something nice to do.
While visiting OpenOffice.org website, I got interested in doing some
contributing work.
That's great.
Actually, the task below interested me
Sven Verleyen wrote:
1. I have a little table with 2 collumns and 8 rows, in that table is
the legend of something in my spreadsheet. So I want to so that legend
when I scroll down the page.
So the idea is: the ability to block a few cells.
You mean something like Window/Freeze, but not for
Morgan Stefik wrote:
I am writing to request an OO.org Calc feature. There is no ability
to plot multiple data sets in an XY plot. In order to do this
currently one would have to merge the X lists and space the Y values
in the appropriate columns. There should be an ability to select
multiple
Peter Eberlein wrote:
is the method sort on a xRange restricted to max 3 columns (as in the GUI)?
If I specify 6 TableSortFields and run the method, it seems, that
MaxFieldCount is always 3 and a readOnly property.
Yes, it's the same limitation.
Niklas
Peter Eberlein wrote:
is there an issue about that? At least a note in the DevGuide would be
useful.
For more sort fields, there's issue 10933.
The IDL description for MaxFieldCount in the sort descriptor says
contains the maximum number of sort fields the descriptor can hold.
By contrast
Oliver Brinzing wrote:
is it possible to access the cipher api for en-/decrypting calc password
protected sheets/documents ?
No, not directly (you could create a hidden document, protect a sheet,
save the file and extract the hash, or something like that).
Niklas
Leonard Mada wrote:
I was wondering what coding algorithm does Calc use when implementing
the various statistical functions?
REASON
===
Although different formulas are mathematically identical, they give
different *error estimates* when coded on a computer.
EXAMPLE
The variance
Hi,
Some people complain that a large number of Calc patches is piling up at
ooo-build and we at Sun are ignoring or delaying them. To counter this
impression, we (the core Calc team at Sun) went through the Calc section
of the list at http://go-oo.org/ooo-build/patches/src680/apply, and
Alan Yaniger wrote:
Thanks for your suggestion. I added a function in output2.cxx to extend
the default alignment handling, call it when necessary, and it works
great. There's still a problem, though. When I edit a field by pressing
F2 or clicking on the string in the input window, the
Alan Yaniger wrote:
Is this the way to get the text direction value if I want to change it ?
To change the value, I've been trying to use the function, for example:
pItem.PutValue( FRMDIR_ENVIRONMENT, ATTR_WRITINGDIR );
but I'm getting the compiler error:
cannot convert 'this'
Kohei Yoshida wrote:
Issue 35579 - sc-standard-filter-options.diff
Issue 26565 - sc-natural-sort.diff
I'm fully aware that the reason why the file format needs to be
extended in order for these patches to be included is because the
state of their corresponding UI control (i.e. checkbox, combo
Leonard Mada wrote:
Exactly this is the problem. It returns an *ERROR*, so searching for
string 1 OR string 2 will fail grandiosely. Actually, it is
impossible to perform this search in calc. This is a *BUG*. (the full
comments can be found for issue 66590)
It's possible using ISERROR. One
Leonard Mada wrote:
I entered in column B(1): =A1 + 1, that is I added the value 1 for
every element in column A. That said, data values in columns A and B
should be totally correlated. The NIST accepts a value of -0.999, but:
They don't accept a value of -0.999 instead of 1, they just
Leonard Mada wrote:
Mind if I ask, in which file is the CORREL function defined?
Tests are still useful to see where the algorithm fails (and
purportedly, the new algorithm should be correct). Extensive test cases
are always welcome.
sc/source/core/tool/interpr3.cxx, method
Alan Yaniger wrote:
Question 1:
To align the names in the function list, I added following to
ScFuncPage::UpdateFunctionList() :
if (ScGlobal::IsSystemRTL())
aLbFunction.EnableMirroring( );
Is this the best way to do it?
That would mean double mirroring, the flag wasn't
blueeagle wrote:
We are RedOffice team.there is some bugs that we found in the OOo2.1.
If you find bugs, please file them in IssueTracker, see
http://qa.openoffice.org/issue_handling/index.html. On the mailing
lists, there may be some discussion, but unless a bug is filed, it will
be forgotten
Guido Ostkamp wrote:
(*) This is _not_ one of the typical we want numbers erroneously
formatted as text to be still treated as numbers as in Excel questions
as handled in many issues like #5658 etc.
It's related. The error that others show is from failure to convert to a
number. Our approach
Kirill S. Palagin wrote:
Issue http://www.openoffice.org/issues/show_bug.cgi?id=51564 describes
important functionality that is missing in our product - competing
product has this functionality and it is widely used by users. The issue
has generated a significant interest among our users -
Hi everyone (including those who bring this up on wrong irc channels),
Here's a quick overview on what I have in mind for the API to allow the
OOX import component to handle formulas:
1. The cell will have a new interface XFormulaTokens or something,
with methods
* sequenceany
zhaosheng wrote:
I have sent a email to you with the file, did you receive it?
No, I only got the mail from the mailing list (don't know why).
Niklas
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Hi,
A first version of the formula API is now in the cvs for the
xmlfilter02 CWS.
Because much of ScToken's functionality is needed only within the
context of the RPN code used for calculation, and this new API only
deals with the non-RPN code, it can be simpler than in the previous
mail.
zhaosheng wrote:
I have sent a email to you with the file, did you receive it?
I got it now, and I see it's also attached to issue 75673.
Keep in mind that the header has a Height and a Spacing setting. The
line in your screenshot seems to be at the sum of both. Which one is
supposed to be
Erich Neuwirth wrote:
I checked, and it is much better now!
But still not the full functionality.
While the scrollbar button is grabbed with the mouse,
the linked cell value does not change,
it only changes after the scrollbar button is released.
So some animation is possible by clicking and not
Leonard Mada wrote:
I found some interesting code inside the function
ScInterpreter::ScPropper() [in interpr1.cxx]. namely, there is a while
loop and an unnecessary subtraction is nested inside this while loop:
see pStr[nPos - 1]
while( nPos nLen )
{
aTmpStr.SetChar( 0,
bernie hunter wrote:
I'm a new developer in grad school, and want to make a regression tool
for CALC which it doesnt have (at least my version of Open Office Calc
doesnt)..and just wanted to make contact and say I'm going to try and
learn about that and do it. I'd hope someone would write and
gaozm wrote:
Thank you very much for your help during these weeks, now,there is a new
bug that we found in the OOo2.1.
The bug can be described as follows:
Save the document when the content of the note show Fontwork, withdraw
from the process.
1, Open a new Calc document.
2,
Kohei Yoshida wrote:
You may have already seen it, but there is also the scaddins module
where you can add new functions. This module was there originally to
ease addition of new cell functions without touching the Calc core, but
I don't know if this module is actively used today (Niklas?). I
毛勇岗 wrote:
Thank you for your suggestions.
As you said I analyzed the call stack. And in the SfxMedium*
SfxApplication::InsertDocumentDialog(sfx2\source\appl\appopen.cxx),
sal_uInt32 nError = pMatcher-DetectFilter( *pMedium, pFilter, FALSE );
if ( nError == ERRCODE_NONE pFilter )
Wojciech Gryc wrote:
In general, I think it would be best to continue with the UNO add-in
development using Rserve. While working on this, I realized that no matter
what happens, users of this tool will need to install R and possibly an R
package. As such, I don't mind making the entire thing
maoyg wrote:
FontWork should be disabled for note objects,because it will be caused
crash.
I analyzed the call stack, and in the void ScDrawShell::GetState()
(sc\source\ui\drawfunc\drawsh2.cxx ),
if( pObj pObj- GetObjIdentifier() == OBJ_CAPTION pObj- GetLayer()
==
maoyg wrote:
Thank you very much for your help and relpy.I have a new problem now.
In Calc,select only the range B3:D5 on an empty sheet,click toolbar -merge
cells.Then I want to insert a row/column where contains the merged cells.
The result ： Can't insert rows/columns when contains
gaozm wrote:
Thank you very much for your help, we have accomplished a Top-10
dialog for our users, because we thought it is necessary to bring
more convenience to users.Do you think it feasible?I'm looking
forward to your suggestions, thank you.
So you have something finished? What does it
gaozm wrote:
We have finished the Top-10 dialog, it looks like the Top-10
dialog when you select the Top-10 in MSoffice, do you think it is
feasible? Thank you.
It seems a bit redundant with the Standard Filter dialog. You should
bring it up on the ux-discuss list.
Niklas
gaozm wrote:
Hello all:
Here is a new question that because the cells hold high-default value is
too small(0.45cm), so our team changed the cells hold high-default value to
0.53cm, the changed code like this:
// ppPoolDefaults[ ATTR_FONT_HEIGHT - ATTR_STARTINDEX ] = new
Muthu Subramanian wrote:
I fixed i56202 in msba01.
[http://www.openoffice.org/issues/show_bug.cgi?id=56202]
Whom should I 'assign to', in EIS, for QA?
It's on the wrong branch. OOF680 was used for 2.2.1. The CWS has to be
resynced to a current SRC680 version first.
Niklas
Jahn, Ray (R.) wrote:
The symptoms can be divided into two types:
* a brand new spreadsheet file
a brand new and empty spreadsheet
no content in any cell
aXCellRange.queryEmptyCells() always returns nothing
regardless what the range is set to.
* a brand new spreadsheet file
a brand
Wojciech Gryc wrote:
But they're Java add-ins...? So shouldn't they work?
I'm specifically referring to the java/Spreadsheet examples in the SDK.
The Java examples, compiled on Linux, also work on Windows. Did you
close the application, including the quickstarter?
Niklas
Kohei Yoshida wrote:
I've also started some work on Excel 2007 style multi-string matching
filter (or whatever people like to call it). It's basically an
autofilter extension where you can select multiple items to display;
rather than just one.
The detail is in here:
Wojciech Gryc wrote:
However, when I install RAddon.uno.pkg it does add menus and everything
else, just no functions... That would mean the installation itself works on
XP, right? Or is there a separate issue to consider with adding functions?
Calc keeps a list of all add-in functions. If an
Kohei Yoshida wrote:
I can see that #i27745# and #i33851# have the highest votes casted among
all autofilter related issues.
http://www.openoffice.org/issues/show_bug.cgi?id=27745
http://www.openoffice.org/issues/show_bug.cgi?id=33851
So, I personally would recommend looking into those issues.
Max Giesbert wrote:
Thanks for pointing to XEnhancedMouseClickBroadcaster . I register a
XEnhancedMouseClickHandler to it. But I only have an EnhancedMouseEvent
in the mousePressed method. How can i find out the cell clicked with
that? I didn't find any suiting methods.
It's in the Target
Alan Yaniger wrote:
A number of our users have asked if there's a way we could increase the
maximum worksheet size. One said that for this reason alone he's
planning to move to Excel 2007, which allows over a million rows. What
is involved in implementing this feature in Calc? I'd like to
maoyg wrote:
I have made some changes about Issue 63144# on the version
SRC680_m215.The attachment is patch file of the issue 63144#.
Would you give me some suggestion and help about the patch file?
The attachment was removed from your mail by the mailing list server, so
we can't see it. Can
maoyg wrote:
I have just attached the patch to the issue. Please check it.
It's the right direction, but the patch disables editing of any notes on
a protected sheet. You should look if the note's cell is protected, so
notes of non-protected cells can still be edited.
Niklas
maoyg wrote:
The current sheet has been protected, so all of the cells in it are
protected. So that there is no non-protected cells in this protected
sheet. Then there is no need to look if the note's cell is protected.
All the notes in it should not be edited then. I find the all the
objects
Hi everyone who's involved with reference parsing,
When parsing references with CONV_XL_A1 convention, the return values
from ScRange::Parse are different from those for CONV_OOO and don't
match what ScCompiler::IsReference expects.
- For a single reference (Sheet1!A1), the bit SCA_VALID is
Noel Power wrote:
While not involved with reference parsing, I do know that for say the
example range like Sheet1!A1 currently code that Jody popped into the
vba interop api to help me ( for various range XL/R1C1 support )
expects SCA_VALID to be set on return
From your comments below it would
maoyg wrote:
About issue 63144# has been fixed. I have attached the patch to the
issue63144#, please check it.
I'm looking forward to your advice :).
Using the cursor position isn't right. The cell cursor can be anywhere,
it doesn't have to be at the note's cell when a user selects the note.
gaozm wrote:
I have looked at issue 23299, but the code in my version is a little
different from m215 about formula, because we have added some code in
that files, and I don't understand the concrete steps of issue 23299
fully, so I had a choice issue 27745. I hope you can give me some
Noel Power wrote:
If you can let me know when you commit the change ( and to what
file(s) ) I will at least run some tests against that as a sanity check.
It's in sc/source/core/tool/address.cxx 1.9.18.1.
I also made a small change to compiler.cxx (1.68.18.1) to correct the
output of such
Alan Yaniger wrote:
When openeing a DBF file in Calc, OOo asks the user which character set
to use. Is there a way to set a default charset for all files with a
given extension, like *.dbf?
If such a feature is not built-in, could it be done in an OOo BASIC
macro? If so, how?
The initial
maoyg wrote:
Thanks very much your advice. I have attached the patch file to the issue
63144#,please check it.
When I fixed the issue, I found some problems about Notes. On a protected
sheet,
the note's cell is protected,the other note's cell is non-protected.
I want to edit the
Xu dehua wrote:
I am fixing issue18704 and reading the function TRIMMEAN. But the
problem is: I don't know which statistics function has problem, so I
just look through the functions without any purpers. It is difficult
to find out the function which is needed to be modified.
Could you guys
Regina Henschel wrote:
I had a look at the source in interpr3.cxx and have made the proposed
changes for the COVAR function. Although I'm a very beginner I think,
that I'm able to change some of the other such functions too.
The changes need to calculate the mean in a first loop and than
Leonard Mada wrote:
I posted some time back a feature-request to implement a special
spreadsheet-view in which rows get *highlighted* (see
http://www.openoffice.org/issues/show_bug.cgi?id=78181).
Virtually every table on the net is displayed this way. Also, most web
applications have
gcavalcanti wrote:
Anybody knows where are the finance functions (ex. TIR,PV,RATE...) in the
OpenOffice sources?
I looked in the directory OOF680_m14\sc\source\core\tool\interpr*.cxx, but
without success...
Those that aren't add-in function are just there, but some have
non-obvious names
Kohei Yoshida wrote:
Along the same line, I would also like to see the possibility of
overlaying (or underlaying) a background image to enhance the visual
effect of Calc's (rather boring) sheet. Note that such background image
is not printable, so it's only for display. And it wouldn't scroll
Kohei Yoshida wrote:
I realize that Calc's external cell reference (a cell reference that
refers to a cell in another document) is implemented by creating an
invisible external link sheet first, then setting reference to it.
Can this be done purely via existing UNO API?
Create a linked sheet?
Steve Griffiths wrote:
I am interested in helping with Validating spreadsheet functions. What
do I need to do?
Some work has already been done, see the folder Function Validation at
http://sc.openoffice.org/servlets/ProjectDocumentList. A possible next
step would be to single out significant
Niklas Nebel wrote:
It looks like the layer has to be locked again, possibly in
FuText::StopEditMode.
And for right-click selection, ScGridWindow::SelectForContextMenu calls
lcl_UnLockComment (in gridwin.cxx), which has to be changed in a similar
way to FuSelection::TestComment, or preferably
开源技术部-云惊涛 wrote:
please follow these procedures
1.create a new calc.
2.input some date into cells,make sure 'c' in one cell
for instance 'c' in A1 and 'b' in A2,choose the two cells
3.on the tool bar,click insert-name-create,choose
top row,click ok.
4.and then click insert-name-define,in
gaozm wrote:
I found that it was related to the default row height of Calc, I
suggest to change the default row height to 0.52cm, but how to
achieve it, I hope you can give me some help, thank you very much!
Default row height isn't a fixed value, it's determined from text height
of the
Kohei Yoshida wrote:
I'd like get your input on the new UNO API that I have introduced as
part of implementing the multi-string filter. The relevant issue page
is here:
http://qa.openoffice.org/issues/show_bug.cgi?id=77677
Currently, Calc only has one type of sheet filter, which is
1 - 100 of 243 matches
Mail list logo
