Ask Your Question

Mike Kaganski's profile - activity

2017-03-24 19:25:00 +0100 answered a question Where are the Entity Relations shapes and arrowheads in Draw?

They should be available as line property, where you can specify start and end style.

2017-03-24 19:18:22 +0100 answered a question Keyboard Freezes Constantly

Nothing in LO is able to break an OS function such that restart wouldn't help. I'd suppose you have a sort of hardware problem (e.g. USB controller hanging after some time, and requires cold start to reinitialize), but that's not a fault of software.

2017-03-24 17:20:02 +0100 answered a question Attach macro to a file?

Well, LO keyboard bindings aren't document-specific.

That means that the task would require also a document's macro that is autoexecuted on the document load, and that would change user's keyboard bindings. To keep things clean, it would also need another macro to clean up when the document is closed, and even when another document is brought to front. (Not to say that it's interesting what would happen when an app crash happens that prevents such cleanup).

And, of course, that would mean another possible target for malicious macros.

But for your first part of question - yes, it's possible to attach a macro to a file, and save it inside a document's module. To do that, you navigate to the document when create the macro, and create new module inside it.

2017-03-24 17:05:12 +0100 commented answer How do I get rid of the label "Formatted by......." in documents

@pierre-yves samyn: sorry, I didn't know about that. I'd surely redirected then.

2017-03-24 16:46:36 +0100 answered a question How do I make Ariel my default font?

If you are talking about Math (which is suggested by the math tag of your question), then use Format->Fonts to define your preferred font settings, and press Default button there.

If that's Writer, then use Tools->Options->LibreOffice Writer->Basic Fonts to define default fonts for new documents, or create a template with font settings and make it default.

(Ariel must be a beautiful font btw :) )

2017-03-24 12:46:49 +0100 answered a question How do I get rid of the label "Formatted by......." in documents

That is Track changes mode. You may disable it using Edit->Track Changes->Record. You will need to accept currently gathered changes using Edit->Track Changes->Manage.

2017-03-24 12:41:41 +0100 commented question What are the [working] STEPS to UPDATE?

Here you go again. No background (e.g., OS - only looking into your other (likewise badly asked) questions gives a hint it's Windows), a cypher instead of normally written words, no sign of respect to those who are willing to answer. I hope this (and other likewise bad) questions of you won't be answered until you learn how to ask questions the smart way.

2017-03-24 12:22:15 +0100 answered a question I am converting a keynote file to pdf using convert command. But the background themes of keynotes are not converting into pdf. Please find a solution for this

I tried to convert it to PDF using Zamzar, and it did show what I suppose you expect there to be:

image description

so the image must be inside. However, LO import shows only text without background (also, font is different, but that could be absence of the font on my system):

image description

So, I suppose it to be LO import limitation, that is known to be a basic one (see Release notes for 4.2 and 5.0 for some information).

What puzzles me is that you say about problem being with command-line conversion. Did you check if LO imports your file at all with LO UI itself, before using a command line to convert?

2017-03-24 11:41:54 +0100 commented question I am converting a keynote file to pdf using convert command. But the background themes of keynotes are not converting into pdf. Please find a solution for this

Hm. Actually, I don't see the brown background. I see brown text on first slide, but all 10 slides are white pages with text, no background.

Could it be an image linked to the file, that's absent on my system? I remember seeing something about external references that aren't processed when doing conversion using command line.

2017-03-24 11:23:55 +0100 answered a question Exporting imported bitmap images from calc?

You may open the ods as a ZIP archive and look inside Pictures subfolder.

2017-03-24 11:21:11 +0100 commented question Rotating text vertically doesn't work on windows 10

That could be a version issue (5.3), not OS problem. Hard to say without a test document to check.

2017-03-24 10:46:55 +0100 commented question I am converting a keynote file to pdf using convert command. But the background themes of keynotes are not converting into pdf. Please find a solution for this

Well, you could use a file sharing service and post a link here. However, I upped your karma.

edit: cannot increase it, because you made your question "wiki" for unclear reason.

2017-03-24 10:01:16 +0100 answered a question How do I make text start in the first column of a double-column layout?

What is the text direction in the Columns dialog? If it's Right to Left, or it's Use superordinate object settings and you otherwise use RtL layout, then this will happen.

2017-03-24 09:31:25 +0100 commented question I am converting a keynote file to pdf using convert command. But the background themes of keynotes are not converting into pdf. Please find a solution for this

Could you provide a sample to test?

2017-03-24 07:59:36 +0100 answered a question software adding unwanted code automatically

You didn't tell which version did you use previously (before installed 5.2.6).

There are four (closed long ago) issues in Bugzilla that mention ISODD_ADD, one of them being exactly your problem, however the reporter didn't provide sufficient data, so the issue was closed invalid.

Wrt automatically added sheet references, could that be this issue? See also tdf#96591 and its last comment.

2017-03-24 07:35:33 +0100 answered a question Is it possible to define an arbitrary string indicative of text overflow in a Calc cell?

No, there's no such setting in Calc.

2017-03-24 06:58:55 +0100 answered a question When attchng file, to Ques; what is "must be 3 pts."?

I'm positive that this kind of asking is inappropriate. That's why my first answer (deleted) was so "offensive".

The asker that constructed the question to look like

When attchng file, to Ques; what is "must be 3 pts."?

doesn't show any sign of respect to those who the question is addressed to, who may want to help. The question must be deciphered, both in language (missed letters that make words look like puzzles), and in data (answerer must guess that attachment is being made to this site's question, not to Calc that is mentioned as keyword; must reconstruct the full context that is the full message text - not only last (jammed) words of it).

