Pergunte aqui

Perfil de cloph - atividade

2019-07-28 07:44:55 +0200 Medalha recebida  Resposta boa (fonte)
2018-06-07 01:22:47 +0200 Medalha recebida  Resposta legal (fonte)
2018-05-29 20:11:47 +0200 Respondeu uma pergunta Decimal precision - how to have 18 decimals?

You can't. LibreOffice uses IEEE 754 representation of the numbers, and that just doesn't offer that level of precision.

2018-05-18 03:48:50 +0200 Medalha recebida  Resposta boa (fonte)
2018-04-27 12:20:19 +0200 Medalha recebida  Resposta legal (fonte)
2018-02-19 15:48:02 +0200 Respondeu uma pergunta Where can I find a nice Libreoffice desktop icon? Not so fond of the stock grey one.

You can use the individual component's icons… https://github.com/LibreOffice/core/tree/master/sysui/desktop/icons/hicolo

2018-02-17 11:29:58 +0200 Respondeu uma pergunta Double-clicking a file results in LO crashing

Update to 6.0.1 - the bug was fixed already. see https://bugs.documentfoundation.org/show_bug.cgi?id=115352 (and other

2018-02-16 20:27:43 +0200 Pergunta comentada Keine Integration mit Anwaltssoftware seit 6.0 mehr möglich?

Gibt es hier jemanden, der zu diesem Thema etwas sagen kann? ganz glar die Macher von Advolux. Deren Post ist viel zu v

2017-08-22 16:28:14 +0200 Pergunta comentada Converting to csv using libreoffice

See https://ask.libreoffice.org/en/question/53143/convert-to-from-csv-to-ods-and-viceversa/ fore more details

2017-08-22 16:23:11 +0200 Pergunta comentada Convert-to from csv to ods and viceversa

FYI: I merged a question re saving as xls from csv to this one, so don't be suprised that some of the answeres refer to

2017-08-22 16:21:30 +0200 Resposta editada Convert-to from csv to ods and viceversa

Open the csv file (rename it to fred.csv if necessary). Choose the semi-colon separator. NEVER save as a csv file or a

2017-08-22 16:21:30 +0200 Pergunta editada Convert-to from csv to ods and viceversa

Convert-to from csv to ods and viceversa I have this problem. A ".csv" file where delimiter is tab and content is a "Lit

2017-08-17 17:17:43 +0200 Pergunta editada Changing Text to numbers

Changing Text to numbers I am new to Libre Office and am trying to import a csv file into a spreadsheet. Once imported,

2017-02-02 11:45:53 +0200 Respondeu uma pergunta Please add separate monitoring for IPv4 and IPv6

It's a limitation of the download manager TDF uses (mirrorbrain) - it doesn't have a flag that would offer this. see also https://github.com/poeml/mirrorbrain/...

TDF could only work around it, but question is whether it is worth the maintenance burden (would need to maintain two separate mirrorbrain instances for that)

2017-01-16 16:39:10 +0200 Resposta editada Can I supress the images on the start screen?

No, there isn't any option for suppressing the view of the recently-opened documents on the start screen.
See also: Can the new Start Screen in v4.2 be reverted to that in v4.1?

A request for enhancement on Bugzilla:
Bug 74834 - CONFIGURATION: Option to disable documents thumbnails on the New Start Screen
Status: FIXED

Update 2017-01-16

In LibreOffice 5.2 or later you can use Tools|Options → LibreOffice → Advanced → Open Expert Configuration to switch thumbnail mode. Search for RecentDocsThumbnail property and toggle the value to false.

See below for the initial answer with alternative ways and workaround for older versions of LibreOffice.


