RE: [users] open-office writer improvements
Dear tony, Solution for 1) open OO writer. Maximize it. Then Click on same button to : "restore down" Drag it to left-top corner, change size by click & drag from right-bottom corner of Oowriter.(make it like horizontal rectangle so half desktop can be visible ) Open other application do same step to set it on right-top corner of screen. Solution for 2) Select "Default" option as shown in attached screen-shot. (Or u can use "Clear Formatting" option as shortcut ) Regards, * Ketan Patel * IT Deptt. -Original Message- From: Tony Carr [mailto:car...@gmail.com] Sent: Monday, September 27, 2010 6:40 AM To: open office Subject: [users] open-office writer improvements I'm using OpenOffice 3.2 and Windows 7 on an HP530 laptop. Two small irritations have bugged me for most of a decade - maybe there is a workaround? Or maybe it's all Bill Gates' fault? 1: When I reduce OO Writer to part-screen, by default it hogs almost the whole centre of the screen! Obviously a user makes it part-screen so he can view some other application at the same time - so why make that impossible? (At least in recent versions it remembers where I moved it to, even if later closures were from full-screen mode.) 2: When I click the Font-size drop-down tab, the menu only shows LARGER font sizes. So exactly half the time I have to laboriously scroll up to find the size I want. Why not have the menu put the current font-size in the centre? Then almost every desirable font-size would be immediately visible. OO Writer is still a GREAT program, though! Blows my mind that it's free. Tony -- www.godornot.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Disclaimer: The content of this message and any attachments with it is intended only for the named recipients. Information contained in this message may be subject to legal, professional or other privilege or may otherwise be protected by other legal rules. If you are not the intended recipient you are not authorized to disclose, copy, distribute or retain this message or any part of it .If you have received this message in error, please notify the sender and destroy the original message. Any opinion expressed in this communication may be personal to the author and may not necessarily reflect the opinion of Bajaj Allianz General Insurance Co. Ltd. While we scan all e-mails, we cannot guarantee that any e-mail is virus-free and accept liability for damages caused by any virus transmitted by this email. The information contained in this e-Mail is classified as Internal - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
RE: [users] drawing arc with defined angle (was Re: [users] inaccessible toolbar)
Dear Mike and all: There is an add-on to Oo Draw known as CAD00o. This gices you some limited CAD-Like macros, but they are a bit more awkward to use for a CAD experienced user than Autocad. But them they are free, not a matter of $5000 or More US$. I do a lot of CAD-like stuff in draw, but I have to use quite a different approach from what I used in either Generic Cad or Autocad. Also the mathematical precision of Draw is somewhat limited, so don't expect results to 12 decimal places! Best Regards, Bruce M. -Original Message- From: Mike Scott [mailto:m...@scottsonline.org.uk] Sent: September 26, 2010 15:13 To: users@openoffice.org Subject: [users] drawing arc with defined angle (was Re: [users] inaccessible toolbar) On 26/09/2010 16:43, TomW wrote: > On 2010-09-26 09:36, Mike Scott wrote: >> A very silly problem here. I've been trying to access the 'circles and >> ovals' toolbar - but it doesn't appear on View | Toolbars. It is shown >> in the toolbars customise menu though. This with Draw 3.1.1 and 3.2 >> (on XP) >> >> According to the menu customize page, View|Toolbars has no submenu, >> which seems wrong. >> >> Ideas please on how to get it back? > > Mike: > > Customize Toolbar. > Create a new toolbar. > Toolbar Content | Add > Category | Drawing > 'Ellipse' > --- _*Note that there are two ellipse choices. The Description will tell > you which one to use*_. > > Who knows why they don't just add it to the toolbar list! Ok, Thanks, that works; doesn't explain why customize 'View | Toolbars' shows no sub-menus. However... on to the /real/ problem. What I want to do is draw a circular arc, subtending an angle of exactly 45 degrees at a given centre. There seem to be no controls to adjust the angle. Wrong tool for the job? -- Mike Scott - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] open-office writer improvements
I'm using OpenOffice 3.2 and Windows 7 on an HP530 laptop. Two small irritations have bugged me for most of a decade - maybe there is a workaround? Or maybe it's all Bill Gates' fault? 1: When I reduce OO Writer to part-screen, by default it hogs almost the whole centre of the screen! Obviously a user makes it part-screen so he can view some other application at the same time - so why make that impossible? (At least in recent versions it remembers where I moved it to, even if later closures were from full-screen mode.) 2: When I click the Font-size drop-down tab, the menu only shows LARGER font sizes. So exactly half the time I have to laboriously scroll up to find the size I want. Why not have the menu put the current font-size in the centre? Then almost every desirable font-size would be immediately visible. OO Writer is still a GREAT program, though! Blows my mind that it's free. Tony -- www.godornot.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Mass edit in calc field - help!
At 10:04 22/09/2010 -0700, Brewster Gillett wrote:
Here's that dadblasted now-you-see-it-now-you-don't "text indicator"
(I seem to recall that's what someone once called it) that I have
got to eradicate.
Don't think of it as a problem: it's there to help!
[...] Unfortunately the way I get the file, as a CSV, those entries
are not formatted specifically as dates, even though they all follow
a common format of MM/DD/. I note that each entry is preceded
*in the edit window*, but *not* in the cell itself, by a single
quote. I believe this single quote is a forced text format
identifier of some sort.
It's just there to tell you that what may look like a date (a variety
of number) is not: instead, it is actually a string of text characters.
I have highlighted that column and (1) tried "FORMAT CELLS" to force
it to "DATE" format - no luck
The only thing you can display as a date is a number (representing
the number of days since the reference date).
(2) invoked Search and Replace to replace the single quote with null
- also no luck - S&R can't *see* the danged single quote, from all appearances.
That's because it doesn't exist in the cell - it's only in the Input
Line to help you.
I have performed both of the above attempts on the file when in its
original .CSV format, and also in its versions that have been saved
as .ODS files.
Whichever format you are choosing to save files, the behaviour whilst
the file is open will be much the same.
At 12:34 22/09/2010 -0700, Brewster Gillett wrote:
The other question is, how can it be that you can highlight
("SELECT") an entire column, go into "FORMAT, CELLS" where it gives
you at least two date options, and the option selection is ignored
WRT the selected cells?
Only numbers can be dates. Any numeric values in your cells will
change to show the date format you have selected. Text values -
however much they might look like dates - cannot change. (Don't be
confused by the fact that if you type something similar into a cell,
it may well be automatically converted to a date.)
I can go back to the "FORMAT" dropdown, and the specific form of
date that I selected earlier is still highlighted, but when I
attempt to perform that operation on even just one cell, it ignores
the selection - is it that single-quote that's binding things up?
No. But it is the fact that your values are text - which is
precisely what the single quote mark is warning you.
At 22:51 22/09/2010 -0700, Brewster Gillett wrote:
Gene Young wrote:
Try substituting the actual cell reference in place of
"THEDATECELL" eg; =DATEVALUE($E5) where cell E5 is the cell that
contains the date.
So I tried it as you describe.
Got a "522" error msg. ("iteration", it says - and even after
reading the description I am not certain how it applies to this case.)
It sounds as if you have tried to put the formula into the same cell
as the data! That means the input to the formula needs to be its own
result. You have created a recursive formula.
You will have seen Bob Long's solution - which is by far the
best. You say you are deriving this information from a CSV
file. All you need to do is to select "Date (MDY)" for Column type
in the Text Import dialogue. Your dates will then appear as dates
(and can be formatted as you wish). As he also suggests, even if you
no longer have access to the CSV file, you can save your data from
Calc as a CSV file and then use the same technique whilst re-importing it.
But if you want a bit of fun, here's another idea. Enter
=DATE(VALUE(RIGHT(C2;4));VALUE(LEFT(C2;FIND("/";C2)-1));VALUE(MID(C2;FIND("/";C2)+1;FIND("/";C2;FIND("/";C2)+1)-FIND("/";C2)-1)))
into D2 and fill it down the column. The FINDs search your text
strings for the slashes and the LEFT, MID, and RIGHT separate the
three parts of the date; VALUE converts each part from text to a
number and DATE reassembles these into a numeric date value. The
result is the date values you require.
Oh, one last point: it sometimes helps in situations such as this to
go to View | Value Highlighting (or Ctrl+F8). This shows text values
in black but numeric values (including real dates) in blue (and the
results of formulae in green).
I trust this helps.
Brian Barker
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Re: [users] drawing arc with defined angle (was Re: [users] inaccessible toolbar)
On 09/26/2010 03:13 PM, Mike Scott wrote:
> On 26/09/2010 16:43, TomW wrote:
>> On 2010-09-26 09:36, Mike Scott wrote:
>>> A very silly problem here. I've been trying to access the 'circles and
>>> ovals' toolbar - but it doesn't appear on View | Toolbars. It is shown
>>> in the toolbars customise menu though. This with Draw 3.1.1 and 3.2
>>> (on XP)
>>>
>>> According to the menu customize page, View|Toolbars has no submenu,
>>> which seems wrong.
>>>
>>> Ideas please on how to get it back?
>>
>> Mike:
>>
>> Customize Toolbar.
>> Create a new toolbar.
>> Toolbar Content | Add
>> Category | Drawing
>> 'Ellipse'
>> --- _*Note that there are two ellipse choices. The Description will tell
>> you which one to use*_.
>>
>> Who knows why they don't just add it to the toolbar list!
>
> Ok, Thanks, that works; doesn't explain why customize 'View |
> Toolbars' shows no sub-menus. However... on to the /real/ problem.
>
> What I want to do is draw a circular arc, subtending an angle of
> exactly 45 degrees at a given centre. There seem to be no controls to
> adjust the angle.
>
> Wrong tool for the job?
>
What I discovered is that if you draw the circle with an arc, then click
and drag
the yellow dots, it will change the angle of the arc.
However, there is no way to determine the accuracy of the angle.
Good luck!
Tom
--
Quis custodiet ipsos custodes? -- Decimus Iunius Iuvenalis (Juvenal), Roman
Poet, late 1st, early 2nd century AD
("Who will protect us from the protectors?")
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
[users] drawing arc with defined angle (was Re: [users] inaccessible toolbar)
On 26/09/2010 16:43, TomW wrote: On 2010-09-26 09:36, Mike Scott wrote: A very silly problem here. I've been trying to access the 'circles and ovals' toolbar - but it doesn't appear on View | Toolbars. It is shown in the toolbars customise menu though. This with Draw 3.1.1 and 3.2 (on XP) According to the menu customize page, View|Toolbars has no submenu, which seems wrong. Ideas please on how to get it back? Mike: Customize Toolbar. Create a new toolbar. Toolbar Content | Add Category | Drawing 'Ellipse' --- _*Note that there are two ellipse choices. The Description will tell you which one to use*_. Who knows why they don't just add it to the toolbar list! Ok, Thanks, that works; doesn't explain why customize 'View | Toolbars' shows no sub-menus. However... on to the /real/ problem. What I want to do is draw a circular arc, subtending an angle of exactly 45 degrees at a given centre. There seem to be no controls to adjust the angle. Wrong tool for the job? -- Mike Scott - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Change in cursor movement behaviour
In OOo 3.0, I could select a range of cells using shift & right-arrow and down-arrow, then Ctrl-C to copy, and when I moved the cursor down, it would move down relative to the top-left of the block, and I could paste it all one line down. Now in 3.2.0, when I press the down arrow after copying, the cursor goes down from the bottom-right of the block! This may sound like a minor, superficial change, but when you have habits formed that you execute rapidly then this kind of change can completely throw off your rhythm. I have looked around the Preferences dialog but can't find any options that relate to this. Does anyone know if this is a hidden behavioural option that I can change back, because right now I am sorely tempted to revert to 3.0! Phil Hibbs. -- Don't you just hate self-referential sigs? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] inaccessible toolbar
On 2010-09-26 09:36, Mike Scott wrote: A very silly problem here. I've been trying to access the 'circles and ovals' toolbar - but it doesn't appear on View | Toolbars. It is shown in the toolbars customise menu though. This with Draw 3.1.1 and 3.2 (on XP) According to the menu customize page, View|Toolbars has no submenu, which seems wrong. Ideas please on how to get it back? Mike: Customize Toolbar. Create a new toolbar. Toolbar Content | Add Category | Drawing 'Ellipse' --- _*Note that there are two ellipse choices. The Description will tell you which one to use*_. Who knows why they don't just add it to the toolbar list! TomW - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Translation work of OxygenOffice, released extensions and upcoming extensions
Dear Translators, I would like to introduce three new extension of OxygenOffice Professianl Team. All of them are opensource and free. http://wiki.services.openoffice.org/wiki/Diagram_Extension http://wiki.services.openoffice.org/wiki/WatchWindow_Extension http://wiki.services.openoffice.org/wiki/Validator_Extension You can find the translators' pack here: http://ooo.itc.hu/oxygenoffice/download/translator/extension-translation-20100926.zip Please translate the properties files. You should copy original en_US files to your language then you can translate the files. Also please translate the files in description and licenses too. If you have questions do not hesitate to ask me. Thank you in advance! Best regards, KAMI
Re: [users] inaccessible toolbar
On 26 September 2010 14:36, Mike Scott wrote: > A very silly problem here. I've been trying to access the 'circles and > ovals' toolbar - but it doesn't appear on View | Toolbars. It is shown in > the toolbars customise menu though. This with Draw 3.1.1 and 3.2 (on XP) > > According to the menu customize page, View|Toolbars has no submenu, which > seems wrong. > > Ideas please on how to get it back? > > > My OOo 3.2.1 on Win XP Pro also does *not* have a viewable "circles and ovals" toolbar although a toolbar by that name is apparently customisable. Weird. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
Re: [users] table - dismantling
On 9/26/2010 3:30 AM, Brian Barker wrote: At 17:40 23/09/2010 -0500, Barbara Duprey wrote: On 9/23/2010 4:04 PM, Tony Carr wrote: In .odt documents, I often wish to take text which has been enclosed in a table and remove the table - while keeping the text. Obviously I can copy the text to the document just outside the table, then delete the table-and-contents. Is there another way? Yes, there sure is. Just click in the table and Table > Select, then Table > Convert > Table to Text. Except that it's easier still: you don't actually need to select the table - just to have the cursor in it. Brian Barker Right you are! So many things respond to the selection that I just do it automatically, even when it isn't necessary. :-[ - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] inaccessible toolbar
A very silly problem here. I've been trying to access the 'circles and ovals' toolbar - but it doesn't appear on View | Toolbars. It is shown in the toolbars customise menu though. This with Draw 3.1.1 and 3.2 (on XP) According to the menu customize page, View|Toolbars has no submenu, which seems wrong. Ideas please on how to get it back? -- Mike Scott - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] table - dismantling
At 17:40 23/09/2010 -0500, Barbara Duprey wrote: On 9/23/2010 4:04 PM, Tony Carr wrote: In .odt documents, I often wish to take text which has been enclosed in a table and remove the table - while keeping the text. Obviously I can copy the text to the document just outside the table, then delete the table-and-contents. Is there another way? Yes, there sure is. Just click in the table and Table > Select, then Table > Convert > Table to Text. Except that it's easier still: you don't actually need to select the table - just to have the cursor in it. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Comparing two strings - resort to compare using bash - OOcalc has no substring functions
At 11:58 23/09/2010 -0700, John Bowling wrote: ... OOcalc has no substring functions Er, what about such functions as CONCATENATE(), FIND(), LEFT(), MID(), RIGHT(), REPLACE(), SEARCH(), SUBSTITUTE(), TRIM(), ...? I have columns that contain addresses. Column A is number and street as in '1234 N Main'. Column B is the building and unit number as in 'F456'. Column C is the address as it would be placed on an envelope: '1234 N Main F456'. I need to indicate in another column if the combination of column A concatenated to column B is exactly the same as column C. In OO calc, when concatenated, it becomes '1234 N MainF456' (trailing spaces are deleted by OOcalc) ... Hold on! What do you mean by "trailing spaces are deleted"? Not in any version of Calc I have used! In any case, you make clear above that the contents of your column A do not contain trailing blanks. Concatenation won't invent blanks that were not there in the originals - but that's helpful, not a problem. ... so they never can be equal. If there is never a trailing blank in column A, you need to compare C1 with A1&" "&B1, not with A1&B1 (as has already been suggested). If the values in column A may have trailing blanks, you may need something like TRIM(A1)&" "&B1. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
