LibreOffice

492

Solutions

834

Contributors

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Experts,
This is a bit complicated question. I've got a table with english content which was composed originally on a probaly jewish environment using PowerPoint. I'm using Linux and the I opened the .pptx file in  LibreOffice Impress. Editing the text I got some strange phenomena.
The HOME is on the right, the END is on the left. The left arrow goes to the right and the right arrow goes to the left. The DEL deletes the right character.
My big problem is how appears the cell content.
Instead of the right "24 - 12 VDC" appears "VDC 24 - 12". As I press the END and the cursor is in the top left position, after clicking (without changing the position of the cursor) the cursor jumps behind the VDC  (right from char C) which the real end of the text is. The same happens when I click left from V.
After pressing END the cursor is blinking in the top left position in the row. As I drag the pressed mouse in the right direction the first selected character is the C.
Or start position is the the top left position in the row. 1x press on the right arrow the cursor jumps between D and C. One more press and goes between V and D. One more: jumps before 20 and one more: jumps behind 20.
When I am in  the the top left position in the row the DEL don't work but the BACKDEL (marked with left arrow) deletes the C.
When I delete the whole content and I write in the cell "24 - 12 VDC" the VDC jumps forward and appears "VDC 24 - 12".

Could somebody help me? Every answer appreciated.
0
What does it mean to be "Always On"?
LVL 4
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

I have a cell with the date and time.  However, when I open the sheet the next day all dates change to current date.  What I want to do is either have a timestamp entered in another cell D1 when the day and time in C1 is entered.   Or - have a formula that timestamps instead of one that adds date and time so when I scan RFID chip number in A1 it time stamps in D1.
0
Hi, I want to use this code in Libre Calc as a macro.  It is VB.  Is that possible?  How can I change it so that it works in Calc?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
   


Dim rCell As Range
    Dim rChange As Range
   
    On Error GoTo ErrHandler
    Set rChange = Intersect(Target, Range("A:A"))
    If Not rChange Is Nothing Then
        Application.EnableEvents = False
        For Each rCell In rChange
            If rCell > "" Then
                With rCell.Offset(0, 1)
                    .Value = Now
                    .NumberFormat = "hh:mm:ss"
                End With
            Else
                rCell.Offset(0, 1).Clear
            End If
        Next
    End If

ExitHandler:
    Set rCell = Nothing
    Set rChange = Nothing
    Application.EnableEvents = True
    Exit Sub
ErrHandler:
    MsgBox Err.Description
    Resume ExitHandler
End Sub
0
on a windows 10 PC - 64 bit; my client finds OFFICE too expensive while the stuent version is 149euro, and does NOT have Outlook - the home & Business that has outlook costs 269 Euro
i know i can install Open office, but it does not come with an outlook compatible progam

question : what softwares to choose for OFFICE and outlook
if possible - retain mail adress, and easy transfer of the existing pst file
0
I have exported Website data from Wordpress into a Linux LibreOffice  Calc file in CSV format (which cannot be opened with Calc), and then imported that CSV data  into the hosting database using PHP MyAdmin.  Is this a common method, and why is it downloading only 5 rows of data, when 7 rows appear on Wordpress Participants Database?
0
Could someone please help me with the following:

We have lots of vehicles and need to keep the "Road Tax Due Date" and "MOT Expiry Date" updated.

This information is available from the site https://www.vehicleenquiry.service.gov.uk/.

The parameters required are Vehicle Registration Number and Vehicle Make. These details are there in my excel worksheet.

How can I automate the updating of the "Road Tax due date" and the "MOT expiry date" to the respective vehicle in my excel list instead of manually browsing to the website, updating the form and copying and pasting the results to my excel sheet.

Automating this will save me a load of time and make it highly accurate.

Thanks
Alcuino
1
Hi,

I would like to know if ther is any formula to automatically assign the same correlative number to equal or repetitive codes.

For column  ORDEN is there any  formula to assing the same number to ORDEN for each equal Ordernumber as in this example?
That is ORDEN 1 for all repetied order 200001195
ORDEN 2 for all repeted order 200001198

ORDEN      Ordernumber
1      200001195
1      200001195
1      200001195
2      200001198
2      200001198
3      100005020
3      100005020
3      100005020
3      100005020

