Am 14.12.2010 16:31, schrieb Marina Plakalovic:
Tnx, Daniel.
I needed that one. :)
If there are questions, if you find mistakes, etc... please just write here.
Daniel
-
To unsubscribe, e-mail:
Hi Regina,
Am 08.08.2010 19:12, schrieb Regina Henschel:
I have build DEV300m84 on WinXP. That works so far, but saving a
spreadsheet document from Calc gives always the Debug Output:
Error: wrong NameAccess
From File C:/DEV300m84my/xmloff/source/core/SettingsExportHelper.cxx at
Line 406
If
rashi dhing schrieb:
This is probably a very basic question but I am getting a compile error
while trying to include the
interpre.hxx in my module which happens to be located in a new directory
in the sc/source/ui path.
How can I resolve this ?
There are several existing locations for header
Regina Henschel schrieb:
Hi all,
I see ANSI character set and not UTF-8 in
scaddins/source/analysis/analysis_deffuncnames.src.
Is that an error or purpose?
I see. I have no idea how to tell rsc which encoding to use, or if that
is fixed to ANSI (which would be a bug of course). Will try if
Hi,
Regina Henschel schrieb:
I have now used in analysis_deffuncnames.src an entry:
StringArray ANALYSIS_DEFFUNCNAME_Imcot
{
ItemList =
{
_xlfnodf.IMCOT; ;
_xlfnodf.IMCOT; ;
};
};
And for comparison an entry
StringArray
Hi Regina,
Regina Henschel schrieb:
If I use ocExternal the prefix is set, but the functions are not
distinct, only one name is written and on import the whole function name
is stripped, so only =(z) remains from =_xlfnodf.IMSECH(z).
I see no way to add the imaginary functions to list
Hello,
Regina Henschel schrieb:
Daniel Rentz schrieb:
Right, fix has been integrated into m77
http://qa.openoffice.org/issues/show_bug.cgi?id=79854
Now I have a build based on m78. I made some import/export tests.
Excel2003 xml is totally broken (issue 94261) and not mentioned below
Regina Henschel schrieb:
Hi Daniel,
Daniel Rentz schrieb:
Same for the equivalent table saFuncTable_Odf in
sc/source/filter/excel/xlformula.cxx.
It seems, that I have to wait till m78, because m76 does not contain
saFuncTable_Odf and m77 does not build for me.
Right, fix has been
rashi dhing schrieb:
I started building the sc module with debug=true but now I am getting the
following error:
../wntmsci12.pro/bin/scuimi.dll : fatal error LNK1169 : one or more
multiply defined symbols found.
dmake: Error code 2, while making ' ../wntmsci12.pro/bin/scuimi.dll
I came
Regina Henschel schrieb:
I have started a new Wiki page
http://wiki.services.openoffice.org/wiki/Calc/Drafts/Treatment_of_new_Excel_2010_functions
Note that the functions are not renamed (as one may read on th Wiki),
but that the old functions with the old names still exist.
Daniel
Alexandro Colorado schrieb:
when did OOo Calc (what version #) get past the 65,000 limit on spreadsheets?
It was the 32,000 row limit (now there are 65,536 rows available), and
the feature announcement was in May 2004:
http://sc.openoffice.org/servlets/ReadMsg?list=featuresmsgNo=157
(hmm,
Regina Henschel schrieb:
Hi Daniel,
I do not answer directly, because it seems that I described my concern
not good enough. Next try:
== Import ==
Importing an Excel-file with =CEILING(-3.4;) for example gives the
cellcontent =CEILING(-3.4;;1), because in the current import filter the
Moin,
Regina Henschel schrieb:
Ah, IsMissing() is new to me. I can now set the missing second parameter
to +1 or -1 depending on N. That works at least for CEILING on which I'm
currently working.
But Excel Import and Export is confusing.
(1) Import:
In cases CEILING(value;) and
Hello,
Kohei Yoshida schrieb:
Great! BTW, the new security framework would probably affect the
password input UI part, but should not affect anything else IMO.
Btw, I am interested in the pw input UI stuff to add it to the ooxml
filter. Do you have a pointer for me?
Regards
Daniel
maoyg schrieb:
Hi,Daniel
I am working the issue 35579 with lvyue, and now I come to the Excel
import/export part.
the Excel has some options,I have added some change,for example, excdefs.hxx
added comparison operands,
the XclImpAutoFilterData::ReadAutoFilter() method in excimp8.cxx added
Eike Rathke schrieb:
Hi Regina,
On Tuesday, 2009-03-17 18:04:12 +0100, Regina Henschel wrote:
But export to Microsoft Excel 2003 XML (.xml) is problematic.
If OOo is set to save in odf1.2, the file opens with errors in Excel.
All formulae are stripped. The error log says for example
GRUND:
Regina Henschel schrieb:
Hi Eike, hi Daniel,
Regina Henschel schrieb:
No more questions for now, I'll continue my tests. Thanks for your help.
Now all works as it should and I'm going to create patches. And have got
the next problem.
For the file token.cxx in formula/source/core/api I
Regina Henschel schrieb:
Hi Daniel,
That works. When exporting to xls, I get the correct function structure,
if there are one, two or three parameters in OOo. If there are four
parameters in OOo, I get a =#NV entry in German Excel 2007. I think, the
error message is correct, because the user
Hi again,
Daniel Rentz schrieb:
To delete the 4th parameter, you can change the function info of this
function. Go to xlformula.cxx and look for ocLogNormDist, change the
line from
{ ocLogNormDist,290,3, 3, V, { V }, 0, 0 },
to
{ ocLogNormDist,290,3, 3
Kohei Yoshida schrieb:
Hi Eike,
On Tue, 2008-12-09 at 20:41 +0100, Eike Rathke wrote:
If there isn't any,
wouldn't it be natural to share the filter's name mapping with VBA?
Absolutely, and that's what I envisioned too.
What we seem to disagree is where to keep the shared filter name
Hi,
Michael Meeks schrieb:
I just committed a chunk of code to the ooxml02 CWS. This extends the
visibility markup to the classes we use during import and export: which
turned out to be fewer symbols than I had feared (10k vs. 9k symbols),
and splits out all of the calc filters (except
Hello all
some thoughts and questions about CWS ooxml02:
1) I noticed that you changed filter names and file type names in the
configuration (module filter). This is not a good idea as these names
can be considered public API. These strings may be used in macros and
other programs to use a
Oliver Brinzing schrieb:
Hi,
just recieved an excel file with a formula like this:
=DATUM($G$1;MONAT(A$3);((ZELLE(ZEILE;A4))-3))
OO displays Err:502, cause the argument Zeile should be row ...
is it possible to fix the import or localize the arguments ?
Instead of using ZELLE(ZEILE;A4) one
Daniel Rentz schrieb:
lvyue schrieb:
Hi Daniel,
I made the changes you suggested, but it doesn't work.
it is still =NA()
I'm tracing the code, but I didn't get any clue yet.
If you have findings, please tell me, thank you.
Try to find where compiling the formula breaks. The N/A error
lvyue schrieb:
Hi Daniel,
I made the changes you suggested, but it doesn't work.
it is still =NA()
I'm tracing the code, but I didn't get any clue yet.
If you have findings, please tell me, thank you.
Try to find where compiling the formula breaks. The N/A error is an
indicator for an
Hello,
with some surprise I have seen hundrets of check ins in the CWS ooxml02
with the goal to implement OOXML export filters. For Calc this seems to
be done by extending the binary BIFF export filter. As it looks this
makes it necessary to export headers from and linking against oox thus
Jonathan Pryor schrieb:
On Fri, 2008-11-21 at 11:57 +0100, Daniel Rentz wrote:
with some surprise I have seen hundrets of check ins in the CWS ooxml02
with the goal to implement OOXML export filters. For Calc this seems to
be done by extending the binary BIFF export filter. As it looks
Daniel Rentz schrieb:
Jonathan Pryor schrieb:
On Fri, 2008-11-21 at 11:57 +0100, Daniel Rentz wrote:
with some surprise I have seen hundrets of check ins in the CWS
ooxml02 with the goal to implement OOXML export filters. For Calc
this seems to be done by extending the binary BIFF export
Daniel Rentz schrieb:
case T_Ext:
{
UINT16 n = pElement[ nId ];
EXTCONT* p = ( n nP_Ext )? ppP_Ext[ n ] : NULL;
if( p )
+ {
+ if( p-eId == ocExternal )
Oh no, there is a typo, it has to be:
+ if( p-eId == ocEuroConvert )
of course
Lvyue schrieb:
Hi, Daniel
I have add what you advised in sc/source/filter,
a new book type in xllink.hxx,
in xilink.cxx, XclImpSupbook::XclImpSupbook(),
a new type in enum XclImpExtNameType (and set it in
XclImpExtName::XclImpExtName() ),
and I also add a case for the new xlExt*** type.
Hello Kohei
looking at XExternalSheetCache::[sg]etCellValue(), I suggest to swap the
parameters nRow and nColumn, because cell addresses are passed around in
the entire sc module that way, and it is the member order in
com::sun::star::table::CellAddress.
Daniel
Daniel Rentz schrieb:
Hello Kohei
looking at XExternalSheetCache::[sg]etCellValue(), I suggest to swap the
parameters nRow and nColumn, because cell addresses are passed around in
the entire sc module that way, and it is the member order in
com::sun::star::table::CellAddress.
... see also
Hi Kohei,
some more thoughts... :-)
Do we really need the SheetName string member in the
ExternalReference struct? How about transporting the index of the
cache in the Sheet member of the SingleReference/ComplexReference? The
index should be available as attribute in XExternalSheetCache
Hi Kohei
some thoughts about the new ExternalDocLinks API in CWS mooxlsc...
First, there is no documentation in the IDL files, please consider to
add some ;-)
I think, a cleaner way to implement the service ExternalDocLinks is to
make it a container, i.e. to support the interfaces
Kohei Yoshida schrieb:
Hey Daniel,
On Fri, 2008-08-29 at 09:29 +0200, Daniel Rentz wrote:
Hi Kohei
some thoughts about the new ExternalDocLinks API in CWS mooxlsc...
First, there is no documentation in the IDL files, please consider to
add some ;-)
Well, real men use code
Kohei Yoshida schrieb:
On Fri, 2008-08-29 at 09:29 +0200, Daniel Rentz wrote:
To do: do we need API to remove something from the cache, or an entire
cache, or even an entire external linked document?
I don't think it makes sense to add API to remove individual cell cache
from a table, since I
Leonard Mada schrieb:
Hi Daniel,
Thank you. Indeed, this did it.
[I must say I did search up and down through the Options Dialog for a
suitable option at no success.]
Though I still miss an UNDO option in the context menu.
I don't miss it, for me ALT+BS is much faster ;-)
Daniel
Leonard Mada schrieb:
Hello everyone,
I try to enter in a Calc cell:
Diabetes mellitus Typ IIb
but the last part gets converted automatically to Typ Iib. How do I
undo this?
This is obvious a serious bug. Why does Calc autoformat something it is
NOT supposed to do?
try to uncheck
Tools -
Hi,
Eike Rathke schrieb:
Some potential issues:
- Compatibility with Excel possibly needs discussing. We've not been
compatible with Excel in the past and this patch does not make it 100%
compatible, rather it improves compatibility, and improves further where
Excel gets it wrong IMHO.
Cor Nouws schrieb:
Hi Eike,
Solution would be to always generate an error in such case.
You mean an error if an formula holds an non numeric argument. This is
the same as Excel does, 'only' with this difference that Excel in some
formulas uses text that can be interpreted as number, and in
yunjingtao schrieb:
hi, Daniel
can you explain these
SFX_STYLE_FAMILY_CHAR
SFX_STYLE_FAMILY_PARA
SFX_STYLE_FAMILY_FRAME
SFX_STYLE_FAMILY_PAGE
to me?
Open a Writer document and the Stylist (Format-Styles or key F11). On
top you see different buttons for different types of styles for
Hi Regina,
Regina Henschel schrieb:
Hi Daniel, hi Kohei,
I've learned now, that I can get erfc(z) by GetUpRegIGamma(0.5,z^2), so
I need no copypaste. GetUpRegIGamma is a private function of
ScInterpreter, in file interpr6.cxx. But now I have the next problem:
The structure now is:
We have
Oliver Brinzing schrieb:
Hi Daniel,
But I'm not an expert, and as the code below is not specific to the
Calc API, you probably should ask on the [EMAIL PROTECTED] or [EMAIL PROTECTED] mailing list.
i found out what is going wrong, just run the new example ...
i think this is a bug ...
can
yunjingtao schrieb:
Daniel schrieb:
Please do not rely on the item state only, but test the contents of the
item too. See the example for the FID_MERGE_TOGGLE item in the same
file: the test ... = SFX_ITEM_DEFAULT
makes sure that the item exists (it has state DEFAULT or SET), and
that it
Oliver Brinzing schrieb:
Hi,
are there any known issues with the basic engine in oo 3.0 ?
i tried m23/m25 with same results ...
i have code *similar* to the snippet below, which will filter Named Ranges
of a calc document, for example all Named Ranges starting with X_XXX ...
it will return an
yunjingtao schrieb:
hi, Daniel
I submitted a patch to issue25018. Using some test cases, I checked
it, and it's ok. Hope you review it, and if possible,give me some
advice. If there is no problem with it, assign me issues please.
I have one question and wish you answer it at your
yunjingtao schrieb:
Daniel wrote:
The aEdComment gets the focus though you do not pass WB_TABSTOP to
its c'tor?
hi, Daniel Thank you for you reply. Yes, exactly. The aEdComment gets
the focus, I think the reason is because of WB_DIALOGCONTROL |
WB_TABSTOP in ScScenarioWindow constructor,
Eike Rathke schrieb:
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
Eike Rathke schrieb:
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
YunJingtao schrieb:
Yes.Following these steps Data-Define Range, you can find that the dialog
are the same and the same mistakes.
According to your advice, I try to fix the function UpdateNames() and add
some code.
at the begining:
//aEdName.Clear();
String aNewEntry =
YunJingtao schrieb:
hi, Daniel
Same phenomenon happens when Define Range(Data-Define Range). They
are all related to ScrollBar. What should we do next?
Hello
the dialog should behave correctly for all functions (Add, Remove,
Modify). Are there other places where the name list is cleared and
YunJingtao schrieb:
hi, Daniel
Do you mean that I should use ListBox instead of ComboBox?
Sorry, ComboBox is correct, no need to change this (I didn't check what
class is used in the dialog).
Daniel
-
To unsubscribe, e-mail:
Hello,
This morning seeing the status and resolution of Issue3866 were changed to
resolved
and wontfix, I read them as it needn't fix now, so today I begin to fix the
issu10755.
So simple the description of the issue10755 is that it is difficult for me
to reproduce
the wrong
Kirill S. Palagin schrieb:
Thanks for the link.
Actually I meant our specification for the import and how we are
handling spreadsheets with more than 65K rows on import, not full spec
of OpenXML.
Contents out of the limits of the current document are truncated. After
import, this will be
Kohei,
Kohei Yoshida schrieb:
As for the OOXML file, the texts with ruby are represented as follows.
sst xmlns=http://schemas.openxmlformats.org/spreadsheetml/2006/main;
count=2 uniqueCount=2
si
t吉田浩平/t
rPh sb=0 eb=2
tヨシダ/t
/rPh
rPh sb=2 eb=4
Daniel Rentz schrieb:
Kohei Yoshida schrieb:
On Mon, 2007-08-20 at 18:39 +0200, Niklas Nebel wrote:
Kohei Yoshida wrote:
Ok, but I don't think the ruby text is entirely a formatting attribute
of the text. I consider that a part of the raw text data.
When querying for raw text, as in formulas
Kohei Yoshida schrieb:
On Mon, 2007-08-20 at 18:39 +0200, Niklas Nebel wrote:
Kohei Yoshida wrote:
Ok, but I don't think the ruby text is entirely a formatting attribute
of the text. I consider that a part of the raw text data.
When querying for raw text, as in formulas, or text export, do
Eike Rathke schrieb:
Hi Kohei,
On Tuesday, 2007-08-21 08:12:13 -0400, Kohei Yoshida wrote:
What I meant to say was that Excel embeds the ruby text directly into
string data in the shared string table, instead of storing it as a cell
attribute.
As part of the string? How is it distinguished?
Hi Kohei
Also, how are we dealing with Excel's shared formulas?
I have implemented shared formula import for the OOX and BIFF filters.
They are as good as the underlying formula import. The only outstanding
task is to hide the generated defined names __shared_??? that are used
to simulate
Leonard Mada schrieb:
What are shared formulas?
Is it the same as the concept I presented in a previous e-mail, where
one can have a default formula for a column? This is indeed a very
useful feature to have in OOo Calc and is one issue that gets into my
TOP 5 of major design flaws of existing
Max Giesbert schrieb:
actually i have problems with the very first line of code you sent:
acc =
ThisComponent.CurrentController.Frame.ComponentWindow.AccessibleContext
i am doing development right now using java. so i do get the
ComponentWindow by:
XWindow window =
Max Giesbert schrieb:
Thx again. feels like i am already there. i got the XCell now from the
Target but how can i get the location of the cell on the screen. i read
about XAccessibleComponent but XCell doesn't seem to implement it...
I have written a tiny test script in Basic recently, that
Kohei Yoshida schrieb:
Hi all,
So, worksheet element has a child element called sheetViews, which
contains a group of sheetView elements. It contains view data such as
the cursor position, active sheet etc.
Here is a problem with importing these view settings. For us to set such
view data, we
René Peinl wrote:
Hi guys, I'm sorry to bother you with this, but you seem to be the
only people reachable outside Microsoft that know about the XLS file
format. I've dealt myself a lot with the XML versions and also did
some minor enhancements to the OO XSLTs that convert WordML to OO,
but now
Hi,
Eike Rathke schrieb:
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.
Hi,
Askanthea wrote:
I dont know if you can help but i got your email from the -to do page.
If I have a long column of variables for example numbers 1-100 in cells
a1-a100 when i try to print it comes out on 2 or 3 pages - i want the
finished result to appear on one page but in 2 or 3
Hi,
Kohei Yoshida schrieb:
On 5/17/05, Daniel Rentz [EMAIL PROTECTED] wrote:
Yes, it is. It also includes information about differences between the
varios versions of Excel, e.g. available functions and different
parameter counts.
Cool. That's even better. Thanks for the clarification.
One
67 matches
Mail list logo