Search found 4801 matches
- Thu Apr 25, 2024 5:54 am
- Forum: Calc
- Topic: [Solved] Precision as shown
- Replies: 4
- Views: 283
Re: Precision as shown
The HELP says Precision as shown Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not marked, the displayed numbers are rounded, but they are calculated internally using the non...
- Wed Apr 24, 2024 1:28 am
- Forum: Macros and UNO API
- Topic: [Solved] Macro button to hide/unhide rows in Calc
- Replies: 7
- Views: 911
Re: Macro button to hide/unhide rows in Calc
Cross posted at AskLibreOffice
If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
Edit: Solved - see the AskLibreOffice link |
- Tue Apr 23, 2024 1:33 pm
- Forum: Writer
- Topic: Text produced using Writer does not display using Microsoft Word
- Replies: 5
- Views: 465
Re: Text produced using Writer does not display using Microsoft Word
If so, would someone please remind me how to download a copy of OOW Look at the bottom right of any page on this forum where it says "Get OpenOffice". Click on the OpenOffice logo beneath those words to go to the download page. Make sure to read the installation instructions that are link...
- Tue Apr 23, 2024 3:53 am
- Forum: Writer
- Topic: [Solved] Added image but see only "graphics1"
- Replies: 2
- Views: 254
Re: pasting an image
Presumably you are using Writer? Go to Tools | Options | OpenOffice Writer | View, check under Display and ensure that Graphics and Objects is selected (checked). For best handling of images, you might find [Tutorial] Some useful hints on using images a helpful resource. using 4.1.15 Openoffice 4.1....
- Sat Apr 20, 2024 6:40 am
- Forum: Macros and UNO API
- Topic: [Solved] Macro button to hide/unhide rows in Calc
- Replies: 7
- Views: 911
Re: a macro button for hide/unhide rows in calc
You may find Andrew Pitonyak's books on OO macros a useful resource.Can I find too little information?
- Fri Apr 19, 2024 12:35 am
- Forum: Calc
- Topic: [Solved] Set default font and size
- Replies: 5
- Views: 527
Re: Set default font and size
And of course remember to save as file type ODF Spreadsheet Template (.ots)
- Thu Apr 18, 2024 1:51 am
- Forum: Calc
- Topic: [Solved] No Windows menu; can't use Freeze
- Replies: 8
- Views: 605
Re: No windows button on taskbar - unable to freeze rows/columns
You haven't (inadvertently?) placed OpenOffice in full screen mode as mentioned in the link MrProgrammer provided above?
- Tue Apr 16, 2024 12:33 am
- Forum: Writer
- Topic: [Solved] Split large document into 2 ODT files
- Replies: 11
- Views: 1787
Re: Split large book file into 2 odt files
If you have anchored the images to page - which you should only do if you understand the consequences - you will have problems. If the images are anchored otherwise they should move with the text.
- Sun Apr 14, 2024 1:44 am
- Forum: MS Windows
- Topic: Program is Crashing
- Replies: 2
- Views: 447
Re: Program is Crashing
With that little information, it is hard to know what is going on.
Perhaps you might try LibreOffice.
Perhaps you might try LibreOffice.
- Sat Apr 13, 2024 8:14 am
- Forum: Calc
- Topic: [Solved] Filling down, from another sheet's across cells
- Replies: 6
- Views: 510
Re: Filling down, from another sheet's across cells
Please don't SHOUT, it is considered impolite.
Press F1 to open Help; search Transpose and see the process described.
Press F1 to open Help; search Transpose and see the process described.
- Sat Apr 13, 2024 6:18 am
- Forum: Calc
- Topic: [Solved] Filling down, from another sheet's across cells
- Replies: 6
- Views: 510
Re: Filling down, from another sheet's across cells
Is this what you want? Sheet1 is the source, Sheet2 is the transposed values.
Or this where Sheet2 is the source and Sheet1 is the transposed values.
Or this where Sheet2 is the source and Sheet1 is the transposed values.
- Fri Apr 12, 2024 10:36 am
- Forum: MS Windows
- Topic: Problems by Sending Email in OpenOffice
- Replies: 1
- Views: 264
Re: Problems by Sending Email in OpenOffice
Can you please update your signature to include details of your operating system?
- Wed Apr 10, 2024 1:20 pm
- Forum: Writer
- Topic: [Solved] Read-error. Format error discovered...
- Replies: 10
- Views: 1157
Re: Read-error. Format error discovered...
A (hopefully) repaired document has been sent to OP; the problem was the annotations bug with MS Office documents.
Edit: You might want to look at Using Styles and Templates [PDF] to make production of your document easier. |
- Tue Apr 09, 2024 11:06 am
- Forum: Writer
- Topic: [Solved] Read-error. Format error discovered...
- Replies: 10
- Views: 1157
Re: Read-error. Format error discovered...
I've sent you a PM* with contact details. The link of course only allows one to download a file that can't be opened without some degree of expertise; make of that what you will. And remember - you aren't paranoid if they are really out to get you
* PM -> Private Message
* PM -> Private Message
- Tue Apr 09, 2024 12:54 am
- Forum: Writer
- Topic: [Solved] Read-error. Format error discovered...
- Replies: 10
- Views: 1157
Re: Read-error. Format error discovered...
How to upload a file - with pictures to assist.
- Mon Apr 08, 2024 12:15 pm
- Forum: Writer
- Topic: Slide show Writer
- Replies: 9
- Views: 707
Re: slide show writer
Or use a recipe manager; why drive a screw with a hammer when a more suitable tool is available?
- Sun Apr 07, 2024 2:32 am
- Forum: Macros and UNO API
- Topic: [Solved] Automate Mail Merge and PDF creation
- Replies: 11
- Views: 1340
Re: OpenOffice Automation for MailMerge and PDF Creation
https://www.pitonyak.org/oo.php is a highly recommended source of information about OpenOffice macros.
- Wed Apr 03, 2024 8:14 am
- Forum: Calc
- Topic: [Solved] Evaluate math expression
- Replies: 4
- Views: 773
Re: Evaluate math expression
Cross posted on AskLibreOffice where some discussion has ensued.
If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
- Wed Apr 03, 2024 2:16 am
- Forum: MS Windows
- Topic: [Solved] What is the JRE location?
- Replies: 26
- Views: 2494
Re: JRE location
I can access the LibreOffice.org home page Strictly speaking, you are in fact opening the LibreOffice Start Centre on your computer. Using the terminology home page would confuse anyone trying to help you. I cannot see any way to create a LibreOffice Account, download any built in help, get any Lib...
- Wed Apr 03, 2024 12:30 am
- Forum: MS Windows
- Topic: [Solved] What is the JRE location?
- Replies: 26
- Views: 2494
Re: JRE location
You have perhaps downloaded LibreOffice from a nonofficial site and may have acquired some unexpected extra bonus with your download. You may wish to check your system for unwanted extras. https://www.libreoffice.org/download/download-libreoffice/ is the correct download site and doesn't involve any...
- Wed Apr 03, 2024 12:22 am
- Forum: Calc
- Topic: Determine last cell on sheet with value
- Replies: 7
- Views: 909
- Wed Apr 03, 2024 12:19 am
- Forum: Calc
- Topic: [Solved] Omit character - read rewrite - extract
- Replies: 4
- Views: 652
Re: [Solved] Omit character - read rewrite - extract
Also make sure to select Detect special numbers.
In addition [Tutorial] Text to Columns has instructions on elimination of the initial apostrophe which prevents values from being recognized as numbers/dates/times.
In addition [Tutorial] Text to Columns has instructions on elimination of the initial apostrophe which prevents values from being recognized as numbers/dates/times.
- Mon Apr 01, 2024 1:09 pm
- Forum: General Discussion
- Topic: Back to the Future Initiative
- Replies: 11
- Views: 1373
Re: Back to the Future Initiative
Spoilsport. You must be great fun at partiesForget it. It's all nonsense. Don't you get it
- Mon Apr 01, 2024 10:04 am
- Forum: General Discussion
- Topic: Back to the Future Initiative
- Replies: 11
- Views: 1373
Back to the Future Initiative
For those who may have missed the announcement elsewhere:
Dear All,
The Apache OpenOffice Development Team is proud to announce that the next releases will introduce an important change: a text-only user interface.
Read more:
https://openoffice.apache.org/blog/back ... ative.html
Dear All,
The Apache OpenOffice Development Team is proud to announce that the next releases will introduce an important change: a text-only user interface.
Read more:
https://openoffice.apache.org/blog/back ... ative.html
- Mon Apr 01, 2024 9:59 am
- Forum: Writer
- Topic: Getting back overwritten text
- Replies: 3
- Views: 564
Re: Getting back overwritten text
If you haven't closed the amended file, you could use repeated Ctrl+Z (Undo) to restore the file to previous states.
Otherwise, if you have enabled backup file using Tools | Options | Load/Save | General you could use that. Last resort [Tutorial] How to find and un-delete AOO/LO temporary files
Otherwise, if you have enabled backup file using Tools | Options | Load/Save | General you could use that. Last resort [Tutorial] How to find and un-delete AOO/LO temporary files
- Mon Apr 01, 2024 2:46 am
- Forum: MS Windows
- Topic: Delay opening documents
- Replies: 3
- Views: 626
Re: Delay opening documents
It may also be possible that OpenOffice is looking for a defined printer that is offline. Try changing the setting for the 'Load printer settings with the document' option under Tools| Options| Load/Save| General.
- Sun Mar 31, 2024 11:37 pm
- Forum: Calc
- Topic: [Solved] Cannot change font color
- Replies: 4
- Views: 895
Re: [Solved] Cannot change font color
It is off by default at installation; but perhaps someone has accidentally turned it on via keyboard shortcut Ctrl+F8.
- Fri Mar 29, 2024 8:18 am
- Forum: Calc
- Topic: [Solved] Calculation with date yields #VALUE!
- Replies: 10
- Views: 1274
Re: Subtracting one day from a date yields #VALUE!
There is a little trap with UTC +9:30 - Alice Springs and the whole Northern Territory, together with all of South Australia share the same time zone; however only South Australia observes daylight saving time.
- Thu Mar 28, 2024 12:50 am
- Forum: Draw
- Topic: [Solved] Can export resolution be changed?
- Replies: 6
- Views: 1882
Re: Exporting options - can it be changed?
No - the numbers refer to the amount of compression of the image, from 0, none to 9, maximum amount. Obviously the more the file is compressed, the smaller it will be.2) my Q above is "are the words 'smallest' and 'largest' in the incorrect places? should they be reversed?
- Wed Mar 27, 2024 11:20 am
- Forum: Writer
- Topic: Limited space in each document one create?
- Replies: 13
- Views: 1330
Re: Limited space in each document one create?
In computing a k is taken to be 1024 characters Unless you happen to be buying something; manufacturers seem to round the kilobyte and other sizes down. For instance, this from the Kingston website about USB drives: Megabyte (MB) = 1,000,000 bytes; 1 Gigabyte (GB) = 1,000,000,000 bytes; 1 Terabyte ...