Thanks again
0
Hi,

I am trying to make a function (lookup or vlookup) in google drive calc that could search for a value on a column and if it find it return other value.
As in the test file atached  I would like to enter a value on J2 cell , to look for this value on range f2:f45 and if finded return the correspond value on range A2:A45.

Thank you !!
0
I have text from Word that I need to paste onto a PDF file, but I need the text upside down.

How do I do this?

Thanks
0
I am creating a flash card game with question on the front and the answer on the back of each card.

I want the text on the front to be larger, since it will contain less text than the back and it will need to be readable from across the table.

I need to fit as much as 100 characters, with spaces, centered on the outward face of the card.

What's a good font for this? I expect to use Black or dark blue on white to give a strong contrast.


On the backside, I may need as much as 275 characters, with spaces.

What's a good font for this? I will indeed use Black on white to give the strongest contrast ratio.


Thanks
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE
LVL 4
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Hi,
When running the macro below

Sub AA_Validate_Path_vgm()
    Dim Obj0 As Object, Source0 As Object, File0 As Variant, File1 As String, File2 As String, Pos0 As Integer, Pos1 As Integer, Pos2 As Integer, Pos3 As Integer, iFile As Integer, TextLine As String, Str0 As String, Command0 As String, FSO As Object, Path0 As String, Message0 As String
        
    Set FSO = CreateObject("scripting.filesystemobject")
    File0 = Dir("C:\cmp3g\CODECO_ERROR_0\*.*", 7)
    Do While (File0 <> "" And UCase(File0) <> "ERROR.TXT")
        'Debug.Print File0
        File1 = "C:\cmp3g\CODECO_ERROR_0\" & File0
        iFile = FreeFile
        Open File1 For Input As #iFile
        Do Until EOF(1)
            Line Input #1, TextLine
            
            If Trim(TextLine) <> "" Then
            Pos0 = InStr(TextLine, "UNOA")
            If (Pos0 > 0) Then
                Pos1 = InStr(Pos0 + 1, TextLine, "+")
                Pos2 = InStr(Pos1 + 1, TextLine, "+")
                Pos3 = InStr(Pos1 + 1, TextLine, ":")
                
                If Pos3 < Pos2 Then
                    Pos2 = Pos3
                End If
                
                Message0 = ""
                Str0 = Mid(TextLine, Pos1 + 1, Pos2 - 1 - Pos1)
                'Debug.Print Str0
                If Len(Str0) > 0 Then
                    'Path0 = "C:\cmp3g\CODECO_ERROR_0\" & Str0 & "\"
                    
                    'If FSO.FolderExists(Path0) = False Then
                        'Command0

Open in new window

0
Hi,
I'm using LibreOffice 5.1.2.2 x64 on Win 7 and get this
4p.pngwhen I'm to run macro. Which Java runtime should I setup? Where is the download?
0
Im using LibreOffice Calc.

I have two separate column of number sets.  I want to compare the two and come up with a 3rd column set of numbers from column A that don't have any of the sets of numbers in column B.

This is the answer i rec'd from one member of Experts Exchange.

In C1 type in formula: =IF(ISERROR(MATCH(A1;$B$1:$B$1000000;0))=1;A1;"") and copy formula down from C1 to wherever the last entry is in the B column so (C1-C31 for example).

The formula displays in column C the values that are in the list A and do not exists in list B.

But I cant seem to make it work.  Is it possible for you you to show me via a video tutorial or walk me through it so i know what i am doing?

Thanks,
Casey
0
Hi,
I set up

LibreOffice 5.1.2

successfully, on Windows 10 but then I can not find out the Windows option to access the application. Why?
0
I have a PDF and need to edit to URL pointed to by

1) embedded HyperLinks
2) Twitter icon with embedded Twitter tweet

Can I do this with LibreOffice?

If not, is there a free tool?

Is it time for me to get Adobe?

What's the cheapest way?

Thanks
0
I am creating a PDF from a Word doc using LibreOffice.

In the doc I need two types of links:
1) highlight text that points to a Web URL
2) highlight text that opens a pop-up of a few sentences of text, on hover