A proper question would look like "When I try to attach a file to a question on this site, I get an error message saying "To attach files, you must have at least 3 points karma". What does it mean? What do I need to do to be able to create attachments?". In current form, I believe that the question does not deserve to be answered, though @peterwt was kind enough to bother about it.

2017-03-23 17:14:42 +0100 commented answer Under Options, there is no "Colors" tab. How do I add a custom color?

@ke: yes, you're right; feel free to file an issue at Bugzilla.

2017-03-23 14:25:48 +0100 answered a question Cannot insert a word

This is Overwrite mode, that is toggled by INS key on keyboard, or clicking in special area in LO status bar.

2017-03-23 13:18:52 +0100 answered a question When attchng file, to Ques; what is "must be 3 pts."?


2017-03-23 09:58:23 +0100 answered a question Change entire line background doesn't work

.csv is a text-only format, that is incapable of storing any formatting, only data (and even that only in a limited way). Use a different format (preferably ODS, as it's the native for Calc) if you need this functionality.

2017-03-23 09:48:47 +0100 answered a question Odd behaviour in LibreOffice Calc SUM function
2017-03-23 05:49:34 +0100 answered a question Column line wrapping

OP wants that each row (consisting of 66 cells) be output as a "string" of those 66 cells which (line) is wrapped by breaking between cells (yes, there's also arithmetic error like 66 = 6x10). This is impossible using LO Calc, unless you somehow restructure the cells to actually consist of say 10 columns, e.g. by a macro creating a new sheet with output formatted for print.

2017-03-22 21:02:05 +0100 commented answer Office URI schemes support: "ms-access:" and "vnd.libreoffice.command:"?

Feel free to ask. This feature is actually very simple.

2017-03-22 12:55:18 +0100 answered a question requires elevation

@Rogerbee seems to have had the same issue here, and then continued at MS support site, where seems to had found a solution:

I think I've cracked it! When you had Libre Office installed in Windows 7, did you have the program set to 'Run As Administrator!? I did and didn't change anything when I upgraded to Windows 10.

I upgraded again earlier and then I went to the .exe for Writer and told it not to 'Run As Administrator', I then did likewise for the shortcut and I can now open files just like I used to.


2017-03-22 08:29:25 +0100 answered a question Delete my account on this site

I am sure that your frustration caused by some strange accident with your previous question is not sensible. I do agree with @EasyTrieve that it's some failure. If you look at the questions, there are plenty of closed questions and answers (and among them, many of those that even don't have any sense, unlike yours!), and they aren't removed.

I don't know if some admin will take an effort to remove your account. I am unsure if terms of use make any promise that your account can be removed. However, if you are absolutely sure that an accident means to you more than words of those who try to help you here, then you may just make your account defunct, by e.g. changing email to something that won't send messages to you. Still I advise you to reconsider.

2017-03-22 08:18:36 +0100 commented answer Why can't I edit the Typography toolbar's macro?

Given that you installed the extension per user, I am unsure whether it applies.

I saw your OS from your bug report, so I was aware of it when wrote my answer. I am sure that the link I gave is applicable to any OS with multi-user support.

However, I have no experience with MacOS, so there could be additional factors to consider. It could even happen that on MacOS, not only all users' extensions, but also personal extensions are affected.

2017-03-22 06:55:30 +0100 answered a question How can I find and replace data with mask data in calc? ie Phone number masking last 4 digits.

I'd use regular expressions and replacer in columns (selection only).

For last name, I'd search for (\b[[:alpha:]]x*)[^x ]([^ ]*)$ and replaced with $1x$2 until no more occurrences are found in the column. (This replaces one character in last name with x each time.)

For phone numbers, I'd use ([[:digit:]]{3}-[[:digit:]]{3}-)[[:digit:]]{4} and replaced with $1xxxx.

Addresses: ^(.{9}).*$ -> $1...

Emails: ^(..).*(.@.{6}).*$ -> $1...$2... (this ignores the count of characters in email, just replaces any count of characters with ellipsis).

Websites: ^(.{8}).*$ -> $1...

And, of course, check the data manually afterwards, to make sure that everything is as you need. No advise here has any kind of guarantee, so using anything is your own risk. No responsibility taken.

2017-03-22 06:34:36 +0100 answered a question Update to 5.2.6?

The downloaded file is the main LO installer. There's no differential updater (yet) for LO on Windows (assuming you're on Windows, of course; you didn't tell that).

The updater will correctly detect and uninstall previous version itself, so you don't need to uninstall it first. Moreover, if you uninstall it first, then you will need to manually select components of your choice on installation, something that is handled automatically on upgrading over existing installation (when it updates all installed components).

2017-03-22 05:31:40 +0100 answered a question Why can't I edit the Typography toolbar's macro?

I suppose you've installed the extension for all users? It seems that in this case, you need to use an external editor to edit the macro.

2017-03-22 04:57:59 +0100 answered a question Office URI schemes support: "ms-access:" and "vnd.libreoffice.command:"?

LibreOffice uses its usual type detection mechanism when parses an office URI. So, no special provisions are made to ensure the ms-access URI is open in Base. This might be reconsidered later.

vnd stands for vendor, this naming scheme was already used somewhere in LO when introduced some custom extension to some standards to ensure uniqueness and avoid ambiguity, so I was advised to stick to the convention. It "works" just like other Office URIs: asks LO to open inner URI, with additional arguments like "read-only"/"edit"/"new from template", so you can craft a hyperlink on your web page, and have means to tell LO how to treat it.

2017-03-21 20:17:50 +0100 answered a question Starting where I left off

You need to fill user details in Tools->Options->LibreOffice->User Data. The last working position is user-specific, so it doesn't work without user information.

2017-03-21 17:56:27 +0100 commented answer Where can i find a list of property names that are supported for each UNO DispatchCommand URL?
2017-03-21 15:21:06 +0100 commented answer LibreOffice keeps crashing. report says EXCEPTION_ACCESS_VIOLATION_READ .
2017-03-21 13:53:32 +0100 commented question Opening .rtf

As I mentioned, I've newer met such problem; so I cannot tell if it's fixed. I personally suspect either OS association problem, or a corrupted profile. But who knows. A file to test would possibly help.

2017-03-21 12:38:29 +0100 answered a question Writer not searching inside text boxes

This is because of this commit. From the bug report that is addressed by this commit, it's clear, that the ability to search in text boxes was introduced between 5.1.3 and 5.1.4, and removed since 5.2.1.

2017-03-21 11:42:13 +0100 commented question Opening .rtf

Never met such a problem. It's difficult to say anything without seeing a test document which opens as you describe, without details about your OS and LO versions.

2017-03-21 11:40:30 +0100 answered a question Please allow saving bibliography database per document, not per computer

This isn't a suitable topic for Ask site, where users help each other to solve problems. Your proposal is better placed on Bugzilla as an enhancement request.

2017-03-21 09:26:33 +0100 answered a question how to know which template assigned to master document or odt file

Open the document as ZIP archive, and look into meta.xml.

2017-03-21 08:26:15 +0100 answered a question convert numbers into english text

There's no spellnumber function in Excel, only macros that are available on Internet using search.

You may use the answer accepted here.

2017-03-21 06:21:47 +0100 answered a question what's latest ver i can use on my 32bit xp sp3 machines?

Current versions (both still - 5.2, and fresh - 5.3) support WinXP SP3.

2017-03-20 11:12:00 +0100 answered a question unwanted separator line in header

What is the actual paragraph style of your header? I presume that you somehow applied the Footer paragraph style to the header (e.g., double-clicked the Footer style on the sidebar while your cursor was in header line).

Also, what means "I tried deleting the header, but that didn't work" - do you mean that you tried to delete contents from header, or did you disable header at all in page's style? A presume the former, because that latter should've removed the line.

2017-03-20 10:49:54 +0100 commented question How do I resize the margins

I suppose this is a practical advise based on personal experience, not a question to be answered?

Also, which our Online Previewer are you talking about?