Verweise in Tabellen

2015-11-13 Thread Semmel


Moin *.*,

ich muss noch einmal nerven, da ich ein Verständnis- oder 
Umsetzungsproblem mit SVERWEIS habe.
Zum besseren Verständnis eine Tabellendarstellung unter: 
http://www.file-upload.net/download-11039857/Verweise.JPG.html


In der Tabelle stehen in der Zeile 4 verschiedene Jahre und in der 
Spalte A (A5:A16) verschiedene Monate (01.01.2015 bis 01.12.2015 - mit 
der Zellenformatierung "", so dass nur die Monate ausgegeben werden).

Innerhalb der Matrix B5:H16 stehen verschiedene Werte.

In der Zelle C20 wird der höchste Wert der Matrix ermittelt und ich 
möchte nun in Zelle E20 (bzw. E21) wissen, wann genau (Monat und Jahr) 
dieser Wert angefallen ist.


Die genutzte Formel in E20 [=SVERWEIS(C20;A5:H16;1)] oder auch 
[=SVERWEIS(MAX(B5:H16);A5:H16;1)] ergibt die Zahl "42339" (Zelle als 
"Zahl" formatiert) bzw. "Dezember", wenn die Zelle als "" formatiert 
wird (siehe Zelle F20). Ich kann in Zelle E20 auch die Formel 
[=MONAT(SVERWEIS(C20;A5:H16;1))] bzw. 
[=MONAT(SVERWEIS(MAX(B5:H16);A5:H16;1))] verwenden, dann ist das 
Ergebnis "12", was ebenso dem Dezember entspricht.

Die in Zelle E21 genutzte Formel [=WVERWEIS(C20;B4:H16;1)] ergibt "2011".

Beides (Monat und Jahr) sind aber ja nun ganz offensichtlich falsch, da 
der höchste Wert innerhalb der Matrix in Zelle E5 steht und damit die 
korrekte Zuordnung "01/ 2008" bzw. "Januar 2008" lauten müsste. In 
beiden Fällen "finden" SVERWEIS bzw. WVERWEIS aber die jeweils letzte 
Zeile bzw. die letzte Spalte der Matrix, was darauf schließen lässt, 
dass der korrekte Wert nicht gefunden wird. Kann das sein???
In der Zelle E5 steht die Zahl "233275,82" - lediglich formatiert mit 
zwei Nachkommastellen und "BLAU" und sie hat keine weiteren 
Nachkommastellen. Exakt dieser Wert wird durch [=MAX(B5:H16)] in die 
Zelle C20 übertragen. Weshalb also sollte der Wert mit SVERWEIS oder 
WVERWEIS nicht gefunden werden?
An der nicht angegeben Sortierfolge kann es doch wohl nicht liegen, da 
die Werte in der Spalte 1 (Spalte A) doch sortiert sind !?!?

Oder liegt es an den Leerzellen? (Kann aber eigentlich[?] auch nicht sein).

Sofern jemand die Tabelle selbst haben möchte: 
http://www.file-upload.net/download-11039984/Handelsvolumen_V1.1-24.ods.html


Ich kriege noch die Krise ... ;)

Liebe Grüße und für jede Hilfe dankbar, Peter.



-
To unsubscribe, e-mail: users-de-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-de-h...@openoffice.apache.org



Re: Falschrechner

2015-11-13 Thread RA Stehmann
Hallo,

binär zu dezimal und umgekehrt führt in der Tat zu Fehlern. Hierfür gibt
es ein berüchtigtes Beispiel:

Python 3.2.3 (default, Feb 20 2013, 17:02:41)
[GCC 4.7.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> 0.3+0.6
0.8999
>>> (0.3*10+0.6*10)/10
0.9
>>>

(Neuere Python-Versionen haben diesen Fehler auch noch.)

Wie man sieht kann Python3 mit einem Trick durchaus genau rechnen.

Am problematischsten ist wohl der Umstand, dass Python
0.8999 von 0.9 sehr wohl unterscheidet:

>>> 0.3+0.6 == (0.3*10+0.6*10)/10
False
>>>

Traut keinem Computer ungeprüft!

Gruß
Michael







signature.asc
Description: OpenPGP digital signature


RE: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Dennis E. Hamilton
Thanks Larry,

I considered that it might be a JavaScript problem and I looked at the Source 
of the page.  There are *tons* of JavaScript on that page and it appears to be 
running.  I did not dig deeper.  

I did not turn on a debugger and I did not look deeper to see if there is 
something particular about the JavaScript that is only what is failing.

I believe the frame with release information is retrieved from SourceForge.  If 
the page served directly from SourceForge at 
 does work, we can rule 
out SourceForge blocking and look elsewhere.

 - Dennis


> -Original Message-
> From: Larry Gusaas [mailto:larry.gus...@gmail.com]
> Sent: Thursday, November 12, 2015 19:34
> To: users@openoffice.apache.org
> Subject: Re: Apache OpenOffice 4.1.2 released
> 
> On 2015-11-12, 9:21 PM Dennis E. Hamilton wrote:
> > In a direct response and screen shot sent to me, the problem for the
> reporter is that the Download button does not appear on his computer.
> There are two small adjacent circles where the "Download full
> installation" and "Download language pack" buttons should be.
> >
> > The frame with the release information is also empty.
> 
> He may have javascript disable on his browser.
> 
> --
> _
> 
> Larry I. Gusaas
> Moose Jaw, Saskatchewan Canada
> Website: http://larry-gusaas.com
> "An artist is never ahead of his time but most people are far behind
> theirs." - Edgard Varese
> 
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



considering OPEN OFFICE BUT WANT FEW MORE FACT FIRST

2015-11-13 Thread R B E DYER
Hi there,
I am considering switching to Open Office, but want to check few things first,

1) Will this update itself like MS Office does

2) this is usable with people forwarding you MS Word Documents

3) this does not interfere with your MS Programmes Setting likes Windows Mail 
ETC..




Re: considering OPEN OFFICE BUT WANT FEW MORE FACT FIRST

2015-11-13 Thread Rory O'Farrell
On Fri, 13 Nov 2015 15:02:59 -
"R B E DYER"  wrote:

> Hi there,
> I am considering switching to Open Office, but want to check few things first,
> 
> 1) Will this update itself like MS Office does

No - you must download and install any update; these are infrequent.

> 
> 2) this is usable with people forwarding you MS Word Documents

OpenOffice does not pretend to be an MS Office clone; it has much of the same 
functionality.  The MS Office filters have been reverse engineered, so there 
can be problems.  OpenOffice's native format is OpenDocument, the format UK 
government and many other organisations are moving to.
> 
> 3) this does not interfere with your MS Programmes Setting likes Windows Mail 
> ETC..

It should not, but I have never used Windows Mail.

> 
> 


-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Andrea Pescetti

Dennis E. Hamilton wrote:

I believe the frame with release information is retrieved from SourceForge.


No, nothing from SourceForge appears on the openoffice.org domain. We 
simply link to binary files provided by them.


All the JavaScript is custom and stored in SVN. People without 
JavaScript see this notice:

  ---
Apache OpenOffice Downloads - Official Site

The browser seems to have JavaScript disabled. This technique is used 
for showing the actual download link. If you want to download Apache 
OpenOffice anyway, click this text to choose from the alternative 
download webpage. You will have to navigate to the 
version/binaries/language subfolder and and download the file named 
Apache_OpenOffice_version_os_platform_package_language.ext. Our 
apologies for the inconvenience.

  ---
Considering that we are in 2015 (I mean: people who browse without 
Javascript are doing it deliberately and are having a non-standard 
browsing experience on most sites), this is already more than enough.


The "click this text" above links to 
http://sourceforge.net/projects/openofficeorg.mirror/files/ (surprise! 
this is where it comes from) and from there, without JavaScript, one can 
indeed browse to the folder and download OpenOffice with a mostly 
painless procedure (and no ads will be displayed).


