Apache OpenOffice Community Forum

I uninstalled Java from my computer mainly because of the security issues - see http://krebsonsecurity.com/2010/10/java ... ck-makers/ - but I also dislike a lot of other things about Java.

Although LibreOffice displayed an error dialog about JRE on first run, it subsequently did not display the dialog and seemed to work fine so I was happy. However, when I wanted to run macros there was a problem but rather than install Java I'm working around it.

I just wondered if the LibreOffice developers were committed to Java? Or would there be a time when it's phased out?

Of course you can not run Java macros anymore. Any other macro language simply works as expected. The error message when you call menu:Tools>Macros>Run is plain wrong. Use menu:Tools>Macros>Organize instead.

Thanks Villeroy, but I'm not running a java macro - it's one I recorded. I assigned the keyboard shortcut, Ctrl-Shift-0, to a macro I recorded that formats selected cells in calc to a number with no decimal places. But when I tried running the macro it did not work, and I assumed that this was because I have no JRE installed. Would that assumption be incorrect?

(By the way, I cannot use Styles and Shortcuts to Styles to achieve the formatting, because the documents I'm opening are CSV and this bypasses the default template, which means that the hours I've spent customising my styles are wasted in this situation – I don't see why CSV documents should ignore the default template. And I don't want to import the CSV sheets because that is more keystrokes than manually changing the cells to zero decimal places!)

"It did not work" is not a very diligent problem description. Your macros should run with or without macros. I can disable Java in LibreOffice which affects my Java databases and a few wizard tools and the obsolete Tools>Macro>Run dialog.

Regarding the csv problem, load your text into a text editor, select all and paste special into your template.

There are more convenient ways to load csv into Calc with prepared formulas, formatting, charts and preconfigured import settings: [Example] Loading CSV into preformatted spreadsheets