Pergunte aqui

Perfil de rautamiekka - atividade

2020-09-27 03:32:54 +0200 Resposta comentada Where do I download Libre font sets? I don't see a link on Libre.com

Recently I came across a subreddit called identifythisfont: https://www.reddit.com/r/identifythisfont/. Could come handy

2020-09-27 03:29:05 +0200 Resposta comentada Why does LO5.1.4 Writer "PDF export" don't compress PNG images if JPEG compression is enabled?

^ Yes, not fully true. I know from experience that GIMP has various options to decrease JPG size (and has internally imp

2020-09-23 14:26:45 +0200 Marcada como a melhor resposta Referencing a merged cell as a whole as required ?

As far as my very badly worked research went, I found out you have to reference the top left-most underlying cell in the cluster of merged cells to get what the cluster contains; trying to reference any other underlying cell returns nothing.

That's unacceptable, it either additionally complicates formulas or forces to do extra manual work.

How would such merged cell be correctly referenced then ? Attached the test file: Android, Forge of Empires.ods

In the file go to 'Supplies buildings' tab.

In columns D and E there are 5-row clusters of merged cells and each merged cell contains a number.

Column F is where each cell needs the clusters of merged cells to perform a calculation, but due to the requirement only the 1st row for each cluster performs the calculation successfully.

(Not sure about the tags right now)

2020-09-23 14:25:44 +0200 Medalha recebida  Pergunta notável (fonte)
2020-09-23 14:25:44 +0200 Medalha recebida  Pergunta famosa (fonte)
2020-08-31 00:54:54 +0200 Medalha recebida  Resposta legal (fonte)
2020-08-25 21:57:06 +0200 Marcada como a melhor resposta Calc unable to open 1.64MB ODS with tons not-so-complex but repeating formulas

I had a "template" that was to be used in music club for scoring of music tracks which was made to handle 999 tracks and so had around 18 columns, around 12 columns for scores. I realized how to make it nearly completely automatic and I have, after which I added rows for like 70k tracks and added colors, after which I started adding columns for more people. I meant to add as many as LO can support, but once I got 60k-70k rows and like 350 columns and managed to save successfully, LO consistently crashes during calculation when opening the file. I've tried the 32-bit and 64-bit editions of 5.0.2.1, the only differences being 64-bit loads much faster but also crashes much faster during calculation, simply disappearing from the screen. 32-bit gives me ACCESS VIOLATION popup before disappearing. What to do ?

  • Window$ 7 Ultimate SP1 x64 with Finnish language
    • 8GB RAM, around half in use. LO reaches 244½MB before going down, so there's 54% RAM in use when that happens
    • AMD A4-5000 APU (quad core) [with Radeon HD 8330], driver version 15.8 Beta
  • LibreOffice 5.0.2.1 32-bit and 64-bit tested, British English GUI
  • ODS file successfully saved, measuring 1.64MB by itself with under 67MB XML file inside

I checked the settings and disabled everything regarding calculation and rebooted LO, which made no difference.

Database not an option.

Since AskLO doesn't allow attaching a file (at least I don't see such option), the file is at https://drive.google.com/file/d/0Byxh...

It's nearly certain now: AMD A4-5000 APU doesn't like OpenCL operations much since I disabled OpenCL within LO and can perform operations I couldn't before, but every single type of calculation is so much slower now.

As much as I'd give more info, my head isn't figuring what.

2018-12-17 22:24:05 +0200 Medalha recebida  Pergunta notável (fonte)
2018-12-17 22:24:05 +0200 Medalha recebida  Pergunta famosa (fonte)
2018-06-21 14:12:33 +0200 Resposta comentada How to debug 'Wrong data type' problem (`SEARCH` function) ?

But if it didn't find the text, why give Wrong data type ?

2018-06-21 14:11:29 +0200 Medalha recebida  Pergunta popular (fonte)
2018-06-20 16:25:58 +0200 Perguntou How to debug 'Wrong data type' problem (`SEARCH` function) ?