Note: There's a typo ("and and") in the above text, I've just fixed it 
in revision 1714258.


Regards,
  Andrea.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



RE: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Dennis E. Hamilton
In a direct response, the original reporter was successful using the 
SourceForge Download mirror page.

It remains unknown what prevented the Apache OpenOffice download page from 
rendering properly.

 - Dennis



> -Original Message-
> From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org]
> Sent: Friday, November 13, 2015 09:27
> To: users@openoffice.apache.org
> Subject: RE: Apache OpenOffice 4.1.2 released
> 
> Thanks Larry,
> 
> I considered that it might be a JavaScript problem and I looked at the
> Source of the page.  There are *tons* of JavaScript on that page and it
> appears to be running.  I did not dig deeper.
> 
> I did not turn on a debugger and I did not look deeper to see if there
> is something particular about the JavaScript that is only what is
> failing.
> 
> I believe the frame with release information is retrieved from
> SourceForge.  If the page served directly from SourceForge at
>  does work, we
> can rule out SourceForge blocking and look elsewhere.
> 
>  - Dennis
> 
> 
> > -Original Message-
> > From: Larry Gusaas [mailto:larry.gus...@gmail.com]
> > Sent: Thursday, November 12, 2015 19:34
> > To: users@openoffice.apache.org
> > Subject: Re: Apache OpenOffice 4.1.2 released
> >
> > On 2015-11-12, 9:21 PM Dennis E. Hamilton wrote:
> > > In a direct response and screen shot sent to me, the problem for the
> > reporter is that the Download button does not appear on his computer.
> > There are two small adjacent circles where the "Download full
> > installation" and "Download language pack" buttons should be.
> > >
> > > The frame with the release information is also empty.
> >
> > He may have javascript disable on his browser.
> >
> > --
> > _
> >
> > Larry I. Gusaas
> > Moose Jaw, Saskatchewan Canada
> > Website: http://larry-gusaas.com
> > "An artist is never ahead of his time but most people are far behind
> > theirs." - Edgard Varese
> >
> >
> >
> > -
> > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: users-h...@openoffice.apache.org
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Dale Erwin
Well it's difficult to confuse a link with plain text when it's a big button 
labeled "download"