A workaround with password protection (see fdo#74844, comment #1):

...if you add a password to the file you want to protect your data, only the icon of the file will appear and no data will be shown.

password-protection

[2014-07-29] Doesn't work with LibO 4.3.0, see Bug 80755 - Startcenter showing password protected file.


If you do not need the list of the Recent Documents:
You may install the extension History Master. There you can set the list size
of the Recent Documents (PickList) to zero:

history-master

Then the start screen will be shown as follows:

start-screen


Update 2014-05-20

A new feature in LibreOffice 4.3.0: Selectively delete Recent Documents.
See also: Removing files from the recent documents list.

image description


Update 2014-07-09

@Nars has provided a workaround that doesn't affect the list of the Recent Documents:

workaround-startscreen

You can customize the background color via menu
Tools → Options... → LibreOffice → Appearance → General → Application background.

2017-01-11 13:17:41 +0200 Pergunta editada LibreOffice Calc - zero values

I need to print/export to pdf with visible zero values in cells. I couldn't find the solution.

I'm using LibreOffice Calc version 5.0.2.3 under Ubuntu (linux).

I have configured my spreadsheet to always show zeros as blanks. However, in a small number of selected cells, I want zeros to be explicitly shown.

Is there a way to format individual cells to override the default "hide if zero" behavior? I can't find any way to do this.

Thank you very much.

2016-11-30 20:23:20 +0200 Medalha recebida  Guru (fonte)
2016-10-17 21:09:54 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-09-19 20:59:02 +0200 Medalha recebida  Pergunta notável (fonte)
2016-09-05 15:24:09 +0200 Medalha recebida  Pergunta popular (fonte)
2016-08-26 09:26:11 +0200 Medalha recebida  Resposta boa (fonte)
2016-08-21 19:26:58 +0200 Medalha recebida  Estudante (fonte)
2016-08-21 18:31:36 +0200 Resposta comentada Where can I download old versions of LibreOffice?

:-) thanks for the answer, was creating the question to answer myself since for some reasons we get more of those lately

2016-08-21 18:23:43 +0200 Medalha recebida  Autodidata (fonte)
2016-08-21 18:19:26 +0200 Respondeu uma pergunta Where can I download old versions of LibreOffice?

In general it is not advisable to use install or use an old version of LibreOffice, those are no longer maintained, might contain security and other bugs that were fixed in the meantime.

If you want to pinpoint a bug to a specific version where it has been introduced, you might be interested in the Bibisect Repositories instead. We have repositories with all the released versions or newer ones with a much finer granularity for more current versions.

If you still want an old version, you can find them in the download archiveat http://downloadarchive.documentfounda...

2016-08-21 18:13:58 +0200 Perguntou Where can I download old versions of LibreOffice?

I want to download an old version of LibreOffice for whatever reason, but the LibreOffice download page only offers the two most recent versions.

Where can I find older versions?

2016-08-19 16:22:22 +0200 Respondeu uma pergunta opening a csv file gives chinese signs

make sure to select the proper character encoding when opening the file. (UTF-8 vs UTF-16 vs other specific encodings)

2016-08-19 12:00:14 +0200 Resposta comentada Was ist mit AODL passiert? Ersatz?

http://stackoverflow.com/a/390149 hat die beste Zusammenfassung: * AODL wurde nicht mitgenommen, als das Projekt zu apache gewechselt ist * es war bereits zu diesem Zeitpunk (2011) unmaintained * es gibt ein repostitory auf BitBucket - aber ebenfalls unmaintained/veraltet (ist aber als offiziell angesehen werden kann: http://stackoverflow.com/a/10173183

2016-08-18 23:35:52 +0200 Respondeu uma pergunta How do I prevent LO from updating?

Goto Tools|Options → LibreOffice → Online-Update and disable the corresponding option to auto-check for updates.

And LibreOffice doesn't have a feature to automatically update itself. It only has a check whether new updates are available online.

So likely you added a repository to your linux distribution that carries the latest version and you did update by your distro's package manger.

2016-08-09 11:32:20 +0200 Resposta comentada Calc zeigt kein Hochkomma an

ein einfaches Hochkomma am Anfang der Zeile erzwingt die Interpretation als Text, das ist also ein Feature. Will man ein einzelnes Hochkomma am Anfang des Textes auch im Tabellenblatt anzeigen, so muss man das Zellformat manuell auf "Text" stellen, dann verliert das Hochkomma seine spezielle Bedeutung und wird ausgegeben..

2016-07-05 16:21:50 +0200 Respondeu uma pergunta Preventing text boxes changing apparent size on linux?

As already pointed out - the problem is in the font used. Calibri is a Windows-only font, but LO (as from TDF) offers Carlito font family as metrically equivalent substitution. For Arial and Times New Roman, the Liberation fonts offer that metrically equivalent replacement.

I don't see the package from Archlinux installing the Carlito fonts. https://www.archlinux.org/packages/ex... only lists the opensymbol font in its filelist, and the liberation fonts only as a build time dependency.

So installing https://aur.archlinux.org/packages/tt... should solve the problem, at least minimize it so you likely won't notice a difference. Switching to Carlito directly of course minimizes the differences even more :-)

(you can see what font is actually used by exporting to PDF and view the properties of the created file in your PDF viewer)

2016-05-19 18:09:32 +0200 Respondeu uma pergunta Please fix your email system at bugzilla

fixed the mailsetup for bugzilla, but nabble is a different service, so TDF admins have no influence on that.