How to debug 'Wrong data type' problem (`SEARCH` function) ? I'm using LO Calc 6.0.4.2 x64 on Window$ 7 Enterprise SP1 x

2018-01-14 23:16:01 +0200 Medalha recebida  Pajé (fonte)
2018-01-14 19:51:07 +0200 Pergunta comentada Can the latest version of LibreOffice be used on an Intel Z8350/BGA CPU

The CPU doesn't matter.

2018-01-14 19:49:18 +0200 Respondeu uma pergunta why is your product not installing like every other product I've used for 20 years

You used Internet Explorer, which is notorious at mangling MSI files into MAN files. Not a first time we've seen this.

2017-05-05 17:25:08 +0200 Resposta comentada Is it possible to launch a program from a link in a document?

I'm glad I bothered testing before saying: using /usr/bin/env google-chrome-stable %U doesn't work, it just doesn't exec

2017-05-04 16:50:14 +0200 Resposta comentada HELP! Is it possible to recover deleted document?

Important notes: save and execute the recovery software outside the partition where the lost file was, and make sure you

2017-05-04 16:48:52 +0200 Resposta comentada HELP! Is it possible to recover deleted document?

Important notes: save and execute the recovery software outside the partition where the lost file was, and make sure you

2017-05-03 15:32:41 +0200 Pergunta comentada populate from another worksheet if two fields match

@Lupp Not fully true. The difference between a db and a spreadsheet is merely the naming: the spreadsheet file is the db

2017-05-03 14:08:46 +0200 Resposta comentada Using Base for Multi-Users, Local Network, Single Database

^ Addendum: ... the docs. The forms are a different problem: if they're not provided as a website (which is another prob

2017-05-03 14:08:31 +0200 Resposta comentada Using Base for Multi-Users, Local Network, Single Database

All good. Indeed, he'd need MariaDB 10.1.x (the current stable, General Availability; for now, MariaDB is a superior MyS

2017-05-03 14:07:23 +0200 Resposta comentada Using Base for Multi-Users, Local Network, Single Database

^ Addendum: The forms are a different problem: if they're not provided as a website (which is another problem security-w

2017-05-03 14:04:53 +0200 Resposta comentada Using Base for Multi-Users, Local Network, Single Database

All good. Indeed, he'd need MariaDB 10.1.x (the current stable, General Availability; for now, MariaDB is a superior MyS

2017-05-03 13:49:52 +0200 Resposta comentada Why does LO5.1.4 Writer "PDF export" don't compress PNG images if JPEG compression is enabled?

1) Wrong, not always, but generally when the photo doesn't have high value, otherwise PNG or even TIFF. 4) Not fully tru

2017-05-03 13:45:10 +0200 Resposta comentada Why does LO5.1.4 Writer "PDF export" don't compress PNG images if JPEG compression is enabled?

NOT AN ANSWER ! DELETE AND COMMENT TO THE ANSWER IN QUESTION !

2017-04-29 20:33:32 +0200 Resposta comentada How to export "all" pages/print ranges from Calc into PNG ?

The workaround is to make the PNG either taller or wider, or even both, and putting each page next to one another. But d

2017-04-29 20:33:02 +0200 Resposta comentada How to export "all" pages/print ranges from Calc into PNG ?

The workaround is to make the PNG either taller or wider, or even both, and putting each page next to one another. But d

2017-04-29 20:32:36 +0200 Resposta comentada How to export "all" pages/print ranges from Calc into PNG ?

The workaround is to make the PNG either taller or wider, or even both. But depending on the used resolution to create a

2017-04-24 00:43:56 +0200 Pergunta comentada How to get rid of horizontal lines in text. don't know how they got there.

@EasyTrieve No need for a capture software unless you mean animated one, so you just need to hit PrintScreen and save us

2017-04-24 00:28:54 +0200 Resposta comentada Can't Connect to Access Database