On Nov 12, 2015 6:00 PM, Fernando Cassia  wrote:
>
> On Thu, Nov 12, 2015 at 7:33 PM, Dale Erwin  
> wrote: 
>
> >   It really annoys me how sourceforge puts all those other download links 
> > on the open office download page 
>
>
> Those are most of the time not links, but advert banners. 
>
> Big difference. Web users should learn to know the difference between a 
> regular text link, a web page button and a bitmap (image) with text written 
> on it. Just hovering the mouse cursor over an banner image will usually 
> tell you (by looking at the browser's status bar) where that takes you if 
> you click. 
>
> In fact if you read the TEXT on the Sourceforge page it tells you that the 
> download is starting automatically in 5 seconds.  "Your download will start 
> shortly" followed by "Your download will start in 5 seconds". Which 
> counts down to zero when it finally starts. 
>
> I have installed an adverts blocker in my browser so I don't even see 
> whatever 3rd party advert banner the site might want to show me. 
>
> See this screenshot for what I mean: 
> http://s28.postimg.org/5v08sx5yl/adverts.png 
>
> (on the screenshot I was downloading another program, not AOO, but the 
> point is made) 
>
> FC 
>
> PS: Every time I see someone saying "you should ditch Sourceforge" I'm 
> forced to repeat the same: Sourceforge.net has one feature that IMHO all 
> other alternatrives lack, namely LOCAL MIRRORS. I'm down in Argentina and 
> the nearest SF.net mirror is in Brazil, so my download is initiated from 
> the Brazilian mirror. SF.net has local mirrors all around the world 
> Link for a list of mirrors: 
> http://sourceforge.net/p/forge/documentation/Mirrors/ 
>
> ...which means users get faster downloads and ISPs do not overload 
> international pipes. 


Re: Hilferuf

2015-11-13 Thread Dave
Writer Tabelle? Meinst du eine Tabelle im Openoffice Calc wahrscheinlich.
Probiere es mal anhand meiner Anleitung unter openoffice-uni.org (Abschnitt
46). Sag bescheid, wenn es klappt. VG, Dave

Am 13. November 2015 um 18:00 schrieb siegfried.rh...@t-online.de <
siegfried.rh...@t-online.de>:

> Ich habe ein Problem mit Serienbriefen. Der Assistent stürzt ab, wenn ich
> versuche,
> einen Adressblock zu definieren. Meine Adressliste ist eine Writer-Tabelle.
> Wer kann
> mir helfen. Danke im Voraus.


Re: Verweise in Tabellen

2015-11-13 Thread Alois Klotz

Hallo Peter,
hier ist ein Vorschlag zur Lösung:
https://dl.dropboxusercontent.com/u/3483911/LO-divers/Handelsvolumen_V1.1-24.ods

Ich habe waagrecht und senkrecht 2 Hilfszeilen bzw. -spalten mit den 
Maximalwerten und den Monaten bzw. Jahren angelegt und damit kann man 
ohne Probleme mit wverweis und sverweis Monat und Jahr herausbekommen.

MfG Alois

--
www.easy4me.info

Semmel schrieb am 13.11.2015 um 13:19:


Moin *.*,

ich muss noch einmal nerven, da ich ein Verständnis- oder 
Umsetzungsproblem mit SVERWEIS habe.
Zum besseren Verständnis eine Tabellendarstellung unter: 
http://www.file-upload.net/download-11039857/Verweise.JPG.html


In der Tabelle stehen in der Zeile 4 verschiedene Jahre und in der 
Spalte A (A5:A16) verschiedene Monate (01.01.2015 bis 01.12.2015 - mit 
der Zellenformatierung "", so dass nur die Monate ausgegeben werden).

Innerhalb der Matrix B5:H16 stehen verschiedene Werte.

In der Zelle C20 wird der höchste Wert der Matrix ermittelt und ich 
möchte nun in Zelle E20 (bzw. E21) wissen, wann genau (Monat und Jahr) 
dieser Wert angefallen ist.


Die genutzte Formel in E20 [=SVERWEIS(C20;A5:H16;1)] oder auch 
[=SVERWEIS(MAX(B5:H16);A5:H16;1)] ergibt die Zahl "42339" (Zelle als 
"Zahl" formatiert) bzw. "Dezember", wenn die Zelle als "" 
formatiert wird (siehe Zelle F20). Ich kann in Zelle E20 auch die 
Formel [=MONAT(SVERWEIS(C20;A5:H16;1))] bzw. 
[=MONAT(SVERWEIS(MAX(B5:H16);A5:H16;1))] verwenden, dann ist das 
Ergebnis "12", was ebenso dem Dezember entspricht.

Die in Zelle E21 genutzte Formel [=WVERWEIS(C20;B4:H16;1)] ergibt "2011".

Beides (Monat und Jahr) sind aber ja nun ganz offensichtlich falsch, 
da der höchste Wert innerhalb der Matrix in Zelle E5 steht und damit 
die korrekte Zuordnung "01/ 2008" bzw. "Januar 2008" lauten müsste. In 
beiden Fällen "finden" SVERWEIS bzw. WVERWEIS aber die jeweils letzte 
Zeile bzw. die letzte Spalte der Matrix, was darauf schließen lässt, 
dass der korrekte Wert nicht gefunden wird. Kann das sein???
In der Zelle E5 steht die Zahl "233275,82" - lediglich formatiert mit 
zwei Nachkommastellen und "BLAU" und sie hat keine weiteren 
Nachkommastellen. Exakt dieser Wert wird durch [=MAX(B5:H16)] in die 
Zelle C20 übertragen. Weshalb also sollte der Wert mit SVERWEIS oder 
WVERWEIS nicht gefunden werden?
An der nicht angegeben Sortierfolge kann es doch wohl nicht liegen, da 
die Werte in der Spalte 1 (Spalte A) doch sortiert sind !?!?
Oder liegt es an den Leerzellen? (Kann aber eigentlich[?] auch nicht 
sein).


Sofern jemand die Tabelle selbst haben möchte: 
http://www.file-upload.net/download-11039984/Handelsvolumen_V1.1-24.ods.html


Ich kriege noch die Krise ... ;)