nabble is a webfrontend in forum-style for the mailinglists only, so you don't have to use that indirection, but can subscribe directly to the mailinglist ( website+subscribe@global.libreoffice.org ) – but subscribing is optional (if you're not subscribed, your messages will be presented to mailinglist moderators –and you can also subscribe to "nomail" variant, so you won't get mail from the list)

2016-05-10 13:20:57 +0200 Respondeu uma pergunta Shortcuts for some features do not work when I upgraded to version 5

works fine here as well, double-check your configuration. image description

2015-11-13 23:58:10 +0200 Medalha recebida  Resposta legal (fonte)
2015-11-13 15:44:13 +0200 Respondeu uma pergunta extract (parse?) text string

for computing the sum of the digits, you can use a fancy formula like

=SUMPRODUCT(VALUE(MID(A1;ROW(INDIRECT("A1:A"&LEN(A1)));1))*1)

but explaining this a litte too much for this - but it also includes the answer to the question: Instead of LEFT, use the function MID:

=MID(A2;1;1)

for the first digit, and =MID(A2;2;1) for the second, until =MID(A2;8;1) for the eighth one.

Remember that those functions return text, not a number, so to compute with them, you should wrap them in VALUE function.

If all your input is of equal length, then assembling a manual function using eight VALUE(MID(A2,<offset>,1) statements is a workable solution, and probably easier to grasp than the fancy one above :-)

2015-08-05 16:24:58 +0200 Respondeu uma pergunta note in libreoffice

Sorry, your question is incomprehensible. You should try to write more clear. what is "zeta", and how is it different to "zita" that you use later?

In any case, LibreOffice has no problem with images in documents. You cannot use pictures/images in comments/notes inserted to a document, but comments aren't really meant for that. You can just insert an additional page into your document and insert your pictures there, and have the note say "see picture xy on the additional page" or similar.

Anyway, closing this question, as any answer requires guessing what you mean. Feel free to post another question with a more detailed description.

2015-08-05 16:03:08 +0200 Respondeu uma pergunta forgot password

If you saved in Open Document format, then there is no way to recover the password - You have to guess/remind yourself of the password, asee also http://ask.libreoffice.org/en/questio...

For actual excel format, there are tools that aid cracking a passowrd, please use a search engine of your choice.

2015-05-07 13:38:43 +0200 Respondeu uma pergunta Issues torrenting LO 4.x

That's more or less impossible to answer, if at all the Transmission project might be able to help. Transmission behaves bad when it comes to using webseeds - it uses way too many connections for that (at least it used to, hopefully they improved on that). So try to limit downloads to BitTorrent peers (disable the use of regular mirrors, that are also listed in the torrent) - maybe that helps.

Other than that: no idea - closing this one as it's off-topic to LO itself, but rather is a question for Transmission (but even then people would need some console output/more data to be able to help)

2015-05-07 13:33:07 +0200 Respondeu uma pergunta install into home directory on Linux redhat
for i in *rpm; do rpm2cpio |cpio -idmv; done

then you can move that opt/libreoffice<version> folder around to a place you like. Of course you won't get menu-integration that way - if you want to open files from your filemanager, you need add that mapping yourself.

2015-05-07 13:23:48 +0200 Respondeu uma pergunta Soll eine Absatzvorlage durch eine Veränderung der Zeichenformatierung automatisch angepasst werden?

Das automaitsche Aktualisieren der Vorlatge ist Einstellungssache.

Vorlage bearbeiten und auf der Übersichtskarte [ ] automatisch aktualisieren deaktivieren.

2015-04-02 11:38:02 +0200 Resposta comentada How do I switch output in presenter-console?

That's correct - you must not use "mirror display". But once you set the two monitors to display independent screens (usually you can just press your laptop's hotkey multiple times to switch between modes), you can configure which should be the "projector" for the audience and which one for the speaker using either the menu as in the answer above, or by pressing the corresponding "exchange" button in the speaker's view. See e.g. https://www.youtube.com/watch?v=hM5H4...

2014-11-07 15:12:11 +0200 Resposta comentada Libreoffice 4.3.3 Release Notes

yes, a typo - fixed that. Sorry for the confusion

2014-10-22 18:32:55 +0200 Respondeu uma pergunta Could you please explain how LibreOffice did not violate the Microsoft Visual C++ 2010 Runtime Libraries License by including it in your program.

Those are called redistributable for a reason.

http://msdn.microsoft.com/en-us/libra...

2014-08-28 20:12:27 +0200 Medalha recebida  Resposta muito boa (fonte)