I assume #1 will translate fine from Word Hyperlink.

For #2, when I use Hyperlink > Screen Tip feature, I can successfully create a pop-up. BUT, I am required to use a hyperlink, which I do not want to do there.

Is there any way to have the pop-up without have a hyperlink? I do not want the hyperlink.

AND when I use LibreOffice the pop-up is lost.

So I have no way to create a pop-up in a PDF.

Can you tell me?


Thanks.
0
Hi all!
Today i try to do a silent installation of Libre Office 5.0.5
I downloaded a msi package and create a script

msiexec /i LibreOffice_5.0.5_Win_x86.msi ADDLOCAL=ALL ALLUSERS=1 CREATEDESKTOPLINK=1 INSTALLLOCATION="%programfiles%\Libre Office" RebootYesNo=YES  ISCHECKFORPRODUCTUPDATES=0 REGISTER_ALL_MSO_TYPES=1 REGISTER_NO_MSO_TYPES=0 VC_REDIST=1 QUICKSTART=1 UI_LANGS=it_IT

When lauch this string from cmd, it prompted to a gui installation.
I can't understand what i do wrong.
0
I am using LibreOffice 5.0 and trying to do something simple, but cannot figure it out. I am using the Draw Function. I've put 2 rectangles on the page and now want to connect them with a line. One L.O. help posting says to click on the glue point icon, but doesn't say where this icon is or what it looks like. I can't find it. Another post says to use the connector tool bar, but I see no such tool bar.

Need help.
0
Hi
 
One of my friend is going to give a E-Book for his students. He thought to give the E-Book as a PDF. I heard from Microsoft that DRM will give a good protection in this case. My friend needs to protect his E-Book from getting printed, coping or sharing the file.
 
My question is how safe is the Office 2016 DRM Protection? Are there better solutions?
 
Any answer is welcome.
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I have a column of about 1700 names of people in no particular order.  The formats of
them seem to be:
   1) john doe
   2) john c doe
   3) ohn c. doe
   4) john calvin doe

I would like them to be:
   1) john <space><space>doe
   2) john<space>c.<space>doe
   3) john<space>c.<space>doe
   4) john<space>calvin<space>doe

I'm trying to make this so it can be put into columns (first name), (middle name), and (last name) and then sorted.by ln, fn, mi to find the people.  It was an OLD set of burial books for a nearby cemetery that were handwritten and wearing out.  I'm trying to make them electronic or just print new ones.
0
I am in the process of posting my book on PDF, at first for free, for public distribution.

I have used LibreOffice to password protect PDF's.

Is there any value or risk to doing this?

It seems someone could copy to clipboard anyway. So, pw protection seems of limited value.

Is there a risk that someone might not be able to open the file?

That'd be my real worry.

Thanks.
0
I plan to write a 5.5" x 8.5" book with a perfect binding. I've been told by the printer not to waste my time using Word, due to frequent font incompatibilities, and instead use PDF. So please advise me how to go forward.

I have:
Word 2011 (Mac)
LibreOffice
Foxit Reader

What shall I use to generate the document? I need this before I write the book so I can estimate how many words in a page.

What font do I use? I prefer to be slightly larger than than used typically. I am not trying to save pages and if anything am trying to  make the book long enough for a perfect binding page count minimum. Also, as someone who needs reading glasses, wold prefer if elderly people cam read it easily.

I am not talking about making it like the Readers Digest with huge text is, but large enough that most people can read it.

So, what tool do I use? And how do I set the settings for a 5.5" x 8.5" book?

I also hope to create an index with an automated tool.

Possible?

Thanks
0
Is there a built-in way to do this?
If not, are there 3rd party programs to do this?
0
I'm using LibreOffice 4.2.8.2. I've opened a csv file. I want to sort. Data > Sort is grayed-out. Why?
0
I have bank statements I'd like to annotate before I give them to the accountant. How?

I have Word 2011 (for Mac) and LibreOffice (for Mac)

Will either work? Or there another?

Is the PDF locked?



Thanks.
0

LibreOffice

492

Solutions

834

Contributors

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

Top Experts In
LibreOffice
<
Monthly
>

No Top Experts for this time period. Answer questions to earn the title!