Liebe Grüße und für jede Hilfe dankbar, Peter.





Re: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Fernando Cassia
On Fri, Nov 13, 2015 at 12:34 AM, Larry Gusaas 
wrote:

> He may have javascript disable on his browser.


That is one good point. Specially since there´s been a lot of press given
to extensions that disable javascript, like NoScript for Firefox, and
others.

This site is specially useful, it will show you right at the top in one big
box if Javascript is enabled or disabled.

https://www.whatismybrowser.com/detect/is-javascript-enabled

Btw: maybe the download page could be tweaked to include <.NOSCRIPT.> tags
and the message "This page needs JavaScript to function, please enable it"
between em?
FC


-- 
During times of Universal Deceit, telling the truth becomes a revolutionary
act
Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
Revolucionario
- George Orwell


Re: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Fernando Cassia
On Fri, Nov 13, 2015 at 5:31 PM, jd1008  wrote:

> Javascript is evil..
> It is used to spy on your browsing activities.
> Not saying that openoffice.org's JS does that.
> Most websites install multiple javascripts on your computer.
> I asked a knowledgeable and savvy individual what did Sun Mucrosystems
> mean by "sandbox". He said "your entire machine".
>

You are confusing Javascript with Java. Different languages, different
implementations. JavaScript is a Netscape invention. Java is a Sun
Microsystems invention.

Most websites nowadays use JavaScript, not Java. GMail uses JavaScript, as
do all "AJAX" sites.

Java is rarely used on "web sites". Nowadays. Java is used on the server
side (Twitter runs atop Java - OpenJDK on their servers), or on desktops,
for full blown desktop apps, outside the browser (Think: the Vuze
bittorrent client, vuze.com, Jitsi, the open source Skype alternative, etc).

Regards,
FC
-- 
During times of Universal Deceit, telling the truth becomes a revolutionary
act
Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
Revolucionario
- George Orwell


Re: Apache OpenOffice 4.1.2 released

2015-11-13 Thread jd1008



On 11/13/2015 01:24 PM, Fernando Cassia wrote:

On Fri, Nov 13, 2015 at 12:34 AM, Larry Gusaas 
wrote:


He may have javascript disable on his browser.


That is one good point. Specially since there´s been a lot of press given
to extensions that disable javascript, like NoScript for Firefox, and
others.

This site is specially useful, it will show you right at the top in one big
box if Javascript is enabled or disabled.

https://www.whatismybrowser.com/detect/is-javascript-enabled

Btw: maybe the download page could be tweaked to include <.NOSCRIPT.> tags
and the message "This page needs JavaScript to function, please enable it"
between em?
FC

Javascript is evil..
It is used to spy on your browsing activities.
Not saying that openoffice.org's JS does that.
Most websites install multiple javascripts on your computer.
I asked a knowledgeable and savvy individual what did Sun Mucrosystems
mean by "sandbox". He said "your entire machine".



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



RE: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Dennis E. Hamilton
Andrea,

The original reporter did not receive any noscript message.  He got a download 
page that had no buttons for Downloading Full Release and for Downloading 
Language Pack.  Instead, there were two tiny circles, suggesting that the 
technique for filling in the correct links on the browser page failed.

In addition, the light-green area beneath the darker-green download information 
was empty.  This is usually where details about the release version, sizes, 
signatures, hashes, and some additional links appear.  I don't know where that 
data comes from, but it did not appear.

