-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Peter,
> IIRC in a former StarOffice version ValueHighlighting was stored with the
> document.
are you talking from so5.2 ? AFAIK oo 1.x seems to be the same as oo 2.x ...
> Isn't it confusing for the user that some properties of the
> OptionsDi
Hi,
I added a XFrameActionListener to a spreadsheet document.
If a user changes for example from "Tabelle3" to the print preview (in german:
"Seitenansicht")
and back the last frameAction(FrameActionEvent evt) i get is:
"COMPONENT_REATTACHED"
At this point it seems not to be possible to get t
have a look:
http://www.spiegel.de/netzwelt/web/0,1518,563637,00.html
seem's oo has the same problem with:
29513736 * 92842033 = 2740115251665290
Oliver
--
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Description: OpenPGP digital signature
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 array of strings, contain
forget to mention, that i get a basic error (overflow) in some cases here
' mRanges is a String Typ (correct)
Test = mRanges()
--
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Description: OpenPGP digital signature
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 you confirm ?
Oliver
REM
Hi Daniel,
> Yes, confirmed. Behaviour changed between 2.4.1 and 3.0, and looks wrong
i submitted an issus ...
http://www.openoffice.org/issues/show_bug.cgi?id=91911
Oliver
--
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/[E
Hi,
=CELL("Width";A1) reports the cell width, for example 12
now a user changes column width - but the formula still reports: 12
pressing (F9) does not help ... only a save & reload cycle will display
the new column witdh ...
imho a column size listener is missing here ...
Oliver
--
GnuPG ke
Hi, Eike,
thanks a lot :-)
>So as long as your default font (what's that anyway?) is not monospaced
>the result is even meaningless.
yes but now i am can determine whether a column is hidden or not ...
=WENN(ZELLE("WIDTH";A1)+0*ZUFALLSZAHL()=0
Oliver
--
GnuPG key 0xCFD04A45: 8822 057F 4956
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 ?
Oliver
--
Sensationsangebot nur bis 30.11: GMX FreeDSL -
Hi Eike,
> Kohei did already some work for French and Hungarian, we could add the
> German keywords. Please submit an issue and list all keywords of the
> CELL/ZELLE function and their localization in a German Excel.
http://www.openoffice.org/issues/show_bug.cgi?id=96689
just noticed i forgot th
Hi,
i have a problem with a *.sxc file on import in oo 3.0.1 and 3.x
the formula
=WENN(ISTNV(SVERWEIS(D9;Feiertage;2;0));"";SVERWEIS(D9;Feiertage;2;0))
will display "Err:504" - same file will open with oo 2.4.2 without any
problems ...
replacing the named range "Feiertage" with the cell ran
i created an issue with attachment
http://www.openoffice.org/issues/show_bug.cgi?id=97225
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Description: OpenPGP digital signature
Hi Eike,
I used Vista with oo 3.1 DEV300m37 Build 9371 and oo 3.0.1 DEV300m12 Build 9368
'Feiertage' point to $Input.$D$6:$E$21 if i open F3 on sheet 'Input', but
points to
$Input.$D$6:Calendar.$E$21 if i open on sheet 'Calendar' !
i will add 4 attachments (gif's) to show
http://www.openoffice
Hi Eike,
> That's http://qa.openoffice.org/issues/show_bug.cgi?id=96529 and fixed
> in OOO300_m13, clone will be integrated to DEV300_m38:
> https://tools.services.openoffice.org/EIS2/cws.ShowCWS?Id=7697
yep, fixed in m13 :-)
thanks
Oliver
--
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A
Can someone give me a hint how the "Optional hyphen"
should be used to avoid spellchecking errors in
spreadsheet application ?
If i need to wrap a word i have to format the
cell with
Format Format Cells ->
[x] Alignment Wrap text automatically
[x] Hyphenation active
If i don't wan
Hi Niklas,
> Full handling of optional hyphens is only in Writer, see issue 90566.
ahh, have not seen this issue till now ;-)
i added two issues for:
"Format – AutoCorrect – While Typing" not available in calc
http://www.openoffice.org/issues/show_bug.cgi?id=110949
Insert – Formating Mark has
Hi KAMI,
> Please test it and write your experience.
i had a look at the validator :-)
i found extremely useful:
it will show the precedent's even if they are on *other* sheets,
oo's detective won't do that at the moment ...
some hints:
- selecting a listbox item should set the spreadsheet vie
Hi,
had a look at some vlookup issues:
seems:
16786 ENHANC P4 Other requirementsSTARTE
Need better control of regexp in vlookup
44295 DEFECT P3 PC spreadsheet NEW
Vlookup with "/" character
99472 DE
Hi,
http://www.openoffice.org/issues/show_bug.cgi?id=116833
is it possible, that someone from sc team can confirm ?
imho this is a serious problem ...
Regards
Oliver
--
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Description: OpenPGP digital si
Hi,
can someone give me an example how to use createNameGroup() from
c.s.s.XDataPilotFieldGrouping
according to
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XDataPilotFieldGrouping.html
it take a sequence: createNameGroup( [in] sequence< string > aItems )
> Parameter aItems
Hi Niklas,
> Are "category" and "region" items of the field oField? They sound more like
> field names.
yes, your're right, i have to use the field items, not the field names ;-)
thanks
Oliver
--
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Descri
Hi Rony,
> extracted from a calc document and
> saved in an array in a programming language for further
http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XCellRangeData.html
maybe getDataArray() can help you to extract the values, for example:
oNRanges = ThisComponent.NamedR
Hi,
is there a change to get a win32 dev-build which includes
http://hg.services.openoffice.org/cws/calc69/summary ?
Regards
Oliver
--
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Description: OpenPGP digital signature
Hi,
i noticed hiding columns in large spreadsheets (~3MB) can be
very slow compared to oo 2.x, for example:
For i = 0 To uBound(mRanges())
oRange = oSheet.getCellRangeByName(mRanges(i))
oRange.getColumns().IsVisible = bVisible
Next i
will take about 3 seconds for each r
e with formula calculation.
> It mainly affects the drawing layer.
good to know, so it's save to use it :-)
Best Regards
Oliver
--
Oliver Brinzing fon +49 7181 481401 fax +49 7181 475635
Ludwigstrasse 14mobil +49 174 3015743
73614 Schorndorfmailto:oliver.brinz...@gmx.de
Hi,
the following basic script will insert a form control into a spreadsheet.
but it is not possible to print the form control (have a look at the print
preview)
printing of the form control will only work after a save & relaod ...
any hints whats wrong ?
no problems so far with oo 2.0 ...
i s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> Form controls have to be on a special layer. This is still true for 2.0,
> even if printing happens to work otherwise. This should probably be
> enforced somewhere in the API implementation, but it isn't. So you
> should add a line like
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
is it possible that the oo2.01. xml file is different from so 8.0 ?
My XPATH expressions do not work with oo 2.0.1 files ...
oo2.0.1:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
i found that, the oSheet.copyRange(oDstCell, oSrcRange) does not work,
if cells in the destination area are merged ...
this is not a real problem, cause you can unmerge the destination range before
the copy ...
- --8<---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
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 fo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> Disabling it only on the protected sheet wouldn't be enough, a protected
> formula might as well depend on cells on non-protected sheets. Also,
> it's not only cut & paste, but also stuff like drag & drop and
> inserting/deleting cells.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
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 but
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> Edit mode isn't directly available in the API (see issue 20210).
> What you can do right now is change the selection (select a different
> cell, then the original one again). This will always end the edit mode.
yes, i can do so, but i th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> Is there any deeper meaning to the inclusion of "Cell" into only some of
> the method names?
No, i had a look at some java classes (javax.swing.AbstractCellEditor,
javax.swing.plaf.TreeUI,...) and found a mixture of names indeed
i w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I just tried out the latest oo dev-build m165 and have problems with the
display update in calc now.
I use a Listbox (form control) to change between the sheets, this originally
caused
oo 1.1.5 to crash (http://www.openoffice.org/issues/show_bu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> Is this with the file from issue 33728, or something more complicated?
yes and no, i used a newer version of this file ...
I will try to reproduce this behaviour over the weekend and send you
some screenshots :-)
>> Is it possible
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> I will try to reproduce this behaviour over the weekend and send you some
> screenshots :-)
can not reproduce it with m167 at the moment :-)
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
how can I reference a cell containing text with linebreaks ?
example:
Cell A1:Hello <- linebreak (Strg) (Enter)
World
Cell B1: =A1
result: Hello World
in B1 the linebreak char *changed* into a space char (code 32) !!
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Peter,
>This is a known issue (30781),
thanks, next time i will ask you before asking the community :-)
IMHO this should be treated as a bug, cause the linebreak char is
changed into a space (code 32) ...
Oliver
- --
GnuPG key 0xCFD04A45: 8822
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> The first cell doesn't contain a line break character. It contains two
> paragraphs.
this is true, if one acesses the cell via basic getString() method ...
example:
A1 = Hello
World
Sub Test()
Dim s as String
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> What are you trying to do? You have multiple-paragraph content in one
> cell and want to use each paragraph in a separate formula? How does the
> content get into the first cell?
the main purpose is to fill a (merged) cell with address
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
is there an easy way to export a single sheet
(which can contain 1-X print pages) to pdf ?
for example:
a calc document contains:
sheet1 1 page
sheet2 2 pages
sheet3 1 page
How to export "sheet2" ?
Do we have the same problem as
http:/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Stefan,
> (1) File | Export to PDF...
> (2) Give file name and destination
> (3) Klick "Save"
> (4) Choose Range|Selection
uups, i forgot to mention, that i was looking for a starbasic script ...
but this one seems not to work:
Sub PDFExport()
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
thanks, that is what i was looking for :-)
> "Selection" only works with a single sheet (or cell range). To export
> several sheets, you should set up print areas.
REM * BASIC *
Sub PDFExport()
On Local Error Goto Err
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
is it possible to access the cipher api for en-/decrypting calc password
protected sheets/documents ?
scenario:
Some people have to enter data into a spreadsheet document.
But only one of them is allowed to run a macro to do some calculations
an
Hi,
if have a performance problem with a spreadsheet document.
The document has about 100 sheets and about 50.000 SVerweis() formulas as
=WENN(ODER(ISTLEER(E6);E6="");"";SVERWEIS(E6;Code.$B$4:$F$3492;2;0))
=WENN(ODER(ISTLEER(E7);E7="");"";SVERWEIS(E7;Code.$B$4:$F$3492;2;0))
...
If one enters a v
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Eike,
> If all or most SVERWEIS/VLOOKUP formulas reference the range
> Code.$B$4:$F$3492 then this may be due to a broadcaster performance
> problem that comes into play when too many formulas listen on identical
> portions of ranges. You may try t
Hi,
is it possible to completly remove user defined numberformats
from a spreadsheet document ?
I used removeByKey() to do so, but it seems, the formats still writen
to the xml file (even if the are not longer shown in the dialog ...)
Oliver
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Online
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> Usually, what you remove is gone. You must be doing something special.
seems to be true, but i have some files, where the styles still
remain in the styles.xml, and don't know why :-(
http://www.openoffice.org/issues/show_bug.cgi?id=75
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
please have a look at
http://qa.openoffice.org/issues/show_bug.cgi?id=10957
are you talking about the same limitation ?
Oliver
Am 05.07.2007 19:24 schrieb Kohei Yoshida:
> On Thu, 2007-07-05 at 19:04 +0200, Niklas Nebel wrote:
>> Leonard Mada
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
maybe i am blind, but how to listen to changes of NamedRanges
(addNewByName/removeByName) ?
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)
Comme
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
is it possible to listen for a change of the current sheet in OO 1.1.5 ?
In OO 2.x I use the XActivationEventListener ..
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-BEGIN PGP SIGNATURE-
Version:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> You could use a SelectionChangeListener and then compare the current
> sheet's index.
yes, that's what i had in mind too ...
hopefully i will not run into performance problems ...
thx
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 4
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> No, there's no notification for that.
I am thinking about an RFE for this ...
Cause the NamedRanges are an unsorted list, IMHO it will make sense
to get informed if one has to update a sorted list ...
Further on i am thinking about filt
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
i add a XActivationEventListener to a calc document using:
XController xController = xModel.getCurrentController();
XActivationBroadcaster xActivation = (XActivationBroadcaster) UnoRuntime
.queryIn
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Eike,
> No, but crashing surely is a bug. Please file an issue.
http://www.openoffice.org/issues/show_bug.cgi?id=80437
regards
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-BEGIN PGP SIGNATURE-
Ver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
>> http://www.openoffice.org/issues/show_bug.cgi?id=80437
is it possible, that someone can verify thsi bug ?
it makes XActivationBroadcaster unusable ...
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Excel 2007 can't do math
oo can better :-)
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
i have a big calc document (about 3,50 MB, 100 sheets).
If one switches between the sheets (click on the sheet tabs)
OO freezes for about a minute.
this happens always if one tries to click on a sheet tab but in real
starts a drag and drop opera
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> thanks, please fix soon :-)
BTW: if oo runs inside a vm, this happen even with smaller docs ...
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Niklas,
> There's issue 83005 about that.
thanks, please fix soon :-)
Oliver
- --
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mo
62 matches
Mail list logo