Re: [users] Fwd: Project on Openoffice
On Wed, Jun 23, 2010 at 2:26 PM, inderjeet singh wrote: > also i want to do some programming by which i can adjust the amount of > contents that is to included in report Seems good project. but this list may not be able to help you. Post on d...@openoffice.org -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] .odt on fly
Is there some module / library by which one can generate .odt or .ods file from a webpage using php and fetching data from MySQL instead of producing html page. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Applying different template to OOcalc
On Mon, Sep 28, 2009 at 11:55 AM, Brian Barker wrote: > At 06:56 28/09/2009 +0530, H.S. Rai wrote: >> >> Changing look and feel of OOcalc document seems not there, whereas it is >> there for OOWriter and OOimpress. How one can apply different template to >> OOcalc document ... > > In the same way that you would for other document types: > o Create a document with the properties you desire. > o Go to File | Templates > | Save... to save the document as a template. > o Create new documents based on this in one of various ways, including File > | New > | Templates and Documents. I was asking about old file. >> ... or import style from different file? > > This does indeed seem to be missing from Calc. Doeas it work: unzip foo.ods replace styles.xml with styles.xml of different file, style of which you want to import. zip files rename as foo.ods -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Applying different template to OOcalc
Changing look and feel of OOcalc document seems not there, where as it is there for OOWriter and OOimpress. How one can apply different template to OOcalc document or import style from different file? -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: Shifting of symbols
On Sun, Sep 27, 2009 at 6:59 PM, Brian Barker wrote: > > The reason that your description does not appear at the top of the cell is > that this setting is overpowered by the 4.99 mm spacing to contents that you > have set (all around). This is on the Borders tab of the Format Cells > dialogue. O.K. >> On trying to change base point for position of symbol failed. > > Interestingly, each of your symbols is indeed anchored to a cell - but the > cell above that in which it is placed. Strange! How to anchor in a cell, in which I enter it. > Possibly anchor the graphics in their own cells. How it can be done? >> In other big document, when I inserted a row, all symbols shifted in wrong >> manner (It shifted "Description, but not "symbol" for newly inserted row, >> i.e. new inserted row had a symbol in it, i.e for rest of rows it "shifted >> relatively 1, instead of zero). > > That is what you would see if the graphics are anchored To Page instead of > To Cell. No. Graphics was anchored to "Cell" > Incidentally, if all you want is Greek letters, you can insert these as text > characters in many fonts, without the need for graphics at all. Fine. But I need formulae like M_u / b d^2 Thanks for your reply. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc: Shifting of symbols
In OOcalc I wanted to use formula (symbols) and then some mathematical formula or its description in next cell. For sysmbol is used "Anchored to Cell", for description, I used "Vertical Alignment: Top". With this arrangement I was unable to get symbol and description in a line. On trying to change base point for position of symbol failed. Please see: http://picasaweb.google.co.in/hardeep.rai/Temp#5385972517172890082 On deleting row containing "Beta", it deleted symbol "Beta" as expected but also deleted symbol "pi", i.e symbol of next line. http://picasaweb.google.co.in/hardeep.rai/Temp#5385972513748603090 File is at: http://gndec.ac.in/~hsrai/tmp/ooFormula.ods How I can keep content of a row in a line (align vertically) and why it deleted two symbol. In other big document, when I inserted a row, all symbols shifted in wrong manner (It shifted "Description, but not "symbol" for newly inserted row, i.e. new inserted row had a symbol in it, i.e for rest of rows it "shifted relatively 1, instead of zero). -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Date changes
On 5/25/09, Brian Barker wrote: > > At 22:43 24/05/2009 +0530, H.S. Rai wrote: > >> http://www.goldentemplephotos.com/datesheet_new.xls has row no 362, 363 >> when opened using OpenOffice 3.0.1 (on Ubuntu 9.04) build 9379 shown as: >> >>29/5/2009 EVENING 6TH CE-304 Geotechnical Engg. CIVL A0619 >>06/01/2009 EVENING 6TH CE-306 Irrigation Engineering-I CIVL A0620 > > Those who are not on OO and Ubuntu mailing list and interested in this thread, should see mail on other list also: OpenOffice mailing list http://www.openoffice.org/servlets/BrowseList?list=users&by=thread&from=2234266 Ubuntu mailing list https://lists.ubuntu.com/archives/ubuntu-users/2009-May/thread.html#185836 While Google Doc as well MSExcell shows 01/06/2009 for row no. 363 (which is >> correct), that mean 1st of June is shown as 6th of Jan. Such error is there >> for many rows in same spreadsheet. >> >> Where is problem? With excel spreadsheet or with OpenOffice? >> > > Probably neither! > > Whoever created this spreadsheet or entered the data has done so > inconsistently. Most of the data in column A, though it looks like dates, > is actually text strings. Select A362, for example, and look in the Input > Line: you will see the tell-tale leading apostrophe, indicating that what is > there is the text string "29/5/2009" and not a date (which could display the > same way). But some values, including your example of A363, have been > entered as dates. A363 actually contains the sixth of January, not the > first of June. > > How has this happened? The display of dates in spreadsheets follows the > locale setting. That's what I suspected. For a US locale, for example, dates will be interpreted as meaning > month/day/year, but for many other locales (are you in India?), the more > logical day/month/year is used. Very probably, someone had the locale set > to US and managed to enter the wrong dates so that they displayed as they > expected with the wrong locale setting! This shows up only when you use the > spreadsheet with a different locale: the genuine dates change their display > but the text strings do not. (Are your Google and Excel using a US style?) I don't have Excel on my Laptop, I requested somebody on different PC to check it. He might have USA locale and reported correct date. Google might be using locale from its server, not from local PC as it is web browser (not sure, but on my same laptop I could see so called correct display with Google Doc) This file is date sheet for Punjab Technical University ( http://ptu.ac.in/). I believe, clerk entered all date in format dd/mm/ for a machine having locale mm/dd/. So valid dates for PC(dd (as assumed by clerk, and mm taken by computer) < 13) taken as date and others are as text. This has highlighted problems of using default setting without applying mind. People don't mind having "color" (corrected by default setting) and writing "colour" by hand as taught in their school. However, using default locale as above and not using software in proper manner can create havoc. -- H.S.Rai
[users] Date changes
http://www.goldentemplephotos.com/datesheet_new.xls has row no 362, 363 when opened using OpenOffice 3.0.1 (on Ubuntu 9.04) build 9379 shown as: 29/5/2009 EVENING 6TH CE-304 Geotechnical Engg. CIVL A0619 06/01/2009 EVENING 6TH CE-306 Irrigation Engineering-I CIVL A0620 While Google Doc as well MSExcell shows 01/06/2009 for row no. 363 (which is correct), that mean 1st of June is shown as 6th of Jan. Such error is there for many rows in same spreadsheet. Where is problem? With excel spreadsheet or with OpenOffice? -- H.S.Rai
[users] Calc: Copying style from another file
In OOwriter, you can go to Format -> Style and Formatting -> New style from selection -> load style -> from file to use style defined in another file. How similar thing can be achieved in Calc? It do not have option "Load style" under New style from selection. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc function: ; or ,
On Wed, Apr 8, 2009 at 8:02 AM, JOE Conner wrote: >> >> Helpfile says that arguments of a function like if and round need to >> be separated by ";", but that gives error and in place of that "," is >> working fine. >> >> Why is it so? >> >> Using OO 3.01 on Ubuntu. >> > > Are you by chance using Go-OO or OxygenOffice? They have ported field > separation to commas, but did not change the help files to reflect it. I > got caught up in this last month. That might be. http://go-oo.org/download/ has following mention: Debian provides Go-OO in their repositories. To install it just type as root # apt-get install openoffice.org Ubuntu provides Go-OO in their repositories. To install it just type as root # apt-get install openoffice.org Does not it make files incompatible from this socalled openoffice and real openoffice. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Figures in Calc using cell values
Is it possible to draw figures on the basis of values taken from cells. Like drawing rectangle of length equal to value of cell A1, and breadth equal to value of cell B1. If A1, and B1 are having values 10,5, rectangle is of size 10x5, and if B1 is changed to 10, it should become square of size 10. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc function: ; or ,
Helpfile says that arguments of a function like if and round need to be separated by ";", but that gives error and in place of that "," is working fine. Why is it so? Using OO 3.01 on Ubuntu. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office bad result
2009/4/4 : > open office file from the row 8 ahead the result of the calculation is div by > zero even > the formula is copied from the previous rows and no zero value in the cells > involved. Better, made available your file to examin. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Presentation from document
On Wed, Mar 11, 2009 at 7:18 PM, Carlos Martinez wrote: > Hi Jean, you can use Notes to add some text to the slides as follow: > > Use the Notes view to add notes to a slide: Not slides (in Impress), rather in document (writer). Idea was to have one document, which can be used as presentation with change of style. In pdfLaTeX with pdfscreen package, ( http://www.ctan.org/tex-archive/help/Catalogue/entries/pdfscreen.html ), it is there. -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Presentation from document
Files are available at: http://gndec.ac.in/~hsrai/tmp/OO/ In effort to generate presentation from document without much effort, I prepared two style: ScreenStyle.odt , DocStyle.odt, 1st for presentation and 2nd for document to be printed. Then I prepared a sample document MathDoc.odt with style defined in "DocStyle.odt" (having pdf version MathDoc.pdf ) having math stuff also. Then I loaded style from ScreenStyle.odt as: Format -> Styles and formatting -> select "load styles" from drop down list from icon reading "New style from selection", select text, frame, page, numbering, overwrite, and then click on "From file", select " ScreenStyle.odt", it will change look and feel, save as "MathScreen.odt" export as "MathScreen.pdf". Open it it acrobat reader, go to full screen mode with ctrl L, and you have presentation without pain from document. My question is: Is it right way? How I can improve it and what are drawback of this approach. Is it possible not to display some text at all with application of of style, Say I want paragraphs of type para2, only appear in document and not in presentation. With regards, -- H.S.Rai - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