The Original reporter sent me screen shots that confirm this behavior.  In 
addition, if the version is changed from 4.1.2 to 4.1.1, everything works 
properly, according to a later report.

I don't know if that is enough to figure out a source of the difficulty.  

Although the original reporter used both Internet Explorer 11 and Chrome on 
Windows 10 Home, presenting the same problem, it was later discovered that the 
Edge browser opens the page just fine.

 - Dennis



> -Original Message-
> From: Andrea Pescetti [mailto:pesce...@apache.org]
> Sent: Friday, November 13, 2015 11:47
> To: users@openoffice.apache.org
> Subject: Re: Apache OpenOffice 4.1.2 released
> 
> Dennis E. Hamilton wrote:
> > I believe the frame with release information is retrieved from
> SourceForge.
> 
> No, nothing from SourceForge appears on the openoffice.org domain. We
> simply link to binary files provided by them.
> 
> All the JavaScript is custom and stored in SVN. People without
> JavaScript see this notice:
>---
> Apache OpenOffice Downloads - Official Site
> 
> The browser seems to have JavaScript disabled. This technique is used
> for showing the actual download link. If you want to download Apache
> OpenOffice anyway, click this text to choose from the alternative
> download webpage. You will have to navigate to the
> version/binaries/language subfolder and and download the file named
> Apache_OpenOffice_version_os_platform_package_language.ext. Our
> apologies for the inconvenience.
>---
> Considering that we are in 2015 (I mean: people who browse without
> Javascript are doing it deliberately and are having a non-standard
> browsing experience on most sites), this is already more than enough.
> 
> The "click this text" above links to
> http://sourceforge.net/projects/openofficeorg.mirror/files/ (surprise!
> this is where it comes from) and from there, without JavaScript, one can
> indeed browse to the folder and download OpenOffice with a mostly
> painless procedure (and no ads will be displayed).
> 
> Note: There's a typo ("and and") in the above text, I've just fixed it
> in revision 1714258.
> 
> Regards,
>Andrea.
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



RE: Apache OpenOffice 4.1.2 released

2015-11-13 Thread Dennis E. Hamilton
To complete the information that I could get from the original reporter, I
finally asked about refreshing his browser pages.  

That did it.

It worked for both Chrome and Internet Explorer.  The Edge browser did not
show the problem because the reporter had not been using it and so there was
no cache to rely on.

It appears that refreshing the browser is not an automatic behavior for some
folks.  

I am not certain what sort of remedy there is.  I don't know if there is a
way to obtain caching on the network while not caching in browsers, or
caching for less time in browsers.  

Clearing browser caches has undesirable consequences for the user.  I am
also uncertain what can be done at the servers to invalidate upstream caches
when the cache lifetime is too great.

If anyone has knowledge of remedies in this regard, advice on dev@
openoffice.apache.org would be very welcome.

 - Dennis

> -Original Message-
> From: Rory O'Farrell [mailto:ofarr...@iol.ie]
> Sent: Thursday, November 12, 2015 14:34
> To: users@openoffice.apache.org
> Cc: V. & B. Electric 
> Subject: Re: Apache OpenOffice 4.1.2 released
> 
> On Thu, 12 Nov 2015 13:57:40 -0800
> "V. & B. Electric"  wrote:
> 
> > Hello,
> > I was trying to download the Apache OpenOffice 4.1.2 new ver. released
> >  from below link: "
> > http://www.openoffice.org/download/; but there is no download
> available.
> > Could you tell me if it is really available or not.
> > Thank you for your time.
> 
> One should refresh the Browser page or delete the browser cache, to
> force a reload of the data.
> 
> --
> Rory O'Farrell 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org



Re: Verweise in Tabellen

2015-11-13 Thread Alois Klotz

Alois Klotz schrieb am 13.11.2015 um 20:43:
oder noch ein wenig kürzer mit *verweis*:
https://dl.dropboxusercontent.com/u/3483911/LO-divers/Handelsvolumen_V1.1-24-verweis.ods
MfG Alois
--
www.easy4me.info