I think it'd be fine if all the JARs were in the same folder as UCanAccess JAR itself.

2017-04-23 15:43:26 +0200 Respondeu uma pergunta How to batch download .torrent files?

When I still had my Dedicated Server, I was supporting the BitTorrent transfers for Window$ releases. I noticed that eac

2017-04-22 21:14:44 +0200 Resposta comentada LibreOffice 5.3.2.2 has corrupt CAB file

Right, but the PPA uses the naming the last RC had, which immediately made sense to me: no point in bothering with renam

2017-04-22 21:13:01 +0200 Resposta comentada LibreOffice 5.3.2.2 has corrupt CAB file

Addendum: in comparison, Win8.x is awesome system compared to Win10. An abomination the European Union has little troubl

2017-04-22 21:11:48 +0200 Resposta comentada LibreOffice 5.3.2.2 has corrupt CAB file

@Lupp You're definitely not the one to be blamed. Win10 was made with total surveillance in mind, and M$ never had the i

2017-04-21 19:57:30 +0200 Resposta comentada Reasons to use LibreOffice versus Office?

Addendum to my comment: also, Excel 2016 uses multithreading up to the CPU core count. Calc is single-threaded. Also, Op

2017-04-21 19:57:18 +0200 Resposta comentada Reasons to use LibreOffice versus Office?

Addendum to my comment: also, Excel 2016 uses multithreading to up to the CPU core count. Calc is single-threaded. Also,

2017-04-21 19:56:08 +0200 Resposta comentada Reasons to use LibreOffice versus Office?

LO defaults to using OpenGL, and LO's support for it is very bad, versus Office's use of DirectX (according to the overl

2017-04-21 19:51:54 +0200 Pergunta comentada Reasons to use LibreOffice versus Office?

@EasyTrieve A little correction: M$O is available, although as a more limited version for obvious reasons, on MacOS X.

2017-04-21 19:21:03 +0200 Pergunta comentada Evaluate worksheet, copy cell to new worksheet based on condition

A wiki question asking for help with Excel ... Sound odd ?

2017-04-20 21:49:10 +0200 Pergunta comentada Calc file ... first save is slow ... then fast

When it's Window$ as the OS, you can tweak your software and the system to an extent, but Window$ is always slow. Even i

2017-04-20 21:44:22 +0200 Resposta comentada writer - saving as doc-document - deletes any hyperlinks i insert in the text? how do i prevent that?

To be specific: always save as the native OpenDocument Format specific to the used module, then save in whatever other f

2017-04-19 23:08:52 +0200 Respondeu uma pergunta warning/error when saving as .doc

Just a warning of incomplete support for the format, it's all hardcoded (haven't checked code).

2017-04-19 23:06:30 +0200 Resposta comentada Excel 2016 IFS function equivalent

@WxManii This ain't an answer ! Edit the post itself !

2017-04-16 15:10:58 +0200 Resposta editada Fonts are fuzzy and menu flickers after 5.3.2.2 update

Could be the notorious LO user profile corruption. Make sure LO is completely down, then rename the profile folder as gu

2017-04-16 15:10:24 +0200 Medalha recebida  Organizador (fonte)
2017-04-16 15:10:00 +0200 Respondeu uma pergunta Fonts are fuzzy and menu flickers after 5.3.2.2 update

Could be the notorious user profile corruption. Make sure LO is completely down, then rename the profile folder as guide

2017-04-15 14:37:51 +0200 Resposta comentada Portable installation avaiable for Linux?

@carlm @Lupp is right y'know.

2017-04-15 13:15:01 +0200 Resposta comentada Is windows 10 X86 or X86-64

Better text than I'd had made, as much as I know about things.

2017-04-14 13:58:38 +0200 Resposta comentada LibreOffice 5.3.2.2 has corrupt CAB file

At least on Ubuntu, the LO PPA's use the final RC release as the official non-RC release since they're always identical.