Software Update: LibreOffice 5.0.0 Beta 3 – Tweakers

The Document Foundation has the third beta release of version 5.0 of LibreOffice released. This open source office suite was created as spin-off from OpenOffice and comes with Writer word processor, spreadsheet program, Calc, presentation program, Impress, drawing Draw, database program Base and Formula, an application to join scientific notations.

New in version 5.0, includes a 64bit version for Windows and toolbars get new buds coming out of KDE. Detailed information on the changes in version 5.0.0, which if all goes well the end of July will become available, can be found on this page. These are the main ones in Writer, Calc, Impress, and Draw are made:

 

Writer

  Word-compatible text highlighting
 

• Both highlighting and shading are preserved constantly import / export or Microsoft Word documents. tdf # 64490

 

• New compatibility option to Specify how to export LibreOffice character background to Microsoft Office file formats: as highlighting or shading axis. tdf # 64490

 

• To use this option, go to Tools & gt; Option & gt; Load / Save & gt; Microsoft Office .

 
• For more information see this blog post

 

Crop an image
It is now possible to crop an image with the mouse. Action is accessible through contextual menu entry: Crop image, Format & gt; Image & gt; Crop menu entry and Graphic toolbar. tdf # 34555 Standard behavior apply:
 

• dragging from a center edge crops only vertically or horizontally,

 

• dragging from a corner crops is where the mouse cursor,

 

• dragging with Shift forces pressed a crop rectangle proportional to original image size.

 
• crop is preserved constantly image resizing,

 

• crop mode stops When you press Esc or you click anywhere outside the cropped image.

 

Better calculation or displayed page number
Another issue inherited from OpenOffice.org-which Caused Writer’s status bar to display the incorrect page number When scrolling-has leg fixed in LibreOffice. Writer will now update the page indicator When less than the 43% of a page is visible on-screen. tdf # i # 90150 80672

Table Management
 

• Inserting rows or columns is affectedness by a user’s pre-selection, similar to Calc. tdf # 90883

 

• Ability to add rows and columns before the current cursor position through the context menu. tdf # 90882

 

Toolbar improvements Additional improvements have gone into the “Standard”, “Formatting,” “Drawing” and contextual toolbars to providence users with frequently used commands. tdf # 81475

Calc

 

• Item labels in PivotTables can be repeated now. tdf # 87972, Screenshot

 

• The functions CEILING.MATH and ERROR.TYPE have been added.

 

Conditional formatting
 

• UI for Data bars with a solid background. (Feature without UI HAS BEEN available since 3.6) tdf # 87356

 

• UI for Data bars without showing Their under-lying values. (Feature without UI HAS BEEN available since 3.6) tdf # 89199

 

• Minimum and maximum bar lengths for data bars tdf # 90197

 

• Export or formatting for conditional formatting to XLSX fixed.

 
• Import or Data bars and Color Scales handles color values ​​theme colors. tdf # 90511

 

• Import and export of custom icon set definitions (including MSO extensions to OOXML) (no UI)

 

• Additional icon sets: 3 triangles, 3 stars, 5 boxes

 

Scientific Format and Number Format
 

• Engineering notation: tdf # 30716
   
  • enable exponent multiple of 3 (or other value) format with ## 0.00E + 00 : set the number of digits ( # or 0 ) before decimal separator.

   

  • Format add ## 0.00E + 00 to scientific format list in UI dialog
    Format & gt; Cells & gt; Numbers & gt; Scientific for all localizations.
  
   
  • replace Thousands separator checkbox with Engineering notation for scientific formats. tdf # 90258

   

 

• General format using scientific, scientific and default format, keep minimum two digits (INSTEAD OF 3) exponent for all localizations. tdf # 88835

 

• Trend line equation with one digit in minimum exponent (INSTEAD OF 3). tdf # 88835

 

• Add / remove decimal digits or scientific format:
   
  • with buttons Add Decimal Place / Delete Decimal Place tdf # 88 960;
   
  • with Sidebar: Properties & gt; Number Format & gt; Decimal places tdf # 88999;

   

  • UI dialog with Format & gt; Cells & gt; Numbers & gt; Decimal places . tdf # 88999

   

 

• Allow variable with decimal format 0.0 E + ## 00 for scientific numbers and 0.0 ## for numbers (decimal part can contain some 0 and then some # ). This format is now set correctly saved in ODF files. tdf # 90133

 

• Sign of exponent can be skipped for positive exponent with format 0.00E00 (remove sign after E ). This format is now set correctly saved in ODF files. tdf # 90133

 

Table structured references
 

• Table structured references in a spreadsheet formula expressions are imported from Excel OOXML spreadsheet documents.

 
• Usable with defined database ranges, OOXML tables-which are imported to.

 
• Note That the structured references are not written to documents saved yet, but transformed, to A1 style reference notation instead. The table context is lost on exports.

 

Crop, change and save an image
 

• It is now possible from Format & gt; Image menu, from contextual menu and from graphic toolbar to Crop an Image with the mouse, to Save an image and to Change it by another image from disk.

 
• These functionalities behave like in Impress or Writer.

 
• Format menu HAS BEEN updated accordingly: there is now
   
  • Format & gt; Object entry with Position and Size, Line, Area, Define Text Attributes and Points

   

  • Format & gt; Image entry with Crop, Edit with External Tool Change Image, Compress Image, Save Image.
  
   

 

Impress and Draw

 

• Rear Rangement or toolbars in Impress tdf # 87 676

 

• Rear Rangement or toolbars in Draw tdf # 90090

 

• Area fill dropdown is now Implemented in the color selector in Impress and Draw. Blog entry