Re: [users] Macros not active on new machine?
Mark Knecht wrote:
>
> Hi Terry,
>
>
> 1) I have an OO spreadsheet on one machine. It's called ibd100.ods.
> When I use this spreadsheet on this specific machine the macros work.
>
> 2) When I look at Tools->Macros->Organize Macros->OpenOffice.org Basic
> I see the macro existing under "My Macros->Standard->Module 1" named
> cptoa1.
>
> 3) When I transfer this spreadsheet to another machine the macros don't
> work.
>
> 4) On the new machine hen I look at "My Macros->Standard->Module 1"
> the cptoa1 macro doesn't exist explaining why it doesn't work.
>
> OK - how to get the macro out of the first machine and over to the
> second machine?
>
> Earlier Anthony suggested (I think) to export the macro. However when
> I use the 'Organizer' button I cannot find an export function to
> export the macro to a file. The help file doesn't talk about exporting
> macros as far as I can tell so far.
>
> Maybe the mistake is having the macro in the My Macros group? Should
> it be in the spreadsheet name group?
>
> Anyway, I still cannot get the macros over to the second machine so
> I'm really in need of some help.
>
> Thanks,
> Mark
>
> On 6/21/07, TerryJ <[EMAIL PROTECTED]> wrote:
>>
>> Are you using the .ods format? Macros would not, I think, be converted
>> to
>> the .xls format.
>>
>>
>> Mark Knecht wrote:
>> >
>>
>
First, to save a macro in a document (so that it is part of the document,
not in a "My Macros" library), open the editor (more in a moment). The
tool-bar should include a box containing a list of libraries. Your document
will be at the bottom of the list. The first time you open it, there will
be a blank window saying "".
Near the bottom of the window is a horizontal scroll bar. Right-click the
panel to the left of that. Select Insert >BASIC module. Paste or write
your macro code in the module.
To get the Editor, Tools >Macros >Organise Macros >OpenOffice.org Basic. On
the "Organise" dialogue, press the "Edit" button. There is a shortcut.
Tools >Customise : Choose your tab : Function "Application" : Category "Edit
Macros".
Secondly, you can export any module to a text file using the icon towards
the right end of the lower tool-bar in the Editor. The tool tip is "Save
Basic". The file will have the extension .bas. You can import any such
file into your module using the icon to the left, tool tip "Insert BASIC
source".
Finally, you can import macros using the Organiser. On the Organise
dialogue mentioned earlier, press the button labelled "Organiser". There is
an icon on or available for the Editor tool-bar with the tool tip "Select
Macro" which calls the dialogue and it can also be called from the Editor
menu Tools >Macros >Organise etc.
On the third tab ("Libraries"), select the location to which you wish to
import the macros. It lists the shared libraries, My Macros and open
documents. The "append" button is only enabled for the last two. That
button gets you a file browser-selector. Once you've chosen the source of
your macros, you get another dialogue. Mind how you go.
--
View this message in context:
http://www.nabble.com/Macros-not-active-on-new-machine--tf3937729.html#a11356025
Sent from the openoffice - users mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Poorly displayed fonts in OOo
Hello, You could try removing the offending user settings folders (after exiting all OOo processes) or, alternatively, copying the good folder to the recalcitrant accounts. Messy hacking, I know, but that's what you have to do with this software at times. Martin Cockburn wrote: > > Hello, > I am having a problem with fonts in OpenOffice that are being > displayed not as black but as a mix of RGB. The fonts are being > displayed both within the document and the menus. The greyed out > option in the menus are being shown as pink. This problem was first > noticed with OOo 2.1 but I have since upgraded to OOo 2.2 and the > problem persists. This happens with new accounts also but there is > one account that it dispalys correctly. I have checked the option in > OOo against this account for the other accounts and they appear the > same. The fonts are displayed correctly in other application and in > the title bar of OOo. > > The opeating system is Mac OS X 10.4 > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Poorly-displayed-fonts-in-OOo-tf3991351.html#a11355775 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Macros not active on new machine?
Are you using the .ods format? Macros would not, I think, be converted to the .xls format. Mark Knecht wrote: > > Hi Anthony, >The macro was developed on the first machine and in the spreadsheet > that I wanted to use it in. That spreadsheet should (I think) already > have the macro in it, shouldn't it? > >However when I move that spreadsheet to a second machine I don't > see the macro in the spreadsheet on the second machine. I go back to > the first machine and look at the spreadsheet I emailed and I do see > it. > >This leaves me confused as to where the macro resides. Is it in the > spreadsheet on the first machine or is it in OpenOffice on the first > machine? > >Is there anything I need to do on the second machine to enable > macros? I was guessing that maybe the second machine cannot run macros > at all until I enable some setting but I haven't found that yet. > >I'll try exporting the macro and moving it to the second machine > and then importing it there. > >Thanks for your help. > > cheers, > Mark > > On 6/18/07, Anthony Chilco <[EMAIL PROTECTED]> wrote: >> Hi Mark, >> On the PC where the macros work, go to the organize macros dialogue, >> click the 'Organizer' button and select the 'Libraries' tab. Find the >> macro, select it and click the 'export' button. Select the spreadsheet >> that you want them macro in, then click the import button. Import the >> library that you just exported. Save the spreadsheet. >> tc >> >> Mark Knecht wrote: >> > Hello, >> > I have a spreadsheet that has some conditional formatting macros in >> > it. If I email this spreadsheet to myself and then download it on a >> > new PC it seems the macros either aren't in the spreadsheet or aren't >> > activated. >> > >> > When I look in Tools-Macros->Organize Macros->Openoffice.org Basic >> > on the machine where they aren't working it seems I don't see the >> > macro that I see on the original machine. >> > >> > How do I transfer the macro as part of the spreadsheet so that >> > another user can use it? >> > >> > Thanks, >> > Mark >> > > > -- View this message in context: http://www.nabble.com/Macros-not-active-on-new-machine--tf3937729.html#a11243994 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to run macro on dialog startup?
adam.schirmacher wrote: > > Is there a way to run a macro upon the opening of a dialog? I don't mean > "when any dialog is oepened", but "when this specific dialog is opened". > > You can use a dialogue to run a macro. What exactly do you want to do? -- View this message in context: http://www.nabble.com/How-to-run-macro-on-dialog-startup--tf3923527.html#a11243950 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Say NO to the Microsoft Office format as an ISO standard
Hagar de l'Est wrote: > > Hi All, > > Please sign the petition here : http://www.noooxml.org/petition/ > (cookies have to be enabled for this site) > > Thanks, > > Hagar > > 2466 votes at this very minute. > > I appreciate your efforts, Hagar de l'Est. I saw your post on 8daysaweek.co.uk and voted. -- View this message in context: http://www.nabble.com/Say-NO-to-the-Microsoft-Office-format-as-an-ISO-standard-tf3958081.html#a11243909 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Decimal seperator
Christian Foerg wrote: > >>> On Friday June 01 2007 3:21 am, Christian Foerg wrote: >>> Hi guys, >>> >>> I've got a very annoying configuration problem. >>> My default language is German (Germany) so I'd like to have German >>> default settings. Except one: The decimal seperator. >>> Is it possible to change the default decimal seperator without >>> changing the default language? At the moment I see onely the option >>> to set the "decimal seperator key", with is not very helpfull. I've >>> already got a changed keyboard layout. >>> Thanks >>> Christian >>> Some informations: >>> OpenOffice 2.2.0 - English (GUI) >>> with german language >>> on Windows XP 32bit >>> and self made keyboard layout (German with dot on numblock) > >> On Friday June 01 2007 05:41 am, Dan Lewis wrote: >> Tools > Options > Language Settings > Languages. Uncheckthe "Decimal >> separator key". According to help, OOo should then usewhatever your >> keyboard software uses. If your keyboard software saysit is a "." , you >> should be alright.Dan > > That's not completely right. > The keyboard layout says "." and Calc writes a ".". > But won't interprete it like a decimal seperator. > So it converts the decimal numbers into DATES. > This behavior changes with the "Locale Settings". But I don't like to have > US settings like the annoying date formate. > > Another idea: > Is it possible to write your own "Locale Settings" to specifie such > things? > > > Thanks > > Christian > > You could use the German (Switzerland) locale. For an analysis of the subject, look at Villeroy's posts on the following thread: http://www.oooforum.org/forum/viewtopic.phtml?t=57522 -- View this message in context: http://www.nabble.com/Decimal-seperator-tf3850982.html#a10983063 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] BasicProviderImpl::getScript: no script!
mike scott-2 wrote:
>
> The title is the error message I'm receiving, in a message box with
> some not-useful clutter.
>
> I'm attempting an automated document conversion from OOo to word
> format, presently under XP for testing, while the final target wil be
> freebsd. To this end, I have a macro (cobbled together from bits found
> on the net) that will save the current document as a ms word document.
> This is stored in a library within the document, and I have the macro
> assigned to execute when the document is printed ("Bullzip PDF Printer"
> is how I make a pdf, also required) - it works fine interactively.
>
> However, when starting with the -pt flag (so running without the GUI),
> I get an error message popping up with that title gem. The print-to-PDF
> proceeds correctly after I dismiss the message box, but of course
> there's no .doc output file.
>
> Am I attempting something unreasonable here, or is there some arcane
> reason why this won't work?
>
>
> FWIW the macro is (from /somewhere/ on the 'net plus a mod or two!!)
>
> Sub StoreAsDOC
> Dim oDoc As Variant
> oDoc = ThisComponent
>
> oDoc.storeToURL( "file:///c|/temp/output1.doc", Array(
> MakePropertyValue( "FilterName", "MS Word 97" ) )
>
> End Sub
>
> Function MakePropertyValue( Optional cName As String, Optional uValue )
> As com.sun.star.beans.PropertyValue
>oPropertyValue = createUnoStruct( "com.sun.star.beans.PropertyValue"
> )
>If Not IsMissing( cName ) Then
> oPropertyValue.Name = cName
>EndIf
>If Not IsMissing( uValue ) Then
> oPropertyValue.Value = uValue
>EndIf
>MakePropertyValue() = oPropertyValue
>
> End Function
> --
> various incoming sites blocked because of spam; see
> http://www.scottsonline.org.uk for a list and openpgp crypto key
> (key fingerprint 2ACC 9F21 5103 F68C 7C32 9EA8 C949 81E1 31C9 1364)
> [EMAIL PROTECTED]Mike Scott, Harlow, Essex, England
>
>
The error means that the script is not being found. Have you changed the
location or the sub name since making the assignment? In any case, I would
remove the assignment and assign it again. Wait :
(Light flickers dimly.) Where is the macro located? If it is in a library
other than 'Standard' (or a library of the document from which you are
running it - unlikely), that library is not loaded. Put it in the
'Standard' library. Otherwise, you need a macro in the 'Standard' library
which loads the library containing the macro AND executes a script in that
library.
The Standard library loads when OOo is launched. It is possible you will
have to re-launch after moving the script to 'Standard' but, IIRC, it is
unnecessary.
--
View this message in context:
http://www.nabble.com/BasicProviderImpl%3A%3AgetScript%3A-no-script%21-tf3853176.html#a10923019
Sent from the openoffice - users mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OO causes xorg to hang when menu is clicked
Comments interlineated: Jeff Powell-3 wrote: > > I am getting a system hang with OO on a CentOS 5 system. > > Very often when I open a document (double click a desktop document) and > then click on the menu the xorg desktop pseudo freezes. The mouse will > be able to move in a subset of the current screen but all events go to > the netherworld. > > ssh in from another computer and "top" reveals that Xorg has 100% of the > CPU. > Is that the case whether OOo is running or not? If so, it's a problem with your CentOS installation. If not, what does 'top' show before and after you launch OOo? Do you ever log into the system otherwise than remotely and, if so, do you get similar results? > > Kill -9 xorg and system is fine. > > But you cannot run OOo with a GUI without X, can you? I would expect OOo to die with X. > I don't have this problem on my FC5/6 machines. I previously have FC5 on > this hardware without any OO trouble. > > CentOS 5 > kernel 2.6.18-8.1.3.el5 > OpenOffice.org 2.0 680m5(Build:9073) > 2 NVidia Quadro 4 dual screen cards four screen xinerama (4096x1280) > NVIDIA-Linux-x86-1.0-9755 > > > > -- View this message in context: http://www.nabble.com/OO-causes-xorg-to-hang-when-menu-is-clicked-tf3853369.html#a10922937 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc: eval fcn and store value
Kenn Goutal wrote: > > In Calc, I want to be able to store the VALUE of the current date -- > whatever it is -- > into a particular cell, such that at some future date it will still show > today's date. > > That is, if today is June 1, 2007, I want to store *that*, > not an expression that today evaluates to that > and tomorrow evaluates to June 2, 2007 > and next week evaluates to June 8, 2007. > > I mean, I can probably look somewhere else on my monitor, note the time, > and type it in by hand, but that (for me) is error-prone. > > So I'd rather roll up whatever would do this into a macro of some kind, > bind it to a key or an icon on a toolbar, and use that. > > Is this possible? > > There is a date/time extension or macro on www.ooomacros.org. The following script will serve. Note that it uses a time format. You will have to substitute the date format you want to use. If you want to use a Cell Style instead of hard formatting, you can substitute the style name for that shown. If no style exists by the name shown, that part of the script is bypassed. ' Sub InsertNowString 'inserts the present value of now() as a string and applies appropriate style Dim aLocale as new com.sun.star.lang.Locale, oDoc as Object, oCell as Object, _ sFormat as String, vNumFormat oDoc = ThisComponent : oCell = oDoc.CurrentSelection If NOT oCell.supportsService( "com.sun.star.sheet.SheetCell" ) Then : Exit Sub : End If oCell.FormulaLocal = cStr( Now() ) If oDoc.StyleFamilies.CellStyles.hasByName( "_Time" ) Then ' alter style name here oCell.CellStyle = "_Time" ' alter style name here Else sFormat = "HH:MM AM/PM" ' alter the format to suit your requirements vNumFormat = oDoc.getNumberFormats().queryKey( sFormat, aLocale, TRUE ) If ( vNumFormat = -1 ) Then vNumFormat = oDoc.getNumberFormats().addNew( sFormat, aLocale ) End If oCell.NumberFormat = vNumFormat End If End Sub ' -- View this message in context: http://www.nabble.com/Calc%3A-eval-fcn-and-store-value-tf3854569.html#a10922887 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] File-extension management
jimw wagner wrote: > > The other day I loaded the latest Ubuntu, and with it came OO-2.2.2 > included. > > In the process of saving files, I find that it does not have the dialog > which allows one to change the file-extension. That is, you can put in > the new file extension, but unless you specifically erase the previous > extension, it just adds the new one to that. For instance, X.html > becomes X.html.odt. > > It's entirely possible that I've missed something in the dialog, and > it's also possible that I might have to go through the 'alien' system > and change the RPMs. I don't want to go to that trouble, though, if it > won't solve my problem. > > Thanks, > > JimW > > I'd be happy for the distros to mess with the software if they did not make a mess doing it. This may actually be a result of the Gnome dialogues being used instead of OOo dialogues. See whether you have the following option: Tools >Options >OOo >General : Open/Save Dialogues : Use OpenOffice.org dialogues -- View this message in context: http://www.nabble.com/File-extension-management-tf3854985.html#a10922794 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Decimal seperator
Christian Foerg wrote: > > Hi guys, > > I've got a very annoying configuration problem. > My default language is German (Germany) so I'd like to have German default > settings. > Except one: The decimal seperator. > > Is it possible to change the default decimal seperator without changing > the default language? > At the moment I see onely the option to set the "decimal seperator key", > with is not very helpfull. I've already got a changed keyboard layout. > > Thanks > > Christian > > Some informations: > OpenOffice 2.2.0 - English (GUI) > with german language > on Windows XP 32bit > and self made keyboard layout (German with dot on numblock) > > The decimal separator is associated with the locale rather than the language. I have de-selected "Decimal separator key : Same as locale setting ( . )" and it seems to make no difference. A German (Switzerland) locale, I understand, uses the point as a decimal separator. -- View this message in context: http://www.nabble.com/Decimal-seperator-tf3850982.html#a10910357 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Language settings in formulas (Calc)
Verner Kjærsgaard wrote: > > Hi list, > > - foregive me, but I can't seem to find this.. > - I'm using OO v2.2 Danish on Linux. Works sweet. > > - I'd like to use the original english function names when writing > formulas in > Calc. > > - in other words, I'd like to write something like: > > =if(some-condition) instead of this > > =hvis(some-conditioin..) > > > -- > - > Med venlig hilsen/Best regards > Verner Kjærsgaard > > Hi. I don't claim to understand this, but the following post may help, especially the first paragraph: http://www.oooforum.org/forum/viewtopic.phtml?p=192365#192365 It seems that it would help to install an English language pack. ?¿ -- View this message in context: http://www.nabble.com/Language-settings-in-formulas-%28Calc%29-tf3834438.html#a10907287 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Missing VCL resource
Richard G Morrison wrote: > > I downloaded and installed Open Office 2 twice with the same subject > error. > It then returned "language Not Determined". I'm running WinXP SP2. Can you > tell me what's wrong? > > One thing you should check, especially when you cannot install the downloaded file, is the md5sum, which is a type of checksum. See the following page which contains various md5sums and a link to an instructions page: http://download.openoffice.org/2.2.0/md5sums.html If the md5sum is wrong, you may need to use different software to download the file. If it is correct, it might help if you provide the full name of the file you downloaded. -- View this message in context: http://www.nabble.com/Missing-VCL-resource-tf3843712.html#a10907193 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Missing vcl resource
Derek van der Watt wrote: > > Hi > > I extracted the four archives into a selected folder and tried to double > click on the application link to open the program and it said 'missing vcl > resource. ..it may be a corrupt installation...' - can you help? > > derek van der watt > 01793325521 > 07872175759 > > I think you need to provide more information. My recollection of vcl resources is that they relate to language packs and / or fonts. -- View this message in context: http://www.nabble.com/Missing-vcl-resource-tf3843732.html#a10907104 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Recording & Using Macros
Russell Butler wrote: > > Mitchel Cohen wrote: >> I'm trying to extract email addresses from a list that includes other >> information as well that I've compiled in an openoffice writer document. >> Fortunately (for my tired brain, anyway), each email address is at the >> end of each line. So, I've managed to figure out how to highlight, >> copy, and paste each email message in a list to another document-page >> and save the Macro as a keyboard combination. >> >> BUT, when I go to the other page, nothing has copied there. And, when I >> look at the original page, there cursor has moved down just one row. >> >> So, there are 2 problems (at least): >> >> 1) how to embed my Macro within a Macro so that it repeats until the end >> of the document? and >> >> 2) how to get each address to paste to the other page? >> >> Both of these seemed simple enough, but they're not working. >> >> 3) is there something besides the OpenOffice help menu to walk one >> through making Macros step by step? >> >> Thanx. >> >> Mitchel > > Hi Mitchel > > I can't help you, but have you had a look at http://www.ooomacros.org/ ? > > There are a number of potential links at > http://www.oooforum.org/forum/viewtopic.phtml?t=50952&sid=340887e6122d1b0886a286a8bfd6a230 > > HTH > > Russell > > Is the text in a format which would convert to a table using Table >Convert? If so, you would presumably finish with all email addresses in the rightmost column, from which they could be copied and pasted in the ordinary way. -- View this message in context: http://www.nabble.com/Re%3A-Recording---Using-Macros-tf3845184.html#a10907063 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Macro
Dan Lewis wrote: > > On Thursday May 31 2007 2:35 pm, Don Durand wrote: >> Is there a way to import (or use) an Excel macro (.xla) into Calc? >> >> Thanks. > > Yes and no. Excel and Calc use two different but somewhat similar > macro languages. The Excel macro has to be modified before it will > work in Calc, and a Calc macro has to modified before it will work > in Excel. > > Dan > > I gather that the versions provided by Novell will execute script written in Visual Basic. -- View this message in context: http://www.nabble.com/Macro-tf3849107.html#a10906995 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I have a problem
Indira Carvajal wrote: > > TENGO UN PROBLEMA CON OPENOFFICE > > EN CUANTO A LA OPCIÓN QUE EN EXCEL SE DENOMINA: CENTRAR LA SELECCIÓN A > NIVEL > HORIZONTAL. > > ESTO INGRESANDO POR FORMATO DE CELDAS -- ALINEACIÓN -- HORIZONTAL --- > CENTRAR EN LA SELECCIÓN: Centra el contenido de una celda respecto a todas > las celdas en blanco seleccionadas a la derecha, o de la siguiente celda > en > la selección que contiene datos. Sin necesidad de combinar celda.-. > > Cuál es el equivalente en openoffice > > -- > I HAVE A PROBLEM WITH OPENOFFICE As far as The OPTION THAT IN EXCEL IS > DENOMINATED: TO CENTER The HORIZONTAL SELECTION At LEVEL. THIS ENTERING BY > FORMAT OF CELLS -- ALIGNMENT -- HORIZONTAL --- TO CENTER IN THE SELECTION: > It centers the content of a cell with respect to all the cells in target > selected to the right, or of the following cell in the selection that > contains data. With no need to combine cell. -. > > Which is the equivalent one in openoffice? > > > > Indira Carvajal > +584124809997 > > Format >Cells : Alignment : Text Alignment : Horizontal -- View this message in context: http://www.nabble.com/I-have-a-problem-tf3813267.html#a10815883 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] installation
René Petignat wrote: > > Hello, > I've tried to install the french version of OpenOffice but I obtained a > message "error 1935". > Could you tell me what it means ? > Thanks a lot > Rene > It means you have to stop your anti-virus software running while you install OOo, which means you need to go off line. -- View this message in context: http://www.nabble.com/installation-tf3809029.html#a10780794 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Use of templates in 2.2.0
Graham Davis-2 wrote: > > What's happened to the templates in 2.2.0? When I try to create a letter > from a template I no longer get a WYSIWYG display. What I get is a mess > with numerous "Sender (fixed)" and "Placeholder" fields. Other fields are > in the form "User field x = y". > > -- > Graham P Davis > Bracknell, Berks., UK > Send e-mails to "newsman" as mails to "newsboy" are ignored. > > Just a guess, really. View >Field Names is selected. ;) -- View this message in context: http://www.nabble.com/Use-of-templates-in-2.2.0-tf3808477.html#a10780791 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] .ods file has been corrupt
noop-3 wrote: > > On 05/23/2007 04:50 PM, TerryJ wrote: > > >> >> Whatever happened when OOo moved to the new server? I'll need a wider >> room >> before I get a screen that wide. (Slight exaggeration.) >> >> I understand that the password (no longer in its pristine form) will >> prevent >> the use of the standard procedure. > > Used to be only the revision history pages & a few others. I've filed a > bug report: > > http://www.openoffice.org/issues/show_bug.cgi?id=77434 > > I voted for the issue. Fonts display extremely large and horizontal scrolling is required on any OOo page I've visited since the changeover. Other users have reported the same phenomenon. Come to think of it, I should add those comments. -- View this message in context: http://www.nabble.com/.ods-file-has-been-corrupt-tf3798440.html#a10776195 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] looking for python integration help
David Bear wrote: > > I'd like to find some group that can help me with python and UNO > integration. > > any pointers? > > > -- > David Bear > College of Public Programs at Arizona State University > > Try the Macros & API section of www.oooforum.org. The UNO project has mailing lists: http://udk.openoffice.org/servlets/ProjectMailingListList -- View this message in context: http://www.nabble.com/looking-for-python-integration-help-tf3807107.html#a10775145 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] .ods file has been corrupt
noop-3 wrote: > > On 05/22/2007 11:49 PM, TerryJ wrote: >> >> >> Shalin Shah wrote: >>> >>> >>> >>> >> >> > > Similar instructions are here: > > http://documentation.openoffice.org/HOW_TO/misc/Troubleshooting_guide.html > [Recovering content from a damaged OpenOffice.org file 7] > course you'll need a wide-screen monitor to read the page without > scrolling back & forth... > > Whatever happened when OOo moved to the new server? I'll need a wider room before I get a screen that wide. (Slight exaggeration.) I understand that the password (no longer in its pristine form) will prevent the use of the standard procedure. -- View this message in context: http://www.nabble.com/.ods-file-has-been-corrupt-tf3798440.html#a10775118 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] .ods file has been corrupt
Shalin Shah wrote: > > > Hi, > > i am using following version of open office and i have lost my data from > one > of the most improted file, that file is password protected and once i > enter > pass work it's give me the error: > > The File mastersheet of dealers april -07.ods is corrupt and therefore can > not be oppened.should oppenoffice.org will repair the file. > > > > * I am using version of OpenOffice.org. 2.0 > * > * My problem is : as above underline. > > would requiest you to please help me to resove this issue and do the > needful. > > > Warm Regards, > > Shalin Shah > > Actis Technologies Pvt. Ltd. > > 712,714- 7th floor, Milestone, Adjacent to drive in Cinema,Drive in Road, > Thaltej, Ahmedabad -380054. > 079-27434589 | Hand-phone: +91 - 9327516689 > The No. 1 Audio Visual Control Solutions Provider in India > > I hope you have an older version of the file. A corrupted file can normally, I understand, be recovered but not if you have used password "protection". The use of a password seems to result fairly often in corruption of the file, judging by the number of requests such as yours both here and on the forum. The software should really carry a warning about its experimental nature. There is a password cracker on www.ooomacros.org and another has been mentioned in recent articles. To deal with corruption, I have the following links. As I say, I believe the so-called protection will stop you from salvaging any data from the file. hol.sten's links: http://www.oooforum.org/forum/viewtopic.phtml?t=24208 http://www.oooforum.org/forum/viewtopic.phtml?t=23146 http://www.oooforum.org/forum/viewtopic.phtml?t=20840 macro to repair (windoze): http://www.oooforum.org/forum/viewtopic.phtml?t=45473 other links: http://www.oooforum.org/forum/viewtopic.phtml?t=33263 http://www.oooforum.org/forum/viewtopic.phtml?t=33210 http://www.oooforum.org/forum/viewtopic.phtml?t=24208 http://www.oooforum.org/forum/viewtopic.phtml?t=30992 http://www.oooforum.org/forum/viewtopic.phtml?t=31277 script to recover: http://www.oooforum.org/forum/viewtopic.phtml?t=34891 One user: Thanks for the effort! Here's how I did it: 1. renamed the defective file extension to .zip 2. extracted content of the .zip file 3. opened content.xml with Dreamweaver, selected in the view menu to show errored lines (shows the bad text with yellow background) and removed them. 4. did the same with style.xml 5. updated the .zip file and renamed it back to .ods Some styling was removed but the file worked and all the data was in it! Cheers! -- View this message in context: http://www.nabble.com/.ods-file-has-been-corrupt-tf3798440.html#a10758424 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] how to open text file in open office calc
Leny wrote: > > Hi there, > > How to open text file (.txt, .csv, .tsv) in open office calc? > > when I choose a file (example .txt file) it automatically open by open > office writer . If I see the documentation, it explain that there's "the > In > the dialog that appears next, select the Separator options" > > I cannot find the dialog box and the separator option. > > Pls help.. > > > > tx > > Leny > > An issue has been filed about this but the developers don't get it. The convoluted workaround is to use File >Open, first select the file you want to open, then select the file type (in the appropriate box) ".csv". -- View this message in context: http://www.nabble.com/how-to-open-text-file-in-open-office-calc-tf3798435.html#a10754254 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] hello
m.a.j.o wrote: > > this is victor from india > well in the open office package, I do not find applications such as > outlook express or mozilla thunderbird > r u planning to comeout with similar type of applications also > victor > A statement was reported some time last year to the effect that Firefox and Thunderbird would be integrated into a package with OpenOffice.org. OOo has enough on its plate with its existing software. -- View this message in context: http://www.nabble.com/hello-tf3800814.html#a10754253 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] LOOKUP reference problem
KEN KLASSEN wrote: > > I cannot comprehend any of this and do not think it has any reference to > my problem. Thanks. > > Ken > - Original Message - > From: JosephK<mailto:[EMAIL PROTECTED]> > To: users@openoffice.org<mailto:users@openoffice.org> > Sent: Sunday, May 20, 2007 6:27 AM > Subject: Re: [users] LOOKUP reference problem > > > On 05:00 Sun 20 May , TerryJ wrote: > > > > Joseph K > > Hi, Ken. You have wandered on to the wrong thread. If you are using an email client, you need to set it to sort messages by thread rather than time of receipt. -- View this message in context: http://www.nabble.com/LOOKUP-reference-problem-tf3785120.html#a10705989 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] LOOKUP reference problem
JosephK wrote: > > On 05:00 Sun 20 May , TerryJ wrote: >> >> >> >> JosephK wrote: >> > >> > On 11:17 Sun 20 May , Brian Barker wrote: >> >> At 10:05 20/05/2007 +0100, JosephK wrote: >> >> >Is it possible to use the contents of a cell as the column or row >> index >> >> >reference in VLOOKUP or HLOOKUP? >> >> >> > the column header or number. First formula attempt was: >> >=VLOOKUP(D2;Prices.$A$1:$D$4;HLOOKUP(C2;Prices.$A$1:$D$4;1)) >> > in cell F2 >> > >> > Customer table:- >> > A B C D E F >> > 1 AccountName CustomerNamePriceList ItemPrice >> > 2 Account1Apex TradingPriceList1 Item1 >> Err:502 >> > 3 Account2Beta CompanyPriceList2 Item2 >> Err:502 >> > 4 Account3Crash Computers PriceList1 >> > 5 Account4Other Company PriceList3 >> > >> > Prices table:- >> > A B CD >> > 1PriceList1PriceList2 PriceList3 >> > 2 Item1 10 2119 >> > 3 Item2 15 2325 >> > 4 Item3 18 2734 >> > >> >> The nested formula has to return an integer. In other words, the price >> list >> reference has to be the equivalent of the offset number in the price >> list. >> -- >> View this message in context: >> http://www.nabble.com/LOOKUP-reference-problem-tf3785120.html#a10705257 >> Sent from the openoffice - users mailing list archive at Nabble.com. >> > Got It. Thanks Terry. Used MATCH instead of HLOOKUP >=VLOOKUP(D2;Prices.$A$1:$D$4;MATCH(C2;Prices.$A$1:$A$4;1)) > works fine > > Regards > -- > It is often safer to be in chains than to be free. > > Joseph K > > MATCH is the ideal solution. -- View this message in context: http://www.nabble.com/LOOKUP-reference-problem-tf3785120.html#a10705965 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] LOOKUP reference problem
JosephK wrote: > > On 11:17 Sun 20 May , Brian Barker wrote: >> At 10:05 20/05/2007 +0100, JosephK wrote: >> >Is it possible to use the contents of a cell as the column or row index >> >reference in VLOOKUP or HLOOKUP? >> >> A simple test shows that the answer is yes: there is no reason why >> the third "index" parameter of VLOOKUP or HLOOKUP cannot be an >> expression, so it can certainly be a cell reference. If the relevant >> cell in the record for the customer contains the appropriate column >> number in the price list, what you describe ought to work. >> >> If, as you say, this doesn't work for you, I suppose the most likely >> problem is that you have the syntax of the function reference >> slightly wrong. Can you perhaps check this? Is it something as >> simple as a comma in place of a semicolon as parameter >> separator? Can you construct a miniature version with only a few >> entries on a single sheet and get that to work first - and then >> extend it to the real case? Failing that, you may like to write back >> to the list with details of the actual result: do you get the wrong >> answer or no answer or an error? Can you copy the function reference >> into your message? (Don't send any actual customer information, of >> course.) >> > > I tried building the formula bit by bit. All the separate parts work > individually but the offset part of the LOOKUP does not seem to accept a > formula as a reference; it needs a string or integer corresponding to > the column header or number. First formula attempt was: >=VLOOKUP(D2;Prices.$A$1:$D$4;HLOOKUP(C2;Prices.$A$1:$D$4;1)) > in cell F2 > > Customer table:- > A B C D E F > 1 AccountName CustomerNamePriceList ItemPrice > 2 Account1Apex TradingPriceList1 Item1 Err:502 > 3 Account2Beta CompanyPriceList2 Item2 Err:502 > 4 Account3Crash Computers PriceList1 > 5 Account4Other Company PriceList3 > > Prices table:- > A B CD > 1PriceList1PriceList2 PriceList3 > 2 Item1 10 2119 > 3 Item2 15 2325 > 4 Item3 18 2734 > > Also tried wrapping the HLOOKUP in a COL() to get the column number but > the ref bit is always read as a formula and not a number or string > > The error I get is Err:502 which is I believe More Than One Result > > Regards > -- > It is often safer to be in chains than to be free. > Joseph K > > The nested formula has to return an integer. In other words, the price list reference has to be the equivalent of the offset number in the price list. -- View this message in context: http://www.nabble.com/LOOKUP-reference-problem-tf3785120.html#a10705257 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] LOOKUP reference problem
JosephK wrote: > > Is it possible to use the contents of a cell as the column or row index > reference in VLOOKUP or HLOOKUP? > > My scenario is I have a table of 5000 customers with contact details > etc. Another table holds prices for about 300 different products. Each > customer or group of customers has a different price list according to > negotiated contracts. > > One field of my customers table holds the particular price list that > customer uses and the Prices table has fields for the different price > lists (Approx 50 different lists). > > I am trying to do a lookup such that I enter a product and get the price > of that product from the relevant price list. I've tried using HLOOKUP > within a VLOOKUP using the customers pricelist field as a column > reference but this does not work. > > Any ideas would be very welcome! > > Regards > -- > It is often safer to be in chains than to be free. > Joseph K > > So, your VLOOKUP finds the customer's identity in your "customers table" and returns the information in column x which tells you which price list is applicable? How is that information expressed? Let's suppose it is a column number or letter in the "prices table". I think it needs to be a number which can be used as an offset in a VLOOKUP formula. Then you can have a VLOOKUP formula within another. The nested formula returns the offset column number in the "prices table". So you have something like: =VLOOKUP(item id; prices table; VLOOKUP(customer id; customers table; price list column; 0); 0 ) -- View this message in context: http://www.nabble.com/LOOKUP-reference-problem-tf3785120.html#a10704343 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] clipboard does not clear and repeats a paste Copy time after time
Marlene Jones wrote: > > I have a Mac OS X > and OpenOffice.org 2.0 > Yesterday I copied a recipe off the Internet and stored it as a > document. Today I tried three times to copy and transfer another > document as e-mail text. All three times the recipe appeared. > Normally the clipboard should have cleared the first time I Pasted > the recipe. > > Is there anyway to send fils as attachments using OpenOffice 2.0? > > Appreciate anything that's free, the software, your advice. > > Much Obliged, > > Marlene Jones > > Your problem with the clipboard is quite different from the problem discussed in the only other thread I've seen: cannot copy & paste / 2 separate clipboards? - http://www.oooforum.org/forum/viewtopic.phtml?t=37728 The Mac support page is http://porting.openoffice.org/mac/support.html . If your question is not answered in the Mac FAQs, you can, evidently, ask on the Mac (dev) list. I'm not sure what your second question means. Have a look at File >Send >>. An email client can attach an OOo document to an email. -- View this message in context: http://www.nabble.com/clipboard-does-not-clear-and-repeats-a-paste-Copy-time-after-time-tf3785000.html#a10704269 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] copying, installing, importing, exporting macros and dialogs
Siegfried Wolkenstein wrote: > > Hello, > > I wrote a macro with some dialogs. Now I would like to give it to someone > who > needs it. How can I provide him with an easy method of installing my > macros? > Also I don't know how export the macros nor the dialogs. > > Thanks > > Hello, If you feel adventurous, you could try the Extensions Packager: http://wiki.services.openoffice.org/wiki/Extensions_Packager Otherwise, the simplest way is probably to copy the files in your user settings folder. On my Linux OS, the path is ~/.openoffice.org2/user/basic/. It would be tidier if you create a separate library. It is possible to export a Basic module to a text file (extension .bas) using the icon at or near the extreme right of the "macro" tool-bar in the Basic editor. There is no similar mechanism for exporting a dialogue. IIRC, there is at least one link to a thread dealing with distribution in the thread http://www.oooforum.org/forum/viewtopic.phtml?t=50952 -- View this message in context: http://www.nabble.com/copying%2C-installing%2C-importing%2C-exporting-macros-and-dialogs-tf3772342.html#a10675421 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Dbase driver and PHP
Abul Kashem Md. Hasan wrote: > > > Can I use openoffice dbase driver to connect a dbase file from PHP. > > Regards. > > Abul Kashem Md. Hasan > Associate Specialist, Database/IT > Center for Environmental and Geographic Information Services (CEGIS) > House # 6, Road # 23/C > Gulshan - 1, Dhaka - 1212 > Phone: 8821570-2, 8817648 - 52, Ext-501 > email: [EMAIL PROTECTED] > Web: http://www.cegisbd.com > > If you have no luck here, you could try the Base section of www.oooforum.org or one of the Base mailing lists: http://dba.openoffice.org/servlets/ProjectMailingListList -- View this message in context: http://www.nabble.com/Dbase-driver-and-PHP-tf3767846.html#a10659556 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Templates
James Elliott-2 wrote: > > A conversation with another user prompted this question: > > When I upgrade my OOo by installing the latest version, how come I get to > keep my Templates? > > I am using OOo under Windows XP and after installing the latest version of > OOo, if I right click on the icon near the clock and select "From > Template", > all the usual items come up on the list: invoice template; letterhead; > purchase order form; quote template; etc. > > On the other hand, upgrading always loses my Australian Dictionary and I > need to copy the relevant ".au" files from my previous version. > > I have determined that the Template files are kept in a folder called > ... application data/OpenOffice.org?/user/templates > where the "?" represents, in my case: > > 1.1 > 1.1.0 > 1.1.4 > 2 > > The folder: ...application data/OpenOffice.org2/user/templates, seems to > contain all the templates I use, but some of them were created in earlier > versions of OOo. Also, some of the previous versions have templates in > thier ... user/template folders too. > > I look forward to yoru advice - many thanks, James > > The templates are filed in your user settings' folder. You can install the dictionary there as well. If you use the wizard (which I would not recommend after trying it), it will install in your user settings' folder. The file which most annoys people is dictionary.lst, which lists the dictionaries to be loaded on start up. That is located amongst the software files and is overwritten on a new installation. At least one issue has been filed about overwriting of customisations. Hagar de l'Est or someone equally versed in such matters may be able to provide details. -- View this message in context: http://www.nabble.com/Templates-tf3767827.html#a10659533 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] OOo Users Group
Talk on the forum about the need for improvements led to one member suggesting an OOo Users' Group. For a glimmering of what that might mean, look at the following and ensuing posts: http://www.oooforum.org/forum/viewtopic.phtml?p=225295#225295 If the forum members are left to their own devices, one of two things will happen: 1. Nothing; 2. A new forum. If anyone thinks the opportunity is ripe for something of wider appeal, perhaps they could add their thoughts to that discussion. Anything more than this message may be off topic here and I'm never sure whether the discussion list is actually alive. -- View this message in context: http://www.nabble.com/OOo-Users-Group-tf3770229.html#a10659432 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] font-selection crashes some openoffice versions
Bernt Christandl wrote: > > > Hello, > > i have a puzzle that i can't solve and would need some help: > > I have 3 versions of OOo installed into different subdirectories on our > fileserver: 2.2, 2.1, 2.0.4 > > and i have 3 (types of) PCs running some version of > (selfmade/Debian-based) linux > all accessing the same/identical openoffice-software: > Type A: kernel 2.6.18.1 with gcc-3.4.5 and glibc-2.3 > Type B: kernel 2.6.20.1 with gcc-4.1.1 and glibc-2.3 and > Type C: kernel 2.6.21.1 with gcc-4.1.2 and glibc-2.5 > > Now when i start OOo, do a "Ctrl_N" for a new text document and > after that comes up, click on the little black triangle right > of the font-selection field, to get the list of available fonts > to select another one, in some combinations OOo crashes completely: > >Machine | OOo22 | OOo21 | OOo204 >-- > A | works | works | works > B | crash | crash | works > C | crash | crash | works >-- > > When i click on that very similar font-size-selection triangle > in all cases the list of available sizes unfoldes. > > And when i do not try to select another font, i can enter text > with the upcoming one. > > Any ideas what kind of a problem i have and how to solve it? > > Thanx! > > Bernt Christandl > > Have you tried running a debugger or strace? -- View this message in context: http://www.nabble.com/font-selection-crashes-some-openoffice-versions-tf3757036.html#a10623917 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problems in openoffice calc
sergio vanetti wrote: > > The databank formula (dsum())in Openoffice calc, if > you have some data in parentesis () the formula > doesn't work. > Please, see the attach file (there are no virus) > I hope to help all the Openoffice users. > > > Sérgio Vanetti > Brazil > São Paulo - SP > > The attachment has been removed from your message. You can upload it to somewhere like http://www.mediafire.com/ and post the link to the list. -- View this message in context: http://www.nabble.com/Problems-in-openoffice-calc-tf3754048.html#a10623902 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Help to use in Open office
nitin-6 wrote: > > Dear Sir, > I am Using open office in win98 operating system but network file's are > not open direcly, i will open first blank file and than open > file-open-than file, it is long process i want to open a networ file > direcly like ms-office give support & help to using open office. > > Thanking You, > Nitin > > There are several threads on the forum dealing with difficulties opening files over networks. This is one: http://www.oooforum.org/forum/viewtopic.phtml?t=47172 -- View this message in context: http://www.nabble.com/Help-to-use-in-Open-office-tf3731754.html#a10530384 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc: empty toolbar I cannot get rid of
Kenn Goutal wrote: > > I have somehow wound up with an empty toolbar that I cannot get rid of. > See: > > http://www.flickr.com/photos/[EMAIL PROTECTED]/494998377/ > > Come to that, I can't even find any reference to it in > Tools->Customize-/Toolbars\. > That is, there is no toolbar listed there with no icons in it, > or even a toolbar with all its icons disabled. > > Can anyone think of a way to find this toolbar, and get rid of it? > > I'm running OO.o 2.0 on WinXP+SP2. > TIA. > > I am using a Linux OS, so my OOo interface is probably different from yours. The image resembles the part of a tool-bar which I can grab to move it. It disappears if I lock the tool-bar in position. -- View this message in context: http://www.nabble.com/Calc%3A--empty-toolbar-I-cannot-get-rid-of-tf3732582.html#a10519346 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] corrective to Problem while using OpenOffice.org with macro OOoLilyPond/basic/script.xlb -see attachemnt-
Ledocq-Boccart wrote: > > please disregard the previous message and replace it by this one! > see 2 corrections shown hereafter between *** > > I am using OpenOffice.org version 2.0.3 on winXP . My problem is : > > on OpenOffice.org with macro Ctrl+M from OOoLilyPond (version 2.10) > > The Ctrl+M macro does not start anymore, even after new installation of > all LilyPond, OOoLilypond and OpenOffice.org version 2.0.3 ! > I even have cleaned the registry (I use regularly Regseeker without > trouble). > > OOoLilypond, OpenOffice.org and LilyPond are all installed in c:\Program > Files\ > The library script.xlb and the ctrl+M have been carefully installed > according to the instructio given with OOoLilyPond, excepted that the > macro is refused to be installed in the Macro OpenOffice Library (the > ***Append*** button is not activable when selecting the radio button > "Macros > OpenOffice"; I have installed it in My Macros file, wihch allows to > activate the button ***"append"***. > Customization of ctrl+M has been done according to instructions. > > What happens > while opening a writer document with OpenOffice.org: > > typing Ctrl+M, Enter >gives an error message of OpenOffice.org: "incorrect value or data > type: index outside defined range" > > together with a sreen showing the basic instructions with one marked > with ared arrow flag in the left column "ReDim Preserve sTemplate(i-1) > As String". > > (see screenshot image in attachement) > > Could somebody help to find a solution to this? > > Thanks for answer > > Charlie > > Hi. You can upload a file to http://www.mediafire.com/ and provide a link to the list to enable access. The error means that the number you get from the formula i-1 is not within the index range of whatever is being referenced. In other words, suppose the names are indexed 0 to 9, your formula may produce -1. You really need to copy the whole macro to a text document and upload it for someone to look at. -- View this message in context: http://www.nabble.com/corrective-to-Problem-while-using-OpenOffice.org-with--macro-OOoLilyPond-basic-script.xlb--see-attachemnt--tf3731755.html#a10459367 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] helpful advice
Joe Grech wrote: > > To all who can help.. > I intend to compile a book using various extracts from different sites. > They are all different as regards fonts etc. I presume this book, > including > numerous coloured pix and diagrams, will run to a couple of hundred pages. > Any suggestions as how to go about it. I am using OOo2.2 Writer. > Although > I ain't an expert but i can handle the prog quite well. > Thanks folk. > > If you are set on using Writer, I would look at the "master document" method rather than having one gigantic document which you are likely to find increasingly difficult to open and save. I would look at options other than Writer, such as Scribus. -- View this message in context: http://www.nabble.com/helpful-advice-tf3721288.html#a10441202 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] HyperLink Background Color
Featherstone D. S. wrote: > > Hi, > > Thanks for a great product. I imported an Excel spreadsheet and > everything works great but I do have a question. In all the cells > that have HyperLinks, url's & email address', there is a blue > background around the link and I can't get rid of it. I have > attempted to change the font color and the background fill color to > no avail. Am I stuck with this background color or can I eliminate it > altogether. Since both the background & the font is colored blue I'd > like at the very least be able to change one of the colors so the > links are easier to read, but I have been unable to. Can you provide > some assistance?? Thanks and have a great day!! > > Scott Featherstone > [EMAIL PROTECTED] > > Hosa 10:12 > > Sow for yourselves righteousness, > reap the fruit of unfailing love, > and break up your unplowed ground; > for it is time to seek the LORD, > until he comes > and showers righteousness on you. > Presumably, you want the hyperlink but dislike the style imposed. It can be changed. For a comprehensive discussion see http://www.oooforum.org/forum/viewtopic.phtml?t=44143 - there are two methods and use of the HYPERLINK function provides the greater range of choices. -- View this message in context: http://www.nabble.com/HyperLink-Background-Color-tf3711479.html#a10407953 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Open Office Spreadsheet Scrolling Problem
Michael Schatte wrote: > > Hi folks, > > I'm on both a MacBook and an iMac running Tiger, and on both systems > while > using the OpenOffice Spreadsheet program I encounter a frustrating > problem. > When I use either a scroll wheel on a mouse or the laptop trackpad > scrolling > function, open office starts the scrolling in a choppy way and then it > goes > on and on continuously with me being unable to stop it. I'm down to the > bottom of a long spreadsheet after only intending to scroll down a couple > of > page lengths. Anybody know of a fix for this? Any similar problems out > there? > > Thanks > Michael > > I sometimes experience a similar problem in Adobe Reader when using the keyboard direction arrows. I can only stop the scrolling by changing direction. The only remedies I know are to (1) be more patient (probably impossible) or (2) use the vertical scrollbar (with which I also have problems at times). Life can be hard. -- View this message in context: http://www.nabble.com/Open-Office-Spreadsheet-Scrolling-Problem-tf3718899.html#a10407749 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Follow-up to McAfee's Site Advisor Rating
Larry Kollar-2 wrote: > > On 5/8/07, Rocky Cooper <[EMAIL PROTECTED]> wrote: >> >> I just brought up my sent email to you, and McAfee displayed a warning >> that my first email contained "a link to a potentially unsafe website, >> open-oasis.org." >> >> Hmmm You might want to consider removing your ties to this URL. > > Since I don't want to be rude, I will say "McAfee is probably making a > mistake" here, and leave it at that. :-P > > -- Larry > > Perhaps the French tongue is considered dangereuse? It would be good for a laugh to know what happens when you try to get more information from McAfee. -- View this message in context: http://www.nabble.com/Follow-up-to-McAfee%27s-Site-Advisor-Rating-tf3711498.html#a10387544 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screen refresh in spreadsheet
I've inserted one comment. Cheers. Bill Gradwohl wrote: > > On Fri, 2007-05-04 at 20:17 -0700, TerryJ wrote: >> Regarding screen refreshing, there is a discussion here: >> http://www.oooforum.org/forum/viewtopic.phtml?t=49527 >> > This causes the whole app to disappear showing the desktop instead. I'm > after just suspending screen flicker - freezing the screen as is - > during a period of time. > > Causing the app to go away is a bit startling to an end user. > >> The ruse of creating a blank document to cover the document being >> processed: >> http://www.oooforum.org/forum/viewtopic.phtml?t=36652 > OK, but still not "the solution". > > Isn't there a way to tell the controller to just stop updating the > screen? > > I don't know. I'm mildly interested because I have such a macro. My (lazy) answer is to change to another workspace to avoid the screen updating. You could minimise the window: http://api.openoffice.org/docs/common/ref/com/sun/star/frame/WindowArrange.html or select a part of the document which does not alter. > >> > > -- > Bill Gradwohl > > -- View this message in context: http://www.nabble.com/Screen-refresh-in-spreadsheet-tf3691773.html#a10369187 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc2
Stanley Hutchinson wrote: > > OOPS, Didn't look at it that way > > Thanks again for the help > > > shandih > > How are you sending replies? They are being published as separate threads. If you are using an email client, select the message to which you wish to reply, then use the "reply" icon or the "reply" menu command. -- View this message in context: http://www.nabble.com/Calc2-tf3699655.html#a10351294 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] When copying from Opera to calc now asked if OK???
GregChi wrote: > > On Thu, 03 May 2007 14:21:49 -0400, GregChi wrote: > >>OOo ver 2.2.0 >>When copying from Opera & pasting to Calc a 'Text Import' window pops >>up (character set unicode) & I need to click OK. >> >>WHY? (Didn't happen in OOo 2.1) >>How do I set this to ALWAYS accept the copied info > > Has OOo changed how it imports from a web page? > Why is it asking for an OK? > -- > Greg Agent 1.93/32.576 Opera9.20 OOo2.2Eudora(NG7)6.2.5.6 > news.readfreenews.net & news.gmane.org Win98se > for sale: Apple//,Auto Parts/Equip/Manuals: > geardocATgeardoc36DOThostingisfreeDOTcom > > Hi. I have not come across this but have seen it mentioned. I believe it has to do with the format of the data you try to paste. When I paste data from an internet site to Calc, I use the drop-down menu attached to the Paste icon and selected "unformatted text". You can achieve the same thing with Paste-Special, I gather, by de-selecting "formats". -- View this message in context: http://www.nabble.com/When-copying-from-Opera-to-calc-now-asked-if-OKtf3688147.html#a10351065 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc
Stan, it isn't helpful to post a reply as a new thread. The easiest way, probably, to copy the formula is to select the entire range in which you wish to have the formulas (including the cell containing the formula) and use Edit >Fill >Down. Stan Hutchinson wrote: > > "Thanks, that is what I require ( I think ) but does copy to all rows mean > typing the formula in every row to row 368 to obtain an annual total > What I have read does not seem to operate at this level" > > Pradeep Srinivas wrote: > > On Sunday 06 May 2007, Stan Hutchinson wrote (regarding [users] Calc): >> How can I get the row number to make a formula for Credit in column A, >> Debit in column B and Total in column C simplistically >> >> C this row = C previous row plus A this row minus B this row >> >> so that it does not have to be entered at every row >> >> shandih > > > Hi, > > Unless I misunderstand you, the requirement can be met fairly > simplistically > by this formula: > > Assuming C1 is the heading row, and C2 is the first row where you have the > details, then C3 becomes the first row where you can automate the > process... > Therefore, > in C3 put in "=C2 + A3 - B3" > and copy that to all the rows below C3. > > If this is not what you want, please explain the situation once again to > the > list. > > Please respond to the list - NOT to me. > > -- > Pradeep Srinivas > Bangalore, India > > -- View this message in context: http://www.nabble.com/Calc-tf3699517.html#a10345450 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Screen refresh in spreadsheet
Bill Gradwohl wrote: > > Is there any way to stop all screen activity while a macro is executing? > > I've written some basic macros and during their operation, cells get > reset to 0, columns get deleted, things get moved around, etc. Each of > those actions causes the screen to refresh which wastes a lot of time > and is annoying to watch. > > While on the subject, I read that the spreadsheet is actually written in > C, and not JAVA as I assumed, so why is the application so slow? > > > -- > Bill Gradwohl > > Regarding screen refreshing, there is a discussion here: http://www.oooforum.org/forum/viewtopic.phtml?t=49527 The ruse of creating a blank document to cover the document being processed: http://www.oooforum.org/forum/viewtopic.phtml?t=36652 Two things which I understand detract from performance in terms of speed are hard formatting and use of range names. The former can be minimised by using styles (F11) - see the Calc guide chapter (~ 10) on styles on http://documentation.openoffice.org/manuals/oooauthors2/index.html -- View this message in context: http://www.nabble.com/Screen-refresh-in-spreadsheet-tf3691773.html#a10333272 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Q in OO calc 2.1
Indra Gunawan-3 wrote: > > I have 3 files such as file1, file2 'n file3. how to added the value of > file1 + file2 and the result in file3. Usually i use Link in excel and > everytime the value in one of file was changed. the result automatic > changed. > > how to implement in OO. anyone help me ? > > > thanks a lot > > See Help under references;to cells in another document. A better method might be to use the DDE function, which you get when you copy a cell in one document and paste-special as "link" in another. The first link inserts a hidden copy of the referenced sheet in the file containing the reference. The second, evidently, loads the referenced file invisibly. External links in Calc are not well developed. -- View this message in context: http://www.nabble.com/Q-in-OO-calc-2.1-tf3691747.html#a10333212 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] scalc - Extracting certain rows - is it possible
Hi. Only one comment, interlineated. Mark Knecht wrote: > > Hi Terry - Thanks for the response. > > On 5/3/07, TerryJ <[EMAIL PROTECTED]> wrote: >> >> >> >> Mark Knecht wrote: >> > > >> > >> > > >> What is the criterion for deciding the page to which a particular row >> is copied? > > Old stock date sold == New stock date purchased > > Sorry, I don't know the significance of ==. You would not necessarily make the new purchase on the same day as the sale, would you? I would think that the next purchase, not already extracted, following a sale would go on the same sheet. You could do that with scripting; I don't know about other tools. There may be more than one sale followed by a purchase, another sale and other purchases. >> Is there a column which contains that criterion? > > Not specifically. Maybe I can somehow create one? > >> What is the reason for separating transactions that way? > > To investigate the statistics of smaller groups to see how they > compare to the group as a whole. > > I'm looking at back testing stock trading strategies. Assume I buy a > basket of 3 stocks on Monday. This creates 3 stock world lines which > I'll show like this > > (A) > (B) > (C) > > Some go up, some stay flat, others go down. Somewhere along the line I > sell one stock on Thursday and using that money I buy a new stock. The > world lines now look like this: > > (A) > (B) - (D) > (C) > > The following week two stocks sell and are replaced: > > (A) > (B) - (D) - (E) > (C) - (F) > > Over time it could look like this: > > (A) - (K) -(L) > (B) - (D) - (E) - (G) -(H) - (M) > (C) - (F) - (I) - (N) > > Most of the time stocks sell because they get week or don't perform > well for some other reason. Sometimes all stocks sell due to a market > changing event. You don't know which will sell and you don't know > when. Only that when one sells it is immediately replaced by another. > >> >> Presumably you cannot simply extract the first row to the first sheet, >> the >> second to the second and so on because sales and purchases do not occur >> in >> that sequence - i.e. 8 purchases followed by 8 sales, or vice versa. > > The first 8 purchases are the first lines in each of the 8 sheets but > after that it happens in what ever order certain stocks sell in. > > In terms of creating the new lines it doesn't matter which stock goes > into which world line - only that it is added to one line and not > duplicated somewhere. > >> > Thanks for your interest! > > Cheers, > Mark > > -- View this message in context: http://www.nabble.com/scalc---Extracting-certain-rows---is-it-possible-tf3688428.html#a10333108 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Donation
Carol Rogala wrote: > > Hi: > > Your web page will not let me use my credit card because I used to have a > Pay Pal account. I am using a valid Visa credit card and it won't go > thru. So if you want the donation, please fix this. I think it has to do > with you having the credit card info on a Paypal page. > > Sincerely, > > Carol Rogala > What happens when you try to make a donation and at what point in the process? -- View this message in context: http://www.nabble.com/Donation-tf3689730.html#a10316649 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] help please
Jerry I Mills wrote: > > Hi, I have just installed vers 2.2 but cannot get it to start. The > installation went fine and I see Openoffice and the sub programs in my > Programs list. But when I click on it or a sub program like calc nothing > happens. Nothing opens. I installed it twice. > > thanks > > Jerry > > Which operating system? Did you check the md5sum of your download? http://download.openoffice.org/2.2.0/md5sums.html -- View this message in context: http://www.nabble.com/help-please-tf3688921.html#a10316632 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] scalc - Extracting certain rows - is it possible
Mark Knecht wrote: > > Hi, >I'm not sure if this sort of thing is even possible in a > spreadsheet but hopefully this is the place to ask. Thanks in advance > for your indulgence. > >I have a spreadsheet with roughly 5000 stock trades. The basic idea > of the data set is that there are always 8 stocks owned in the > portfolio. On the initial date 8 stocks are purchased. Sometime later > anywhere from 1 to 8 stocks are sold and an identical number of new > stocks are purchased on the same date to replace them thus keeping 8 > stocks in the portfolio at all times. > >What I would like to do is somehow create 8 new pages within this > spreadsheet with each page having a unique set of trades in it. > Ideally one the first 8 purchases would individually show up at the > top of the new 8 pages. When a stock on any page is sold I would then > have a new, unique stock added to each page. When complete the sum of > the stocks on all 8 pages would equal the number of trades on the > first page. > >It is not important which stock replaces a stock on any page. The > only important thing is that every trade in the main page be > represented on one of the 8 new pages, that no stock ownership dates > overlap on a single page and that no single trade show up on more than > one page. > >Is something like this even possible in Open Office Calc? > >I suppose if I was a programmer then it could be done in C but I'm not. > >Any chance of doing something like this? > > Thanks in advance > > I've never used either tool, but Data >Filter and Data >DataPilot spring to mind. What is the criterion for deciding the page to which a particular row is copied? Is there a column which contains that criterion? What is the reason for separating transactions that way? Presumably you cannot simply extract the first row to the first sheet, the second to the second and so on because sales and purchases do not occur in that sequence - i.e. 8 purchases followed by 8 sales, or vice versa. It sounds like a headache requiring counting of sales, purchases and sheets but I imagine scripting could achieve what you want. -- View this message in context: http://www.nabble.com/scalc---Extracting-certain-rows---is-it-possible-tf3688428.html#a10316605 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Reference a cell to a document that's OOo password protected does not work
Kirill S. Palagin wrote: > > Hello. > I have two password-protected spreadsheets. One spreadsheet references > cells in the other spreadsheet and if source is closed then Calc would > not ask for a password. > Is there any workaround (while we wait for issue 24535 to be fixed)? > > Thanks. > WBR, > K. Palagin. > > Hello. I don't use password protection. I take it that the problem is that a reference to a cell in a protected document does NOT return the data in the referenced cell. Standard references rely on a hidden copy of the sheet in the document which contains the reference, so I do not see how OOo would manage the process if such a reference were possible. It would mean, in effect, that part of a protected document became embedded in a document which is unprotected. Have you tried a DDE entry instead of the standard reference? -- View this message in context: http://www.nabble.com/Reference-a-cell-to-a-document-that%27s-OOo-password-protected-does-not-work-tf3679732.html#a10298579 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Good place to store Macros for Everyones use...
This is another example of OOo's shortcomings for an organisation or any network. There is no commonly known way of adding shared macros. There is, evidently, an almost secret way of making add-ons available to all users. You can hack individual users' settings folders by adding basic libraries. The path on my (Linux) OS to my macro files is ~/.openoffice.org2/user/basic . Within that folder are folders for my (user) macro libraries. They can be copied, evidently, to other users. I have not found a way of adding them to openoffice.org2.0/share/basic/ - I think that must be hard-coded. It is also possible to edit some of the shared macro libraries (Gimmicks, from memory, is one). I've never tried it so I do not know whether editing is effective. I've also never tried running OOo as root / administrator - that may enable you to add shared macros. ??? WP Hewitt wrote: > > Thank you very much. The one set of instructions I had found was not > working for me, but the topic, > http://www.oooforum.org/forum/viewtopic.phtml?p=179672#179672 does - > kinda > So, at least I am headed in the right direction. I really want to > install without using a GUI... a scriptable process... > > I wish there was an explanation of what the above process is actually > doing (I am an "under the hood kinda guy") but maybe now I can figure it > out and write it down... > > So, thanks again for all the help... > > WPH > > TerryJ wrote: >> >> WP Hewitt wrote: >> >>> I have been looking around and I cannot find out where to put Macros so >>> they are accessible and everyone using Open Office can use them >>> Lots on how to write one, but where does one prefer to install them? >>> >>> WPH >>> >>> >>> >> >> Look in the following thread for links relating to distribution of >> macros: >> http://www.oooforum.org/forum/viewtopic.phtml?t=50952 >> > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Good-place-to-store-Macros-for-Everyones-use...-tf3675329.html#a10298554 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc changes in v2.2 OOo for Windows
Glenn Skitch wrote: > > Hi all > > I am using version 2.2 of OpenOffice in Windows XP sp2+updates. > Unfortunately I cannot find an adequate avenue for submitting what may > be a bug, and I haven't been able to find it in a FAQ. > > > > Anyway, here is the issue. I just upgraded from v2.1 to 2.2, and use > Calc everyday to generate an excel File that has no formulas or macros. > It pretty much is a time-log in a convenient spreadsheet format. It > does however extensively use Cell notes, where I can detail my day, item > by item. > > Anyway, I have been using OOo in 1.1 where the Excel translation of > notes was not great, since it appended a square box to the end of each > line in the note, and the note size changed every time I saved and > loaded it in OOo. Version 2.0 was much better with notes and Excel > files, as was 2.1. > > Now in the new 2.2, the notes will display fine when you mouse-over > them, or set the "show note" option. However, when you click into the > note and try to enter something new, the note will clear the note (info > still in it, just not viewable). To make it display, you must Backspace > up to the previous line (deleting a character in the previous line > unnecessary), then hit ENTER to continue adding to the Note. Atached > are a series of small JPGs showing the error. > > > > One other thing I tried was to save the file as an OpenOffice ODS file. > The Note error is still displayed, exactly as displayed in the Excel > translation. > > > > Hopefully this is a new bug and I just failed to find a bug-report. > BTW, you guys are doing a fantastic job on the project and I look > forward to each new edition to see what has been changed or enhanced. > > > > Have a great day! > > Glenn Skitch > > Hi. Your jpgs were stripped from your message, as attachments sometimes are. A guide for filing a bug report is here: http://www.oooforum.org/forum/viewtopic.phtml?t=47619 . You begin by registering here: http://www.openoffice.org/servlets/Join -- View this message in context: http://www.nabble.com/Calc-changes-in-v2.2-OOo-for-Windows-tf3675344.html#a10279036 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Data validation in Calc with dates does not function properly
Paul Dom wrote: > > I am using OpenOffice 2.2 Dutch version. > I have a problem of validating a date cell in Calc. > > I try to ensure that the value I enter is before 01/01/2007. (Or after a > certain date.) > I use the menu Data, Validation and enter Date as content and maximum > value = 01/01/2007. > I still can enter any value without seeing the message box I entered for > unappropriate values. > > Is this a bug in Calc? Or do I have to specify the maximum value in a > certain format? > Can anyone help me? > > Thanks! > > Paul Dom > > I must admit I've decided to get by without Data >Validity. After experimenting with a date, I find that you have to insert the numerical value of the date which is your maximum or minimum. eg. 31/12/2007 = 39447. -- View this message in context: http://www.nabble.com/Data-validation-in-Calc-with-dates-does-not-function-properly-tf3677834.html#a10278979 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Good place to store Macros for Everyones use...
WP Hewitt wrote: > > I have been looking around and I cannot find out where to put Macros so > they are accessible and everyone using Open Office can use them > Lots on how to write one, but where does one prefer to install them? > > WPH > > Look in the following thread for links relating to distribution of macros: http://www.oooforum.org/forum/viewtopic.phtml?t=50952 -- View this message in context: http://www.nabble.com/Good-place-to-store-Macros-for-Everyones-use...-tf3675329.html#a10278915 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] quick question about formula entering
Tecmar wrote: > > Is there a way in CALC to set it so a formula can start with the plus > sign? > > It is so much easier as the plus sign is on the number pad. Office > has been doing this forever, am I missing something? > > Thanks in advance. > > Jake > > Script has been published on the forum to enable you to start a formula in the Lotus (originally) fashion: http://www.oooforum.org/forum/viewtopic.phtml?t=31846 -- View this message in context: http://www.nabble.com/quick-question-about-formula-entering-tf3646880.html#a10252806 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cannot compile 2.2.0
Russbucket wrote: > > On Thursday April 26 2007 17:45, TerryJ wrote: >> Russbucket wrote: >> > Just downloaded 2.2.0 from the OpenOffice.org website several times. >> > when I >> > execute the following command: >> > tar -xvzf OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz >> > I get the following errors: >> > >> > tar: OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz: Cannot open: No >> such >> > file >> > or directory >> > tar: Error is not recoverable: exiting now >> > tar: Child returned status 2 >> > tar: Error exit delayed from previous errors >> > or if I do an ls-l I get: >> > >> > tar: OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz: Cannot open: No >> such >> > file or directory >> > >> > >> > -- >> > Russ >> > Linux register user 441463 >> >> >> >> Another possibility is that there is a typo in your command. I always >> copy >> the file name from the file browser rather than type it for that reason. >> There are no obvious errors. > Just downloaded the file again, this time without the JRE option. I was > able > to use the tar command and unpack it. Should be OK from Here. > > [EMAIL PROTECTED]:~/TEMP/OpenOffice> ls -l > total 128420 > drwxr-xr-x 2 finemanruss users 4096 2005-12-31 13:49 Documents > drwxr-xr-x 2 finemanruss users 4096 2006-07-17 09:18 expand > drwxr-xr-x 2 finemanruss users 4096 2007-04-26 16:24 old > -rw-r--r-- 1 finemanruss users 131348495 2007-04-26 22:31 > OOo_2.2.0_LinuxIntel_install_en-US.tar.gz > > problem appears to be with JRE version. > > Again thanks for everyones response. > > > -- > Russ > Linux register user 441463 > > I'm glad I'm not the only one who missed it: wRJE should be wJRE. (Now you don't see it, now you do.) There was a typo after all. I think you are better off getting Java direct from the Java website in any case. -- View this message in context: http://www.nabble.com/Cannot-compile-2.2.0-tf3654795.html#a10216531 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] skip over protected cell in spreadsheet
Bill Gradwohl wrote: > > On Wed, 2007-04-25 at 05:50 -0700, TerryJ wrote: >> The tab key should do that. If not, assign a keybinding using Tools >> >Customise : Keyboard : Navigate : To next unprotected cell. > Didn't know that was there. Thanks. > > But --- this doesn't help me "navigate" to an unprotected cell using the > arrow keys. I see no way to program that. > > -- > Bill Gradwohl > > I believe you would have to write some code for the software or a complicated script for that. In the meantime, all you can do is file a request for a feature enhancement (RFE) - the same as a "bug report", on which, for guidance, see http://www.oooforum.org/forum/viewtopic.phtml?t=47619 -- View this message in context: http://www.nabble.com/skip-over-protected-cell-in-spreadsheet-tf3645102.html#a10211674 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Cannot compile 2.2.0
Russbucket wrote: > > Just downloaded 2.2.0 from the OpenOffice.org website several times. when > I > execute the following command: > tar -xvzf OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz > I get the following errors: > > tar: OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz: Cannot open: No such > file > or directory > tar: Error is not recoverable: exiting now > tar: Child returned status 2 > tar: Error exit delayed from previous errors > or if I do an ls-l I get: > > tar: OOo_2.2.0_LinuxIntel_install_wRJE_en-US.tar.gz: Cannot open: No such > file > or directory > The authorities are : 644, I'm owner and users is the group. This is the > same > authorities as other tar files I am able to open. > > Any idea why I cannot open and compile this? I was about to do 2.1 and > others. > I'm on SUSE 10.2. > > Any help or ideas will be appreciated. > > Thanks > > -- > Russ > Linux register user 441463 > > The most likely cause is that you are not in the directory which contains the tar file. If, for example, you downloaded it to your desktop, you need first to run: cd /home/russ/Desktop There is an instructions.html linked to the download page and these: http://documentation.openoffice.org/setup_guide2/2.x/en/SETUP_GUIDE.pdf http://documentation.openoffice.org/setup_guide2/2.x/en/SETUP_GUIDE_A4.pdf Another possibility is that there is a typo in your command. I always copy the file name from the file browser rather than type it for that reason. There are no obvious errors. -- View this message in context: http://www.nabble.com/Cannot-compile-2.2.0-tf3654795.html#a10211622 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to Purchase Your CD
George Yankura wrote: > > Dear Administrator: > Yesterday's, 4/24, issue of The New Mexican carried an article by > Joseph Jones, The Tech Dude, highly extrolling your program. He advises > using your "torrent" to download the program, however I am unable to find > that pathway on your website (my Comcast server comes up with many > OpenOffice websites and maybe I haven't tried the correct one). > Mr. Jones also says that your program is available on CD. A CD > would be preferable to me. > Please advise how I may acquire the CD of your program. > Thank you. > AFAIK, this is still the link for bittorrent downloads: http://distribution.openoffice.org/p2p/ . Alternatively, http://borft.student.utwente.nl/%7Eadrian/bt.php There is a list of cd distributors: http://distribution.openoffice.org/cdrom/ . I understand that the list is not monitored or well maintained, so don't be beguiled by the fact that some supplier is on the list. One supplier I believe to be reliable is http://on-disk.com/index.php?manufacturers_id=12&osCsid=4373f7fcbe0e37fdab32bbd25d3ef005 -- View this message in context: http://www.nabble.com/How-to-Purchase-Your-CD-tf3654691.html#a10211575 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Database
Dave Barton-4 wrote: > > Original Message > From: Mohd Afifuddin Bin Omar <[EMAIL PROTECTED]> > Date: Thu 26 Apr 2007 12:39:29 EST > >> Hi there, >> >> Is there anybody who can assist me on OpenOffice to open MDB file? >> >> Thanks. >> >> Regards >> Afifuddin > > This link may help. > http://wiki.services.openoffice.org/wiki/MSA-Base_Faq > > Dave > > As, I hope, will this: http://mdbtools.sourceforge.net/ -- View this message in context: http://www.nabble.com/Database-tf3649240.html#a10194526 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I need some help!
Butch-3 wrote: > > I used to be fairly fluent in "Computereese" but I've had a stroke. Now > I try to install Open Office 2.2 and I get an icon that doesn't do > anything and I can't seem to change the properties for it to open > "Quickstart". I believe thats what I need to start the program. I would > appreciate any help. I've tried to install/uninstall about 6 times so > far and am at my wits end. Thanks,Butch > > Do you have any menu commands? As far as I know, you can launch OOo in Windows without using the Quick Starter. Downloading and installation instructions are here: http://download.openoffice.org/common/instructions.html One of these may help: http://documentation.openoffice.org/setup_guide2/2.x/en/SETUP_GUIDE.pdf http://documentation.openoffice.org/setup_guide2/2.x/en/SETUP_GUIDE_A4.pdf You could check the integrity of your download with the md5sum procedure: http://download.openoffice.org/2.2.0/md5sums.html -- View this message in context: http://www.nabble.com/I-need-some-help%21-tf3642166.html#a10180088 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] skip over protected cell in spreadsheet
Bill Gradwohl wrote: > > Is there any way to have the application not even land on protected > cells? > > i.e. When arrowing around in any given direction, skip over cells that > can't be modified due to protection and land on the next cell in the > direction that can be modified (not protected) > > if B5 is protected: > from A5 arrow right one time and land on C5 > from B4 arrow down one time and land on B6 > etc > > -- > Bill Gradwohl > > The tab key should do that. If not, assign a keybinding using Tools >Customise : Keyboard : Navigate : To next unprotected cell. -- View this message in context: http://www.nabble.com/skip-over-protected-cell-in-spreadsheet-tf3645102.html#a10180006 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc
d.hedge wrote: > > > Open Office 2.2 > > Could you please let me know why when I put a date in column A any cell it > changes it to a number > > I can fiddle about and get a date eventually but it is time consuming. > > > Also. > > > Is there a reason why when I go to save the pages to disk it will save > pages > 1 to 9 > > But not page 10 > > Kind regards > > Dorothy Hedge > > P.s. > > Apart from the odd glitch I am finding it much easier to use than excel. > Hi. Column A is probably formatted with some format other than "General" (the default "number" format). Select column A (use the header) and Format >Default formatting to change back to the default format. I do not know why there should be any discrepancy regarding the number of sheets being saved. Are there in fact 10 visible sheets? -- View this message in context: http://www.nabble.com/Calc-tf3623502.html#a10123994 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OpenOffice org.Calc 2.2
This list is English. Look here: http://de.openoffice.org/ Gruß Terry Dieter Pohle wrote: > > > Hallo, > > mein Problem "Unterstreichen einer Zelle" ist ja nun gelöst. Nun habe ich > aber mit der Formel "Zählenwenn" ein Problem. In Excel kann man z.B. in > einer Zelle zwei oder mehrere Namen erwähnen und dann mit Hilfe der Formel > Zählenwenn die Anzahl eines bestimmten Namens herausfiltern. Dazu muß man > dann aber den Namen in Anführungszeichen und Sternchen setzen, so wie das > aus dem beigefügten Beispiel ersichtlich ist. > > In OpenOffice org. Calc 2.2 scheint das so nicht möglich zu sein. Ist das > richtig oder geht es hier anders? > > Gruß Dieter > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- View this message in context: http://www.nabble.com/OpenOffice-org.Calc-2.2-tf3603270.html#a10070726 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Missing Text
BC Cheah wrote: > > I am using version 2.02 of Open Office.org. My problem is I have missing > text usually towards the end of my sentence after saving. It occurs when I > am using Open Office Calc. I have tried to uninstall and install the Open > Office software but it doesn't seems to help much. > > Please Help. > > Thank You. > > With Regards > Beng Choo Cheah > I am also using 2.0.2, mainly Calc. If you have an entry which exceeds the length of the cell, it may be prevented from displaying if there is data in a subsequent cell in the same row. The horizontal alignment "Filled" will also prevent it from displaying. You can still see the full contents of the cell in the input line in the formula bar. There may be some limit on the amount of data you can enter in one cell - I forget. The question has been discussed on the forum. -- View this message in context: http://www.nabble.com/Missing-Text-tf3583745.html#a10014385 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc 2.04 cell colouring dependant on formula result
Klaas Visser wrote: > > On 15-Apr-07 16:50 (+1000 UTC), *Hylton Conacher (ZR1HPC)* posted: > >> I have a formula in a cell >> (=SUM(Apr.D3:Apr.D30)/(COUNT(Apr.D3:Apr.D32)*30)*1000) and would like >> the cell background of that same cell change colour as the formula >> result changes. >> >> If the formula result is 0-758, the cell can be Light Green. If the >> value of the formaula is 751-900 the cell colour would be orange. If the >> formula result was over 1000 then the cell must be coloured Light Red. >> >> I was thinking of exploring the IF function but am not sure: >> >> 1. If this can be done >> 2. What the correct formula to use would be. >> >> Any thoughts/suggestions? >> > > I'd be using Conditional Formatting for this. > > Create three cell styles, one for each of the result states / fill > colours. > > Go to Format | Conditional Formatting, and specify the appropriate cell > values, and the style to use in each case. > > Klaas Visser > > If you need to use more than 4 styles (including the style set by default for the range), you can use the STYLE function with IF. -- View this message in context: http://www.nabble.com/Calc-2.04-cell-colouring-dependant-on-formula-result-tf3578678.html#a1178 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] My file cannot be opened. Please help me !
Aldy Wibowo wrote: > > > > I am using version 2.0.2 of OpenOffice.org. My problem is : > > My confidential file cannot be opened. > > The reason is " corrupt file " > > Can you fix the file ? > > thanks. > > Files which are "password protected" often seem to become corrupted. I believe there is something wrong with password protection in OOo. Below are some links and other notes I have on salvaging data from a corrupted file. Your problem probably cannot be solved because the broken password setting will prevent you from unzipping the file. There is a password cracker on www.ooomacros.org if you want to try. If you can unzip it, these are relevant notes: - - - - - start of quote hol.sten's links: http://www.oooforum.org/forum/viewtopic.phtml?t=24208 http://www.oooforum.org/forum/viewtopic.phtml?t=23146 http://www.oooforum.org/forum/viewtopic.phtml?t=20840 macro to repair (windoze): http://www.oooforum.org/forum/viewtopic.phtml?t=45473 other links: http://www.oooforum.org/forum/viewtopic.phtml?t=33263 http://www.oooforum.org/forum/viewtopic.phtml?t=33210 http://www.oooforum.org/forum/viewtopic.phtml?t=24208 http://www.oooforum.org/forum/viewtopic.phtml?t=30992 http://www.oooforum.org/forum/viewtopic.phtml?t=31277 script to recover: http://www.oooforum.org/forum/viewtopic.phtml?t=34891 One user: Thanks for the effort! Here's how I did it: 1. renamed the defective file extension to .zip 2. extracted content of the .zip file 3. opened content.xml with Dreamweaver, selected in the view menu to show errored lines (shows the bad text with yellow background) and removed them. 4. did the same with style.xml 5. updated the .zip file and renamed it back to .ods Some styling was removed but the file worked and all the data was in it! Cheers! - - - - - end of quote -- View this message in context: http://www.nabble.com/My-file-cannot-be-opened.-Please-help-me-%21-tf3575765.html#a9992948 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Macro question in Calc
So that first script is no good? By "macro" did you just mean a formula? Or do you want the script to enter a number in the first cell, then in each of the 9 cells below it? What's a "Christian RPG"? Jack Ray wrote: > > Terry > I wasn't real clear, I think > I have a spreadsheet that calculates starting values for characters in > a Christian RPG. There are 10 cells that need a random 2-7 value > placed one time, on command, then that value maintained in those cells > until the next time the command keyy is pressed. They cannot > recalculate on F9 or opening or anything else that ReCalc seems to do. > Each cell is independent of the others, so each value is random. I > was actually trying to find something along the old GETKEY function to > use in an IF statement, but can't get anything to work. > Jack > > On 4/13/07, TerryJ <[EMAIL PROTECTED]> wrote: >> >> >> >> Jack Ray wrote: >> > >> > I can't figure this out. I need a Macro that will fill a cell with a >> > random integral number, between 2 and 7, when a key is hit, not, as >> > random works normally, whenever the spreadsheet refreshes. >> > Can anyone show me how? >> > Jack >> > >> > >> >> I'm guessing this does what you want. It just inserts the formula, then >> converts it to a value. >> >> ' * * * * * script follows >> Sub randValue27 >> 'Inserts a random value between 2 and 7 in the selected cell of a >> spreadsheet using setFormula >> 'rather than FunctionAccess. Set to work ONLY if a single cell is >> selected. >> Dim oCell as Object, sFormula as String >> >> oCell = ThisComponent.CurrentSelection >> If NOT oCell.supportsService( "com.sun.star.sheet.SheetCell" ) Then : >> Exit >> Sub : End If >> sFormula = "=RANDBETWEEN(2;7)" : oCell.setFormula( sFormula) >> oCell.setDataArray( oCell.getDataArray ) >> End Sub >> ' * * * * * script has ended >> >> You could, perhaps more usefully, use script which performs a hard >> recalculation. >> >> ' * * * * * script follows >> Sub hardRecalc >> ' Performs a hard recalculation of the spreadsheet - does NOT count as a >> modification >> Dim oDoc as Object : oDoc = ThisComponent >> If NOT oDoc.SupportsService ( "com.sun.star.sheet.SpreadsheetDocument" ) >> Then >> Exit Sub : End If >> oDoc.calculateAll() >> End Sub >> ' * * * * * script has ended >> >> Beware the effects of copying and pasting from an email to the Calc Basic >> editor. Your email client may convert single lines to multiple lines. I >> can upload a text file if you have problems. >> -- >> View this message in context: >> http://www.nabble.com/Macro-question-in-Calc-tf3574343.html#a9989422 >> Sent from the openoffice - users mailing list archive at Nabble.com. >> >> - >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > > -- > Look at the world around you, and you'll see God's creativity; > Look at the dinner table, and you'll see God's providence; > Look at the mirror, and you'll see God's sense of humor. > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Macro-question-in-Calc-tf3574343.html#a9992875 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] moving open office from p2p client to my computer
CAROL ROBINSON wrote: > > Please help, I have downloaded Open Office (the latest version) using > uTorrent p2p, but I don't know how to get it from uTorrent to my computer > so I can use it. I realize this is not an Open Office question, but I bet > you have lots of users that can help me. thanks for your time. > > Carol > I use Bittorrent and do not know uTorrent. Bittorrent allows me to set the folder to which downloads are saved. I don't understand how uTorrent can be saving to any destination other than a folder on your computer. You may have downloaded the torrent file only. If so, you need to open that file with uTorrent. Then OOo will be downloaded and saved by uTorrent to a specified folder on your computer. Downloading OOo will take considerably longer than downloading the torrent file. -- View this message in context: http://www.nabble.com/moving-open-office-from-p2p-client-to-my-computer-tf3574207.html#a9989467 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Macro question in Calc
Jack Ray wrote: > > I can't figure this out. I need a Macro that will fill a cell with a > random integral number, between 2 and 7, when a key is hit, not, as > random works normally, whenever the spreadsheet refreshes. > Can anyone show me how? > Jack > > I'm guessing this does what you want. It just inserts the formula, then converts it to a value. ' * * * * * script follows Sub randValue27 'Inserts a random value between 2 and 7 in the selected cell of a spreadsheet using setFormula 'rather than FunctionAccess. Set to work ONLY if a single cell is selected. Dim oCell as Object, sFormula as String oCell = ThisComponent.CurrentSelection If NOT oCell.supportsService( "com.sun.star.sheet.SheetCell" ) Then : Exit Sub : End If sFormula = "=RANDBETWEEN(2;7)" : oCell.setFormula( sFormula) oCell.setDataArray( oCell.getDataArray ) End Sub ' * * * * * script has ended You could, perhaps more usefully, use script which performs a hard recalculation. ' * * * * * script follows Sub hardRecalc ' Performs a hard recalculation of the spreadsheet - does NOT count as a modification Dim oDoc as Object : oDoc = ThisComponent If NOT oDoc.SupportsService ( "com.sun.star.sheet.SpreadsheetDocument" ) Then Exit Sub : End If oDoc.calculateAll() End Sub ' * * * * * script has ended Beware the effects of copying and pasting from an email to the Calc Basic editor. Your email client may convert single lines to multiple lines. I can upload a text file if you have problems. -- View this message in context: http://www.nabble.com/Macro-question-in-Calc-tf3574343.html#a9989422 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Using calc in time studies
Brian Barker wrote:
>
> At 08:47 13/04/2007 +0300, Andis Lazdinsh wrote:
>>I'm planning to use openoffice.calc in time studies of forest
>>harvesting, forwarding and other operations. I'm working on the
>>model, where I can insert number of operation (1, 2, 3, ...20) in
>>one column, starting time in second column and finishing time in
>>third column. As some operations occur at the same time, I need
>>separate column, where I mark, that operation is finished, so I have
>>four columns for data entering and fifth column for comments.
>>My problem is how to insert fixed time (HH:MM:SS) in time columns as
>>soon as I enter number of operation and mark that operation is
>>finished. Please, give me advice, how to do it using macros or
>>combination of build in functions and macros. The main point is to
>>have fixed time.
>
> Your finishing times are in the third column and your finishing marks
> in the fourth, so let's suppose these are columns C and D
> respectively. So you want to be able to insert the mark in column D
> and see the time when you did this appear magically in the
> corresponding cell in column C. Do I understand correctly?
>
> The formula you need for C1 would be:
> =IF(ISBLANK(D1);"";NOW())
> This tests D1 to see if it is blank (that is, empty). If it is, C1
> remains empty; if it is not, then the current time ("NOW") is
> inserted in C1. So when you enter something into D1, the time
> magically appears in C1.
>
> Note:
>
> 1. The default time format includes the date as well as the time, so
> you will have to format column C as HH:MM:SS to achieve what you want.
>
> 2. Although you will get the correct time in C when you enter
> something in D, all these times will be recalculated when you make
> other changes. So after you have entered the value in D, you must
> freeze the time in C before you do anything else. To do this, copy
> the contents of just the relevant cell in column C, and then paste it
> straight back in, but using "Paste Special" instead of
> "Paste". ("Copy" and "Paste Special" are both available from
> right-click in the context menu.) In the Paste Special dialogue box,
> first remove the tick from "Paste all" if necessary. Then make sure
> that "Numbers" is ticked and "Formulae" is *not* ticked. Now you
> have the finishing time as a constant rather than as a formula, and
> it won't change when you make other alterations or additions.
>
> Unless anyone knows a neater method ...
>
> Brian Barker
>
>
One other way would be to use script which enters NOW() as a string value.
Such script has been published on the forum ( www.oooforum.org ***) and
there is also a DATE/TIME tool on www.ooomacros.org . *** Search in the
Calc forum. If not found there, try Macros & API or Code Snippets.
--
View this message in context:
http://www.nabble.com/Using-calc-in-time-studies-tf3569871.html#a9979092
Sent from the openoffice - users mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc functions
Johnny Andersson-3 wrote: > > 2007/4/12, Frank Lohr <[EMAIL PROTECTED]>: >> >> am Donnerstag, 12. April 2007 schrieb Joe Conner: >> > NORMDIST >> > Returns the density function or the normal cumulative distribution. >> > >> >> This can be found in the Calc Help. I need to know how the >> NORMDIST()-Funcion >> is implemented. I want to know what is done internal with *Number*, >> *Mean*, >> *StDev* and *C* >> >> Frank >> >> > Since OpenOffice.org is OpenSource, I guess you could get the answer from > reading the souce code. I have never done that so I don't know how easy > that > is or even where to find it, but it should be possible. Maybe someone can > point you to exactly where to look? > > Johnny Andersson > > If you want to search the source code, this is the place to do it: http://go-oo.org/lxr/ . An alternative (IIRC) is: http://www.koders.com/ . You may be able to get an answer on one of the Calc lists: http://sc.openoffice.org/servlets/ProjectMailingListList -- View this message in context: http://www.nabble.com/Calc-functions-tf3563764.html#a9972752 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Support the project
You cannot generally send files through the list. You could upload it to the following location and post the link to the list : http://www.mytempdir.com/ . As Russell Butler mentions, most subscribers to this list are ordinary users. You could write to The Community Manager: [EMAIL PROTECTED] The pages to which I referred you earlier contain the authorisation you need. TQ.Hung wrote: > > Dear Dan Lewis! > > I want you support us following attached file. > (Empowerment letter is Letter of Authorization) > > Thanks > Hung > > - Original Message - > From: "Dan Lewis" <[EMAIL PROTECTED]> > To: > Cc: "TQ.Hung" <[EMAIL PROTECTED]> > Sent: Tuesday, April 10, 2007 8:09 AM > Subject: Re: [users] Support the project > > >> On Monday April 09 2007 6:05 pm, TerryJ wrote: >>> TQ.Hung wrote: >>> > Dear Sir/ Madam ! >>> > >>> > >>> > My name's Hung. I'm working as a project manager in Technological >>> > Application and Production Company -TECAPRO >>> > >>> > Which use Open Office software for education's purpose, therefore >>> > we need your support in this project interm of Empowerment Letter >>> > . >>> > >>> > I'm hope to receive your repply asap because on 16th April, 2007 >>> > I'm going to submit the tender document >>> > >>> > Support: >>> > Technological Application and Production Company Ministry of >>> > Defence-TECAPRO >>> > >>> > Add: No 18 A Cong hoa Ward 12 - Tan Binh District -HCMc - Viet >>> > Nam No 24 Nguyen Truong To- Ba Dinh - Ha Noi - Viet Nam >>> > >>> > Lot 2 - Network Equipents-PC: >>> > Development Support Project for Higher Education Traning in >>> > Informatics and >>> > Communication funded by Japan Government's ODA in 2006. >>> > >>> > Bidder: >>> > Project Management Board of "Development Support Project for >>> > Higher Education Training in Informatics and Communication " - >>> > Hanoi Technology University. >>> > >>> > Suit 805, 8th Floor, Ta Quang Buu Library Building, Hanoi >>> > Technology University >>> > Add: No.1 Dai CO Viet Str., Hanoi. >>> > Tel: 04 2153270 - 04 8681954 >>> > Fax : 04 8694539 - 04 8684946 >>> > >>> > Ta Quoc Hung >>> > -- >>> > Best Regards >>> > TECAPRO Co. >>> > 24 Nguyen Truong To, Hanoi, Vietnam >>> > Tel: (84) 4 7163914 >>> > Fax: (84) 4 7162452 >>> > Mobile: (84) 988714779 >>> > Email: [EMAIL PROTECTED] >>> >>> What do you mean by "empowerment letter"? One of the following >>> pages may provide what you require: >>> http://www.openoffice.org/license.html >>> http://www.openoffice.org/licenses/PDL.html >> >> Copy to Hung. > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- View this message in context: http://www.nabble.com/Support-the-project-tf3547737.html#a9951141 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I cannot import from StarWrite
José Trujillo Carmona wrote: > > I cannot import texts .sdw of StarWrite 5.0. I obtain: "general error of > input/output" > > My computer is a AMD 64 running with Debian 4.0 > > Can you help me? > > Thank's > > --- --- --- > José Trujillo Carmona > UNIVERSIDAD DE EXTREMADURA > Facultad de Ciencias > Departamento de Matemáticas > Avda. de Elvas s/n > 06071 BADAJOZ > > Tfno. +34 924 289 300 ext. 6823 > +34 662 903 726 6823 > fax: +34 924 272 911 > > e-correo: [EMAIL PROTECTED] > > Are you by any chance trying to access the file across a network? If so, there seems to be a special set of problems. Filters used by OOo are mentioned on this page: http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1 There is a section in the User Guide (~ chapter 13) called Troubleshooting which probably still mentions the issue: http://documentation.openoffice.org./manuals/OOo2.x/user_guide2_draft.pdf -- View this message in context: http://www.nabble.com/I-cannot-import-from-StarWrite-tf3561228.html#a9950853 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] HELP on Uninstalling open office
vishal gupta-3 wrote: > > Hi , i am using ooo 2.0.8990 on WinXP professional ( no service packs ) > when i try to uninstall it using add/remove programs it asks for the > original setup package which i have deleted, and then exits the uninstall. > What should i do please help. > > You may have a problem. OOo should warn against deletion of installers because it does not keep old builds on the mirrors. Yours looks like a development build: http://development.openoffice.org/releases/OpenOffice_org_2_x.html You may be able to use another programme to uninstall (there is freeware, IIRC), uninstall manually or (worst case) search the M$ knowledge base: http://www.google.com/microsoft . I use a Linux OS, btw, so I'm not up with the current situation on Windows and don't want to be. There is a M$ cleanup utility: http://support.microsoft.com/default.aspx?scid=kb;en-us;290301 http://www.oooforum.org/forum/viewtopic.phtml?t=29662 http://download.microsoft.com/download/e/9/d/e9d80355-7ab4-45b8-80e8-983a48d5e1bd/msicuu2.exe -- View this message in context: http://www.nabble.com/HELP-on-Uninstalling-open-office-tf3561216.html#a9950778 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc - Fill series - filling every second row with increment>1 ?
I was distracted in this by what seemed to be a bug. I could not get the original formula to work without <>0. It should have. After checking with others, who confirm that the <>0 is unnecessary, I find that the formula does, indeed, not require <>0. The elves which seem to bedevil my computer must have been making mischief again yesterday. I tested the issue several times, so it can't have been me. ¿¿¿? =IF(MOD(ROW()-ROW($A$1)+$A$1;2);ROW()-ROW($A$1)+$A$1;"") TerryJ wrote: > > My bad. Sorry. I shouldn't have assumed that A1 was the start: (third > time lucky) > =IF(MOD(ROW()-ROW($A$1)+$A$1;2)<>0;ROW()-ROW($A$1)+$A$1;"") > > > TerryJ wrote: >> >> I shouldn't have taken 1 as the inevitable beginning: >> =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+$A$1;"") >> >> >> TerryJ wrote: >>> >>> I am always intrigued by questions like this. Assuming your start cell >>> is A1, enter the following formula in A2 and drag it down: >>> =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+1;"") >>> >>> >>> Joe Conner wrote: >>>> >>>> Yes. In cell A1 enter 1. >>>> In cell A3 enter =A1+1 >>>> Click on cell A2. >>>> Holding down the shift key, >>>> press the down arrow 2 times. >>>> This will paint cells A2, A3. >>>> Copy (CTRL C). >>>> Click on cell A4. >>>> Hold down the shift key. >>>> Press CTRL and Down Arrow >>>> Paste (CTRL V). >>>> There you have it. >>>> >>>> Joe Conner, Poulsbo, WA USA >>>> >>>> >>>> >>>> Kirill S. Palagin wrote: >>>>> Hello. >>>>> >>>>> Is there a (non-macro) way to generate fill series skipping every >>>>> second >>>>> row with increment >1? >>>>> That is I want result to be like "1, blank, 3, blank, 5, blank, 7". >>>>> >>>>> Thanks a lot. >>>>> WBR, >>>>> K. Palagin. >>>>> >>>>> >>>> >>>> - >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>>> >>>> >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/Calc---Fill-series---filling-every-second-row-with-increment%3E1---tf3551502.html#a9931578 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc - Fill series - filling every second row with increment>1 ?
My bad. Sorry. I shouldn't have assumed that A1 was the start: (third time lucky) =IF(MOD(ROW()-ROW($A$1)+$A$1;2)<>0;ROW()-ROW($A$1)+$A$1;"") TerryJ wrote: > > I shouldn't have taken 1 as the inevitable beginning: > =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+$A$1;"") > > > TerryJ wrote: >> >> I am always intrigued by questions like this. Assuming your start cell >> is A1, enter the following formula in A2 and drag it down: >> =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+1;"") >> >> >> Joe Conner wrote: >>> >>> Yes. In cell A1 enter 1. >>> In cell A3 enter =A1+1 >>> Click on cell A2. >>> Holding down the shift key, >>> press the down arrow 2 times. >>> This will paint cells A2, A3. >>> Copy (CTRL C). >>> Click on cell A4. >>> Hold down the shift key. >>> Press CTRL and Down Arrow >>> Paste (CTRL V). >>> There you have it. >>> >>> Joe Conner, Poulsbo, WA USA >>> >>> >>> >>> Kirill S. Palagin wrote: >>>> Hello. >>>> >>>> Is there a (non-macro) way to generate fill series skipping every >>>> second >>>> row with increment >1? >>>> That is I want result to be like "1, blank, 3, blank, 5, blank, 7". >>>> >>>> Thanks a lot. >>>> WBR, >>>> K. Palagin. >>>> >>>> >>> >>> - >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/Calc---Fill-series---filling-every-second-row-with-increment%3E1---tf3551502.html#a9915684 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc - Fill series - filling every second row with increment>1 ?
I shouldn't have taken 1 as the inevitable beginning: =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+$A$1;"") TerryJ wrote: > > I am always intrigued by questions like this. Assuming your start cell is > A1, enter the following formula in A2 and drag it down: > =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+1;"") > > > Joe Conner wrote: >> >> Yes. In cell A1 enter 1. >> In cell A3 enter =A1+1 >> Click on cell A2. >> Holding down the shift key, >> press the down arrow 2 times. >> This will paint cells A2, A3. >> Copy (CTRL C). >> Click on cell A4. >> Hold down the shift key. >> Press CTRL and Down Arrow >> Paste (CTRL V). >> There you have it. >> >> Joe Conner, Poulsbo, WA USA >> >> >> >> Kirill S. Palagin wrote: >>> Hello. >>> >>> Is there a (non-macro) way to generate fill series skipping every second >>> row with increment >1? >>> That is I want result to be like "1, blank, 3, blank, 5, blank, 7". >>> >>> Thanks a lot. >>> WBR, >>> K. Palagin. >>> >>> >> >> - >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> > > -- View this message in context: http://www.nabble.com/Calc---Fill-series---filling-every-second-row-with-increment%3E1---tf3551502.html#a9915592 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc - Fill series - filling every second row with increment>1 ?
I am always intrigued by questions like this. Assuming your start cell is A1, enter the following formula in A2 and drag it down: =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+1;"") Joe Conner wrote: > > Yes. In cell A1 enter 1. > In cell A3 enter =A1+1 > Click on cell A2. > Holding down the shift key, > press the down arrow 2 times. > This will paint cells A2, A3. > Copy (CTRL C). > Click on cell A4. > Hold down the shift key. > Press CTRL and Down Arrow > Paste (CTRL V). > There you have it. > > Joe Conner, Poulsbo, WA USA > > > > Kirill S. Palagin wrote: >> Hello. >> >> Is there a (non-macro) way to generate fill series skipping every second >> row with increment >1? >> That is I want result to be like "1, blank, 3, blank, 5, blank, 7". >> >> Thanks a lot. >> WBR, >> K. Palagin. >> >> > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Calc---Fill-series---filling-every-second-row-with-increment%3E1---tf3551502.html#a9915546 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Recent File List
Gary-88 wrote: > > Hello, > I am currently using Open Office version 2.2 the latest I just recently > upgraded from 2.1 now how can I remove the list of recent files in the > recent folder as the links are now dead links items I no longer need but > cant find a way to the clear the recent list. > Hope u can help > > > Regards, > > Gary Wilcox > > Email: [EMAIL PROTECTED] > > Selsley Weather Station > Latitude: N51°46 798 > Longitude: W2°15 006 > Elevation: 110 FT > Website: http://www.selsleyweather.co.uk > > Weather monitoring at Selsley near Stroud Gloucestershire UK on the edge > of the Severn Vale > That is a vexed question. An issue has probably been filed. The only way currently to remove only the recent files list is to remove the entire file history from the file Common.xcu in your user settings folder. NOT the file of the same or similar name in the programme folders. You can also rename or move that file after exiting all OOo processes (including the Quick Starter). OOo will create a new file when re-started. You will lose other settings contained in the file if you use that method. You would need to examine the file to see what those might be - or just try it because you can always restore the old file if anything valuable is lost. I understand from someone who has experimented that nothing of consequence is affected. The device of renaming or moving the file is endorsed in the draft User Guide. -- View this message in context: http://www.nabble.com/Recent-File-List-tf3547735.html#a9911241 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Support the project
TQ.Hung wrote: > > Dear Sir/ Madam ! > > > My name's Hung. I'm working as a project manager in Technological > Application and Production Company -TECAPRO > > Which use Open Office software for education's purpose, therefore we need > your support in this project interm of Empowerment Letter . > > I'm hope to receive your repply asap because on 16th April, 2007 I'm going > to submit the tender document > > Support: > Technological Application and Production Company Ministry of > Defence-TECAPRO > > Add: No 18 A Cong hoa Ward 12 - Tan Binh District -HCMc - Viet Nam > No 24 Nguyen Truong To- Ba Dinh - Ha Noi - Viet Nam > > Lot 2 - Network Equipents-PC: > Development Support Project for Higher Education Traning in Informatics > and > Communication funded by Japan Government's ODA in 2006. > > Bidder: > Project Management Board of "Development Support Project for Higher > Education Training in Informatics and Communication " - Hanoi Technology > University. > > Suit 805, 8th Floor, Ta Quang Buu Library Building, Hanoi Technology > University > Add: No.1 Dai CO Viet Str., Hanoi. > Tel: 04 2153270 - 04 8681954 > Fax : 04 8694539 - 04 8684946 > > Ta Quoc Hung > -- > Best Regards > TECAPRO Co. > 24 Nguyen Truong To, Hanoi, Vietnam > Tel: (84) 4 7163914 > Fax: (84) 4 7162452 > Mobile: (84) 988714779 > Email: [EMAIL PROTECTED] > > What do you mean by "empowerment letter"? One of the following pages may provide what you require: http://www.openoffice.org/license.html http://www.openoffice.org/licenses/PDL.html -- View this message in context: http://www.nabble.com/Support-the-project-tf3547737.html#a9911164 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Excell Macros won't work
Dan Lewis wrote: > > On Saturday February 24 2007 1:24 pm, Gerald Glass wrote: >> I am using Openoffice ver. 2.1 and I cannot get a excell >> spreadsheet to work in Calc format. It is a spread sheet that I use >> in my business quite frequently. I obtained the spread sheet from a >> vendor for doing a specific job. When I convert it to openoffice, >> it does not calculate correctly when the macros are enabled. I am >> attaching the spread sheet in excell format. The problem is in the >> formula in D10. Any help will be appreciated. Gerald Glass >> [EMAIL PROTECTED] > > Attachments are stripped from emails to prevent the spread of > viruses and trojan horses to the members of this list. > At the present time, Calc will not run macros written in VBA. It > uses Star Basic which is similar. Parts of the macro will have to be > rewritten for it to work in Calc. Formulas are not always written the > same either. > If we knew what formula was in D10 and what you wanted it to do, > someone one this list probably could tell you what the correct > formula should be. Changing the formula could solve your problem. > > Dan > > I understand that the Novell version of OOo will run VBA macros. Otherwise, check the following thread, especially the section headed "VBA": http://www.oooforum.org/forum/viewtopic.phtml?t=50952 As Dan says, there may be a function in Calc to replace the one you have lost, although I have seen no evidence that Calc is ahead in that area. You need to explain what the function does. -- View this message in context: http://www.nabble.com/Excell-Macros-won%27t-work-tf3547738.html#a9911132 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Dumb e-mail question??
linuxmaillists wrote: > > On Monday 09 April 2007, William Case wrote: >> Hi; >> >> I couldn't help noticing the number of queries there are >> on this list from new users / potential users for an >> integrated "Outlook -like" component. I use OOo plus >> evolution. That seems to do everything. >> >> What integrated extra am I missing by no longer using my >> WindowsXP/MSOffice/Outlook? What are the posters looking >> for? >> >> Just curious! > > I agree. I use Linux, OOo, Kontact (KDE). I have not been > able to figure out what their problem is with OOo. Kontact > functions nearly identical to Outlook AFAIR (I have not > used Outlook in 5 years). My wife still uses Outlook and > it appears to be no different then it was then. > > IIRC, the part that's missing is a shared calendar of events and appointments. -- View this message in context: http://www.nabble.com/Dumb-e-mail-question---tf3549964.html#a9911096 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Default font setting in Calc?
linuxmaillists wrote: > > On Monday 09 April 2007, [EMAIL PROTECTED] wrote: >> In writer I can set the default font to whatever I want >> it to be so that a new document starts with that font. I >> have not found where I can do that with Calc. >> >> Running 2.2.0 Linux native OOo version on Fedora Core 6 >> not the FC version > > I think the only way is to change the default style to > whatever you like > and then File → Templates → Save… > Then File → Templates → Organize… → Double click the > folder "My Templates" → > Look for your template → Right click it → Set As Default > Template. > Now, create a new spreadsheet to verify that your favourite > font is being > used by default. > It's probably not necessary to change the default style. I > think another way > is to select all cells, change the font, then follow my > steps for saving a > template and making it the default template. > > Thank you Johnny Andersson! > > -- > If the word following begins with > a vowel, the word you want is... > to read the rest of this, go here > http://www.wsu.edu/~brians/errors/a.html > > I believe it's better to change the default style. Otherwise, you need to change the format of every cell on every sheet. I have not tested that but I imagine it would add considerably to the size of the file and detract from its performance. Furthermore, the "default font" would not apply to any sheet subsequently added to the file. -- View this message in context: http://www.nabble.com/Default-font-setting-in-Calc--tf3549089.html#a9911066 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Question regarding upgrade to OOo 2.2
Pradeep Srinivas wrote: > > Folks, > > Currently running > OpenOffice.org 2.1 > Intel > Linux 2.6.20-1.2311.fc5 > > Would like to upgrade to OpenOffice.org 2.2 > > I have downloaded OOo_2.2.0_LinuxIntel_install_wJRE_en-US.tar.gz > > Questions: > Would I need to uninstall OOo 2.1 prior to the installing 2.2 > Would I need to protect (or take care of some settings) before I install > 2.2, > or would the original settings be taken care of during the upgrades ? > > Probably these questions have been answered elsewhere, and if so, my > apologies - please point me in the right direction and I will (as usual) > blunder on > > Many thanks ! > -- > Pradeep Srinivas > Bangalore, India > > I have seen one report by a user that he lost templates when updating; it may be that all he has lost are the links to the templates. The dictionary.lst file will be overwritten and, evidently, there can be problems with dictionaries. I understand that issues have been filed about the dictionary problems. I suggest you back up any files containing data or settings and any files you have customised. You should back up your user settings folder regularly because otherwise, if the folder goes awry, you have to create a new folder, which means you begin again with all those nasty default settings. -- View this message in context: http://www.nabble.com/Question-regarding-upgrade-to-OOo-2.2-tf3546115.html#a9899388 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I have just download openoffice. I was wondering if you have voice recognition software that is compatible with this program?
Crystal Brewster wrote:
>
>
>
>
>
> v\:* {behavior:url (#default#vml);}
>
> v\:* {
> BEHAVIOR: url (#default#vml)
> }
>
>
Hi. My reply got mixed up with your message, so here it is again:
I understand that Dragon Naturally Speaking version 9 works to a degree
with Writer at least. Better results are obtained using something called
DragonPad.
People who want Dragon to work with OpenOffice.org software need to make
their views known to Dragon.
OpenOffice.org has an accessibility project. For what it is worth, this
is the url: http://ui.openoffice.org/accessibility/
--
View this message in context:
http://www.nabble.com/I-have-just-download-openoffice.-I-was-wondering-if-you-have-voice-recognition-software-that-is-compatible-with-this-program--tf3544762.html#a9897634
Sent from the openoffice - users mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I have just download openoffice. I was wondering if you have voice recognition software that is compatible with this program?
Crystal Brewster wrote:
>
>
>
>
>
> v\:* {behavior:url (#default#vml);}
>
> v\:* {
> BEHAVIOR: url (#default#vml)
> }
>
> Hi. I understand that Dragon Naturally Speaking version 9 works to a
> degree with Writer at least. Better results are obtained using something
> called DragonPad.
>
> People who want Dragon to work with OpenOffice.org software need to make
> their views known to Dragon.
>
> OpenOffice.org has an accessibility project. For what it is worth, this
> is the url: http://ui.openoffice.org/accessibility/
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
--
View this message in context:
http://www.nabble.com/I-have-just-download-openoffice.-I-was-wondering-if-you-have-voice-recognition-software-that-is-compatible-with-this-program--tf3544762.html#a9897625
Sent from the openoffice - users mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc - Date auto subtract!
Steven Lim-3 wrote: > > Hi. > > With cell format set to user define - D-MMM-YY, i keyed in 01/01/1972 in > cell and the date auto subtracted and appear as 31-Dec-71. Tried several > times and this still happens. > > Please assist. > > Regards. > > Steven. > > The only thing that occurs to me is your "Date" (start date) setting. Look at Tools >Options >Calc >Calculate. On the top right of the panel, under the heading "Date", you should have 30/12/1899(default) selected. AFAIK, the setting only has the effect you mention when altered after a date is entered. IOW, if I enter 1/172 when the second option (StarCalc 1.0) is selected and subsequently change the setting back to the default, the date changes to 31/12/71. Did your spreadsheet by any chance begin life as a StarCalc document? BTW, the format D MMM YY is standard in my version and the date enters and displays correctly. -- View this message in context: http://www.nabble.com/Calc---Date-auto-subtract%21-tf3544752.html#a9896609 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OpenOffice.org 2.2 keeps forgetting my dictionary settings, just like OpenOffice.org 2.1 did
Johnny Andersson-3 wrote: > > Can anyone please tell me how to make OpenOffice.org to remember that > "Tools > → Options → Language settings → Writing Aids → User defined dictionaries → > Johnny's Dictionary" always should be checked when OpenOffice.org is > started? Every time I start OpenOffice.org, it's unchecked, no matter what > it was last time I worked with it. This means that I have to manually > check > it every time I start OpenOffice.org. Very annoying. > > When OpenOffice.org 2.2 was recently installed, it actually remembered > that > setting, but the day after and since then it doesn't. The only difference > between that first day and the rest of the days, is that the Quickstarter > was activated the first day, until I removed it later that day. > > I have tried everything I could think of, such as saving the settings in a > template, in a document and things like that, but nothing worked so far. > It > SEEMS like it worked when the Quickstarter was activated, but I am not > sure. > What's going on here? It was the same with OpenOffice.org 2.1, however not > with OpenOffice.org 1.1.5 if I remember it correctly. > > Johnny Andersson > > Have a look at this thread: Can't save options (Issue filed) - http://www.oooforum.org/forum/viewtopic.phtml?t=53047 -- View this message in context: http://www.nabble.com/OpenOffice.org-2.2-keeps-forgetting-my-dictionary-settings%2C-just-like-OpenOffice.org-2.1-did-tf3542251.html#a9889917 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Question about draw lines in the "Calc"
Dan Lewis wrote: > > On Friday April 06 2007 8:13 pm, Dan Lewis wrote: >> On Friday April 06 2007 7:59 pm, TerryJ wrote: >> > Renaud (Ron) Olgiati wrote: >> > > >> > > from Konstantin <[EMAIL PROTECTED]> who wrote: >> > >> So, I have one very simple question about Calc. Is there any >> > >> chance to draw separated lines around cells? (Like on attached >> > >> screenshot) >> > > >> > > >> >> In case the attachment makes it through the mail server, it is >> a screen shot of a cell with four different type borders. I created >> it by creating a new cell style and applying a different border to >> each side. >> >> Dan > > Sorry, it got stripped. Here is the URL to it: > http://www.delewis.com/OOo/snapshot9.png. I even managed to have four > different colors. > > Dan > > By "separated lines", I understood something like , i.e. dots or dashes or both. You posted before my follow up message. It is possible to use all the surrounding cells as containers for broken lines which serve as borders for the surrounded cell, but probably more trouble than it's worth and not practicable if you need to use the adjoining cells for other data. There are no line styles using broken lines (dots and/or dashes). -- View this message in context: http://www.nabble.com/Question-about-draw-lines-in-the-%22Calc%22-tf3539223.html#a9880509 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Open Office help w/ calc
Brian Barker wrote: > > At 15:09 05/04/2007 -0700, Willam Balderrama wrote: >>when entering 16 digit numbers on the Open Office Calc, how am I >>able to cut and paste into cells w/out getting a formula. This >>happens whenever I enter a lot of digits on one line or try to copy >>and paste it onto another. I really need your help! > > I don't see any reason why you should get a formula. A formula is an > expression involving other cell references, and always starts with an > equals sign. Is that what you are getting? > > Perhaps you have a different problem: that Calc is displaying the > result in standard form, so that 1234567890123456 will display as > 1.23E+015 instead. This is correct: it means 1.23 multiplied by ten > to the power 15, and this form of display is usually helpful. If you > want it in another format, you just have to format the cell(s) > appropriately. > > Select the relevant cells and go to Format | Cells... (or > right-click | Format Cells...) and then Numbers. Select "Number" > under Category and change the selection under Format from "General" > to "-1234" (or whatever is appropriate), and you will get what you > need. You may then have to expand the column width to see all those > digits, of course. > > Brian Barker > > 15 is the maximum number of digits which Calc will accept for a number without converting it to scientific format. When some of the digits are to the right of the decimal separator, it rounds the number to bring it back to the maximum; IIRC, the decimal separator is counted as a digit. -- View this message in context: http://www.nabble.com/Open-Office-help-w--calc-tf3536559.html#a9880477 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Downloading the .iso for cd burning
Renaud (Ron) Olgiati wrote: > > On Friday 06 April 2007 12:06, my mailbox was graced by a missive > from Dan Lewis <[EMAIL PROTECTED]> who wrote: > >> However, as it states there are no ISO images available yet for 2.2. > > So I'll jist have tae bide a wee. > > Ta, > > Ron. > > History tells us you will have to bide longer than that. There is a dvd which contains OOo for all OSs: http://on-disk.com/product_info.php/manufacturers_id/12/products_id/94 -- View this message in context: http://www.nabble.com/Downloading-the-.iso-for-cd-burning-tf3536738.html#a9880434 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Question about "Writer" and "Calc"
Konstantin-9 wrote: > > Hello sir, > Why both apps Writer and Calc cannot recognize automatically what > language I am writing now and use corresponding dictionary to check up > my spelling? > Should I do this setting manually all the time by clicking right button > of mouse and set the language? > How can I automate it like MS Word does? > > -- > Regards, > Konstantin mailto:[EMAIL PROTECTED] > > > P.S. There is a very good idea to put media player into Calc and > Word. Thanks > > In Calc at least, you can impose language settings on a document using Tools >Options >Language Settings >Languages and select the box "For the Current Document Only". Otherwise, you can use Styles. There are chapters relating to styles in the Writer and Calc guides (and perhaps elsewhere) on the following page: http://documentation.openoffice.org/manuals/oooauthors2/index.html Regarding your PS, in Calc on Windows, I understand that you can insert a hyperlink to a sound file and clicking the hyperlink will play the file with the associated software. -- View this message in context: http://www.nabble.com/Question-about-%22Writer%22-and-%22Calc%22-tf3539237.html#a9880395 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Question about draw lines in the "Calc"
TerryJ wrote: > > > > Renaud (Ron) Olgiati wrote: >> >> On Friday 06 April 2007 10:47, my mailbox was graced by a missive >> from Konstantin <[EMAIL PROTECTED]> who wrote: >> >>> So, I have one very simple question about Calc. Is there any chance to >>> draw separated lines around cells? (Like on attached screenshot) >> >> Format => Cell => Border => Line Style ? >> >> Cheers, >> >> Ron. >> >> > > In short, no. There are no such line styles in Calc. You can use dashes > in the cells above and below and alter alignment in those cells so that > you have top and bottom border-like lines. You can do the same in the > cell to the right and on Format >Cells >Alignment alter text orientation > by 270° . The left border has me stumped. > Temporary blackout. Cell on the left: text orientation 90° and horizontal alignment "Right". -- View this message in context: http://www.nabble.com/Question-about-draw-lines-in-the-%22Calc%22-tf3539223.html#a9880326 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Question about draw lines in the "Calc"
Renaud (Ron) Olgiati wrote: > > On Friday 06 April 2007 10:47, my mailbox was graced by a missive > from Konstantin <[EMAIL PROTECTED]> who wrote: > >> So, I have one very simple question about Calc. Is there any chance to >> draw separated lines around cells? (Like on attached screenshot) > > Format => Cell => Border => Line Style ? > > Cheers, > > Ron. > > In short, no. There are no such line styles in Calc. You can use dashes in the cells above and below and alter alignment in those cells so that you have top and bottom border-like lines. You can do the same in the cell to the right and on Format >Cells >Alignment alter text orientation by 270° . The left border has me stumped. -- View this message in context: http://www.nabble.com/Question-about-draw-lines-in-the-%22Calc%22-tf3539223.html#a9880308 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc converts number 4.05 to date - how do I stop?
Kirill S. Palagin wrote: > > Hello everybody. > > I have dot (.) as decimal separator. Whenever I type "4.05" (without > quotes) Calc "helpfully" converts this to date. > I can not format cells as Text (or prefix number with apostrophe) > because I need to perform calculations on that data. > > How do I stop Calc from being helpful? > > Thanks a lot. > WBR, > K. Palagin. > P.S. In fact the problem is bigger than just typing - I am importing > text files where dot is used as decimal separator, so changing decimal > separator to comma would not solve the problem. > > The problem probably arises because your locale setting treats the dot as a "date separator" (for want of a better expression). IIRC, the remedy when importing .csv is to use the "Text Import" dialogue. Select the column/s containing the data in question and then, for "column type", select "US English". HTH. -- View this message in context: http://www.nabble.com/Calc-converts-number-4.05-to-date---how-do-I-stop--tf3538440.html#a9880243 Sent from the openoffice - users mailing list archive at Nabble.com. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
