Re: [users] Re: Removing line breaks in Open Office writer, etc.
On 18/11/2010 07:14, Brian Barker wrote: You will recall the problem: to take material pasted into Writer which appears as short lines, each of which is actually a separate paragraph, and to merge these into a single paragraph. Indeed. I have a related problem - verse pasted from a non-OOo source I find usually has line ends marked as paragraph breaks. These should really be changed to the equivalent of shift-return so each verse counts as a single paragraph for formatting purposes, while 'end of paragraph' should correspond to end of verse. At present I go through the hard way with 'delete'. Tedious. The problem always being that each time this crops up, it's quicker to do it the hard way rather than hunt for a better method ready for next time. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Calc: How to see list of sheets
Hi, In Excel 2K3, you can right-click on the sheet navigation arrows and have a list of all the sheets in the current workbook, so you can click on the one you need and go there directly. It makes it easier to navigate from one sheet to the other. What's the equivalent in Calc? Thanks, L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker in you! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: How to see list of sheets
Hi try the navigator press F5 key HTH Laurent - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Filters - mistake in wiki documentation?
Can someone please confirm if this is correct: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Filters After applying a filter, some rows are visible and some rows are not. If you select multiple rows in one operation, you will also select the invisible rows contained between the selected visible rows. Operations, such as delete, act on all of the selected rows. To avoid this problem, you must individually select each of the filtered rows using the control key. That does not match my experience, but I'm running Go-oo on this machine rather than OOo, is this a difference in behaviour between these two versions? My copy is deleting only the visible filtered rows and values. 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
[users] Re: Calc: How to see list of sheets
On Thu, 18 Nov 2010 14:24:31 +0100, Laurent Godard wrote: Hi try the navigator press F5 key HTH Laurent D'oh! Yes, I'd never thought of using it in Calc. Thanks, L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker in you! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Help with form input
I have need to construct a database-type form (it needn't BE in Base - Calc would do) such that when a future date is inserted in a particular field, it generates a calendar reminder (say) 10 days before the date in the field. I suspect that that may be relatively easy using something like Sunbird, but here's the sting. The person for whom I need to make this form uses Outlook, purely because of synching everything with her mobile phone. As I am not a programmer by any sort of imagination, I wonder what sort of things would be able to do this. (An email reminder would be OK rather than an actual Calendar reminder). Hope someone might be able to help. If anyone wants info off-list then feel free to email me at gordonATmid-churnetparishesDOTorgDOTuk Many thanks - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: How to see list of sheets
Dear Laurent:
I create this easily on a regular basis in Calc, However it is not just
1 click.
I add an extra sheet at the beginning (leftmost tab) then add hyperlinks
to each of the sheets in Column B or C. Column A is a sequence number
(or a priority number) so that I can sort by arbitrary criteria.
With this I can jump to any sheet in a {ctrl-click}. This sheet can also
use added columns for items such as a total from each of the other
sheets if these sheets are, say accounts. Since the accounts can be
part of an ongoing inventory reconciliation, Their end results can be
in Lbs., Kg. Litres, Gallons, etc or the calculated value of the current
stock level for each, also taking account of value from different
currencies, Metric/English conversions,
Averaged unit value across multiple purchases of the same stock item,
differences in taxable status, etc. One of these applications I did was
for an industrial inventory of powdered pigments that were subject to
daily ins and outs, U.S. and Canadian currency, Metric and English
Purchasing units, and other freight -in costs.
This one was also used to do pre-production reservation of stock, so
that nobody could end up using stock that was earmarked for another
production batch.
This application later served in another application where liquids were
involved, and conversion to weight was needed.
Another such large workbook application was a sales tracker for a car
dealership. The dealership had 20 regular salesmen, each of which could
sell up to 100 cars a month. Added to that was the fleet salesman, who
could sell double that, as he was selling fleets typically to car rental
companies.
The workbook was about 25 sheets wide. 1 sheet for each salesman,
another for the fleet salesman (total 21 sheets so far), then there were
2 summary sheets at the beginning.
The sales department secretary entered all the sales data throughout the
month, as each vehicle or fleet was sold, along with the model name,
edition code for the model sold, length of the lease, profit figure for
the sale, etc.
At the end of the month, the 2 summary sheets were sorted and printed.
Each of these sheets were about 1800 lines deep, and the formulate in
most of the cells ran right off the edit line, they were so long.
When the sheets were printed, each one only printed as many lines as
there were records active, not the whole 1800 lines.
The first of these print-out takeoffs went to the sales manager so he
had a fast summary of what his sales staff were doing.
The second went to the general manager, who, as far as I know used this
to decide what cars he would order from the manufacturer for the next
business cycle. since he was financially committed to the cost of those
vehicles from the time they left the manufacturer, this made for a big
financial responsibility.
In this case, as we see, the application was serving 2 diverse sets of
needs at the same time.
My fee at the time to do that was about $CDN 365.00, although today it
would be somewhat higher.
I also have another application which related to an industry whose
production is based on a recipe by weight which may also have ongoing
experimental changes in the batch. Usually in this type of production,
the recipe is predicated on a specific final batch weight which is based
on the capacity of the mixing machinery used. When a client places an
order for a much larger quantity, another part of the workbook
calculates the total weight of each product needed for the whole order,
which then becomes the pre-reservation in the inventory as previously
mentioned.
At the point where this transition happens, any stock shortages
resulting from the calculation of the bill of materials for the client
order are then passed to the purchasing agent who obtains the added
stock needs.
The purchasing agent, on advice from the marketing dept. and with
financial executive approval, may increase the order to provide for
expected demand, possibly getting a better price in the process due to
his larger order.
Best Regard$$$
On 11/18/2010 08:22, L Duperval wrote:
Hi,
In Excel 2K3, you can right-click on the sheet navigation arrows and have
a list of all the sheets in the current workbook, so you can click on the
one you need and go there directly. It makes it easier to navigate from
one sheet to the other.
What's the equivalent in Calc?
Thanks,
L
--
Best Regards, Bruce Martin
Re: [users] Calc: How to see list of sheets
Den 2010-11-18 14:22:19 skrev L Duperval lduper...@yahoo.com: Hi, In Excel 2K3 Very OT: 2K3? In my world that means 2300 (except that the ”k” shouldn't be capitalised…), like 2k3 Ω means 2,3 kΩ and so on. Well, have a nice day. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] JPG format
Hi, I have downloaded openoffice and now using it, 2 questions pls 1-in the spreadsheet printing I can not see options as those are in the MS office such as print area,page layout ,. 2-How can I change ods and XL format to JPG. thanks for your advice
[users] Cross references in an index?
Using OOo 3.2.1 on Fedora 13, x86_64. I am trying to learn how to generate an index. I've pretty much figured out how to create index entries, but what if I want to create an index entry that just says See or See also followed by another index entry? For some reason the GUI confuses the heck out of me. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] JPG format
On Thu Nov 18 2010 09:34:14 GMT-0800 (PST) mansoor wrote: Hi, I have downloaded openoffice and now using it, 2 questions pls 1-in the spreadsheet printing I can not see options as those are in the MS office such as print area,page layout ,. Most of the settings that deal with page layout is found under Format Page, as it has to do with page styles. For printing parts of a sheet Format Print Ranges can be used. 2-How can I change ods and XL format to JPG. thanks for your advice Not quite sure what you looking for here but I see no way to save as or export images from Calc. That being said charts and data can be copy and pasted into either Draw, and saved as JPGs or into Impress to use as a slide show. HTH Andy -- Note: you have been cc'd on this reply as you have posted to an open OpenOffice.org (OOo) mailng list. For further information regarding OOo, please see: http://www.openoffice.org/mail_list.html Please reply *only* to the list at users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Removing line breaks in Open Office writer, etc.
See also that topic, there is a link to a nice macro: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=2585 Hagar Le jeu. 18 nov. 2010 08:08:21 CET, Mike Scott m...@scottsonline.org.uk a écrit : On 18/11/2010 07:14, Brian Barker wrote: You will recall the problem: to take material pasted into Writer which appears as short lines, each of which is actually a separate paragraph, and to merge these into a single paragraph. Indeed. I have a related problem - verse pasted from a non-OOo source I find usually has line ends marked as paragraph breaks. These should really be changed to the equivalent of shift-return so each verse counts as a single paragraph for formatting purposes, while 'end of paragraph' should correspond to end of verse. At present I go through the hard way with 'delete'. Tedious. The problem always being that each time this crops up, it's quicker to do it the hard way rather than hunt for a better method ready for next time. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] JPG format
On 18/11/2010 19:28, RA Brown wrote: 2-How can I change ods and XL format to JPG. thanks for your advice Not quite sure what you looking for here but I see no way to save as or export images from Calc. That being said charts and data can be copy and pasted into either Draw, and saved as JPGs or into Impress to use as a slide show. Or check out the recent thread on this subject. PDFCreator is one option accessible from all(??) windows apps to print to a jpeg image (or indeed to many other formats). Or export to pdf and use ghostscript to convert. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Removing line breaks in Open Office writer, etc.
On 18/11/2010 19:45, Hagar de l'Est wrote: See also that topic, there is a link to a nice macro: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=2585 Thanks for the reference. Looks long - I'll take a proper look later. -- Mike Scott Harlow, Essex, England - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Removing line breaks in Open Office writer, etc.
Mike Scott wrote: On 18/11/2010 07:14, Brian Barker wrote: You will recall the problem: to take material pasted into Writer which appears as short lines, each of which is actually a separate paragraph, and to merge these into a single paragraph. Indeed. I have a related problem - verse pasted from a non-OOo source I find usually has line ends marked as paragraph breaks. These should really be changed to the equivalent of shift-return so each verse counts as a single paragraph for formatting purposes, while 'end of paragraph' should correspond to end of verse. At present I go through the hard way with 'delete'. Tedious. The problem always being that each time this crops up, it's quicker to do it the hard way rather than hunt for a better method ready for next time. I've encountered this situation twice in the last couple of days, when taking text that someone submitted to me for a newsletter, and putting it into newsletter form. A search on Help for the term Removing line breaks did the trick. Here is the process (from Help): --- Use the AutoCorrect feature to remove line breaks that occur within sentences. Unwanted line breaks can occur when you copy text from another source and paste it into a text document. This AutoCorrect feature only works on text that is formatted with the Default paragraph style. 1.Choose Tools - AutoCorrect Options . 2.On the Options tab, ensure that Combine single line paragraphs if length greater than 50% is selected. To change the minimum percentage for the line length, double-click the option in the list, and then enter a new percentage. 3.Click OK. 4.Select the text containing the line breaks that you want to remove. 5.In the Apply Style box on the Formatting bar, choose Default. 6.Choose Format - AutoCorrect - Apply. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Calc: How to see list of sheets
On Thu, 18 Nov 2010 16:45:23 +0100, Johnny Rosenberg wrote: Very OT: 2K3? In my world that means 2300 (except that the ”k” shouldn't be capitalised…), like 2k3 Ω means 2,3 kΩ and so on. Well, have a nice day. Well, you learn something new every day. ;) L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker in you! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Filters - mistake in wiki documentation?
At 13:32 18/11/2010 +, Phil Hibbs wrote: Can someone please confirm if this is correct: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Filters After applying a filter, some rows are visible and some rows are not. If you select multiple rows in one operation, you will also select the invisible rows contained between the selected visible rows. Operations, such as delete, act on all of the selected rows. To avoid this problem, you must individually select each of the filtered rows using the control key. That does not match my experience, but I'm running Go-oo on this machine rather than OOo, is this a difference in behaviour between these two versions? My copy is deleting only the visible filtered rows and values. The help text in my OpenOffice 3.1.1 for Windows XP says When you select multiple rows from an area where a filter was applied, then this selection can include rows that are visible and rows that are hidden by the filter. If you then apply formatting, or delete the selected rows, this action then applies only to the visible rows. The hidden rows are not affected. This is the opposite to rows that you have hidden manually by the Format - Rows - Hide Rows command. Manually hidden rows are deleted when you delete a selection that contains them. This contradicts the web site version you quote. And yes: my version (like yours) seems to follow the help text's claims, not the web site's. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Re: Writer problem
On Wed, 17 Nov 2010 16:17:43 +, Harold Fuchs wrote: Page1 is in a section on its own so it can have its own page characteristics - size, orientation etc. It has my sender info in the place (and tiny font) I prefer and an empty text box into which I paste the name address of the addressee That's a neat idea! When I come to print, I print pages 2 and onwards for the letter In my case, I have two different templates for envelopes, A4 and small, and so would not want to have always the same size at the front of every document. -- /\/\aurice - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] JPG format
Dear Mansoor: Why you want to export a spreadsheet to a bitmap format is puzzling, however... There are many ways to skin a cat: In Windows, you could print it to a number of different apps that accept input as a virtual printer driver. This includes .PDF Creator and However, you will then need Photoshop elements ($$$) to rasterise. When you do this, you will have to load your .PDF once for each page you need to rasterise, then choose the Bitmap mode and resolution. This allows you to control the resolution of the imported file, but if the imported data size is big, this can be quite long and processor demanding. Unfortunately, Gimp does not load .PDF files, although the .PDF Creator printer driver may, depending on the version and the advanced settings, may also export as a Postscript or other format which Gimp can import for further graphic editing. I do not remember this being the case with the Oo .PDF export app, however it may also be possible. Another route would be to paste the sheet as a table in Draw, then convert and export, however that is apt to render a very poor resolution, unless you can find the add-on that allows you to control the bitmap conversion routine's export resolution. In Linux (Fedora 12-14) you have this facility more built into the Operating system. Are you now bitten by the bitmap idea! (Guffaw) Cheers, Bruce Martin On 18/11/2010 12:34, mansoor wrote: Hi, I have downloaded openoffice and now using it, 2 questions pls 1-in the spreadsheet printing I can not see options as those are in the MS office such as print area,page layout ,. 2-How can I change ods and XL format to JPG. thanks for your advice
[users] Re: JPG format
Bruce Martin wrote, Dear Mansoor: Why you want to export a spreadsheet to a bitmap format is puzzling, however... There are many ways to skin a cat: In Windows, you could print it to a number of different apps that accept input as a virtual printer driver. This includes .PDF Creator and PDFCreator can save as non-PDF. Options|Save|Standard save format: PDF/PNG/JPEG etc. However, you will then need Photoshop elements ($$$) to rasterise. When you do this, you will have to load your .PDF once for each page you need to rasterise, then choose the Bitmap mode and resolution. Or GIMP... [..] Unfortunately, Gimp does not load .PDF files, It can, if ghostscript is installed and if the environment variable GS_PROG points to the ghostscript directory, eg. C:\gs\gs8.71\bin (for Windows). -- Bob Long - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
