Ошибка 520 опен офис

##### — эти символы сообщают, что столбец, содержащий числа, недостаточно широк, или же дата и время, введенные в ячейки данного столбца, содержат отрицательные числа. В первом случае достаточно просто увеличить ширину столбца или изменить числовой формат данных (например, уменьшить число знаков после запятой). Во втором же случае надо:

• проверить формулу, если вычисляется число дней между двумя датами;

• если формула не содержит ошибок, необходимо изменить формат ячейки и перейти, например, с формата Дата и время на Общий или Числовой формат.

Ошибка: 501 — недопустимый символ. Формула содержит недопустимый символ, например =1Eр вместо =1E2.

Ошибка: 502 — недопустимый аргумент. Функция имеет недопустимый аргумент, например отрицательное число для функции извлечения корня.

Ошибка: 503 (#NUM! ) — недопустимая операция с плавающей запятой. Вычисление приводит к переполнению диапазона значений.

Ошибка: 504 — ошибка в списке параметров. Используется недопустимый параметр функции, например текст вместо числа или гиперссылка вместо ссылки на ячейку.

Ошибка: 508 — нет пары.

Отсутствует скобка (закрывающая или открывающая).

Ошибка: 509 — отсутствует оператор. В формуле отсутствует оператор (+, – и т. д.).

Ошибка: 510 — отсутствует переменная.

Отсутствует переменная (два оператора стоят рядом).

Ошибка: 511 — отсутствует переменная. В функции не хватает переменной.

Ошибка: 512 — слишком длинная формула.

Общее число внутренних маркеров (операторов, переменных, скобок) в формуле превышает 512 или общее число матриц, которые создает формула, превышает 150.

Ошибка: 513 — слишком длинная строка. Идентификатор в формуле превышает 64 Kб.

Ошибка: 514 — внутреннее переполнение.

Переполнен стек вычислений (например, операция сортировки предпринята на слишком большом количестве числовых данных — более 100 000).

Ошибка: 516 — внутренняя синтаксическая ошибка. В стеке вычислений недоступна необходимая матрица.

Ошибка: 517 — внутренняя синтаксическая ошибка. Документ с новой функцией открыт в старой версии программы.

Ошибка: 518 — внутренняя синтаксическая ошибка. Переменная недоступна.

Ошибка: 519 (#VALUE) — нет результата. Ячейка, на которую ссылается формула, содержит текст вместо числа. -В ячейке отображается #ЗНАЧЕН! , а не Ошибка: 519.

Ошибка: 520 — внутренняя синтаксическая ошибка. Компилятор создал неизвестный код компиляции.

Ошибка: 521 — внутренняя синтаксическая ошибка. Нет результата.

Ошибка: 522 — циклическая ссылка. Формула ссылается прямо или косвенно на саму себя, а параметр Итерации не настроен.

Ошибка: 523 — процедура вычисления не сходится. Функция потеряла подбираемое значение или циклические ссылки не доходят до минимальных изменений для заданного максимального числа шагов.

Ошибка: 524 (#REF) — недопустимые ссылки. В формуле отсутствует столбец, строка или лист с заданной ячейкой.

-В ячейке отображается #ССЫЛ!2, а не Ошибка: 524.

Ошибка: 525 (#NAME) — недопустимые имена. Нет допустимой ссылки, доменного имени, подписи столбца/строки, макроса, присутствует неправильный десятичный разделитель или не найдена надстройка.

-В ячейке отображается #ИМЯ, а не Ошибка: 525.

Ошибка: 526 — внутренняя синтаксическая ошибка. Ссылка устарела.

Ошибка: 527 — внутреннее переполнение. Слишком сложное вложение ссылок.

Ошибка: 532 (#DIV/0!) — деление на ноль. В формуле используется деление на ноль.

OpenOffice Error 520 Summary

Commonly, PC professionals refer to OpenOffice Error 520 as a type of «runtime error». Developers like Apache usually go through several checkpoints before launching a software program like OpenOffice. Unfortunately, sometimes errors such as error 520 might get missed during this process.

Some users might experience the message «Auto Calc Error 520.» while using OpenOffice. When that occurs, software end-users can inform Apache about the existence of error 520 bugs. The developer will then be able to rectify its source code and release an update in the market. Consequently, the developer will use a OpenOffice update package to resolve error 520 and any other reported error messages.

What Actually Causes Runtime Error 520?

It’s likely that when you’re loading OpenOffice you will run into OpenOffice Error 520. We may determine that error 520 runtime errors originate from:

Error 520 Crash — This is a typical «OpenOffice Error 520» error that leads to total program termination. These errors typically occur when OpenOffice inputs can’t be correctly processed, or it’s confused by what is supposed to be output.

OpenOffice Error 520 Memory Leak — If there’s a memory leak in OpenOffice, it may cause the OS to appear sluggish. Possible causes due to failure of Apache to de-allocate memory in the program, or when bad code executes a «infinite loop».

Error 520 Logic Error — Software logic error occur when, despite the exact input from the user, a wrong output is produced. This can happen when Apache’s source code has a vulnerability regarding data handing.

Commonly, corrupt or missing OpenOffice Error 520 files cause these Apache errors, and are sometimes attributed to a current or past malware infection affecting OpenOffice. As a first troubleshootiong step, most PC professionals will attempt to replace the applicable version of the Apache file. In addition, if your OpenOffice Error 520 error was due to a removed malware infection, we recommend running a registry scan to clean up any invalid file path references created by the malicious program.

Common OpenOffice Error 520 Issues

OpenOffice Error 520 Issues Related to OpenOffice:

• «OpenOffice Error 520 Program Error.»
• «OpenOffice Error 520 not valid.»
• «OpenOffice Error 520 has encountered a problem and needs to close. We are sorry for the inconvenience.»
• «OpenOffice Error 520 can’t be located.»
• «OpenOffice Error 520 not found.»
• «Problem starting application: OpenOffice Error 520.»
• «Can’t run OpenOffice Error 520.»
• «OpenOffice Error 520 failure.»
• «Faulty Program Path: OpenOffice Error 520.»

Usually OpenOffice Error 520 errors with OpenOffice happen during startup or shutdown, while OpenOffice Error 520 related programs are running, or rarely during the OS update sequence. It’s important to note when OpenOffice Error 520 issues happen, as it helps troubleshoot OpenOffice problems (and report to Apache).

Epicenters of OpenOffice Error 520 Headaches

These OpenOffice Error 520 troubles are created by missing or corrupt OpenOffice Error 520 files, invalid OpenOffice registry entries, or malicious software.

Chiefly, OpenOffice Error 520 complications are due to:

• Invalid OpenOffice Error 520 or corrupted registry key.
• Virus or malware corrupting OpenOffice Error 520.
• OpenOffice Error 520 mistakenly deleted or maliciously by software unrelated to the OpenOffice application.
• Another software in conflict with OpenOffice, OpenOffice Error 520, or shared references.
• Corrupt download or incomplete installation of OpenOffice software.

Product by Solvusoft

Download Now
WinThruster 2022 — Scan your PC for computer errors.

Compatible with Windows 11, 10, 8, 7, Vista, XP and 2000

Optional Offer for WinThruster by Solvusoft | EULA | Privacy Policy | Terms | Uninstall

When your site’s visitors see error 520 in their browser, it means Cloudflare is sending the message because your server returned an empty, unknown, or unexpected response.

The 520 error can be approached through troubleshooting first to find the cause and then fixed following these steps.

Let’s jump right in:

Troubleshooting Error 520

Since the 520 error is coming up because of an issue on your server, you can troubleshoot the issue by looking in your error log.

Disable Cloudflare

Before you start troubleshooting, it’s necessary to disable Cloudflare. This helps isolate the problem by ensuring the issue can be replicated without Cloudflare being a factor.

Step 1

Start by logging into Cloudflare. Then, find your site on the list and click on it.

Step 2

Next, click on the DNS tab, then on the orange cloud under the Proxy status section in the table. You’ll know Cloudflare was disabled because the cloud will have turned gray.

Pause Cloudflare

Alternatively, you can choose to pause Cloudflare after logging in.

Step 1

Click on your connected site from the list.

Step 2

Then, scroll down until you see the Advanced Actions section in the sidebar. Click on the Pause Cloudflare on Site link.

Step 3

A pop-up will be displayed on the page that asks you to confirm you want to pause Cloudflare. Go ahead and click the Confirm button.

Go into Development Mode

If you don’t want to pause or disable Cloudflare, you can keep it running, but place it in development mode so you can still troubleshoot error 520.

Step 1

After logging into Cloudflare, click the Caching tab toward the top of the page.

Step2

Next, scroll down to the Development Mode section and click the Off toggle button. It should now say “On.”

Checking Your Server’s Error Logs

Now that you have disabled, paused or put Cloudflare into development mode, you can troubleshoot error 520 by checking your server’s error logs.

Finding your error log can vary between hosts so check with yours if you’re unsure of where to find your error logs.

If your hosting provider uses cPanel, you can follow the steps below.

Step 1

Log into cPanel and in the dashboard, go to the Metrics section. Then, click the Errors button.

Step 2

The error log page displays errors in reverse chronological order as well as up to 300 of the most recent messages. The error log may display more messages if you or your host adjusted the settings.

Checking Your Log for Error 520 Using MyKinsta

If you host your WordPress site with Kinsta, you can follow the steps below to check your error log.

Step 1

Log into MyKinsta and click on Sites in the menu on the left. Then, select the site you want to troubleshoot from the list on the page.

Step 2

Click on the Logs tab. By default, the error log is displayed. If you don’t see anything listed, it’s due to the fact that no errors on your site have occurred.

How to Interpret the Error Log

Each message in an error log has a structure. If you understand it, you can interpret the error messages that come up.

[Fri Oct 11 17:00:30 2019] [error] [client 123.4.56.7] error description: /path/to/file/with/error

The date and time of the message are listed first followed by the LogLevel directive which tells you about the severity level of the message.

Next up is the IP address of the client. This is who made the issue appear.

Finally, the actual message is displayed and may contain a path to the affected file.

Here are the LogLevel severity levels which could be listed in your error log’s messages:

• Emerg – This lets you know the issue is an emergency and the server is unavailable.
• Alert – Action should be taken immediately if you see this level.
• Crit – This denotes a critical condition.
• Error – This means an error has occurred.
• Warn – A message with this level is a warning about an issue that requires your attention, but isn’t critical.
• Notice – This means your server is normal, but there are significant details about the condition of your server that is available.
• Info – General information is available with this level.
• Debug – These messages contain details when you have debugging enabled.

Use a cURL Command to Troubleshoot Error 520

You can also use a cURL command to troubleshoot error 520 by testing against the origin server.

curl -vso /dev/null --user-agent "Mozilla 5.0" -H "Host: your-site.com" http://123.45.6.789/wp-login.php

Be sure to change “you-site.com” to your actual domain. You also need to update “123.45.6.789” with your site’s IP address. If you changed your login page, you should also change the “wp-login.php” part.

A successful response header would look similar to the example below:

* Hostname was NOT found in DNS cache
*   Trying 123.45.6.789...
* Connected to 123.45.6.789 (123.45.6.789) port 80 (#0)
> GET /login HTTP/1.1
> User-Agent: Mozilla 5.0
> Accept: */*
> Host: your-site.com
>
< HTTP/1.1 200 OK
< Content-Type: text/html
< Date: Day, DD, Month Year Hour:Minute:Second Timezone
{ [12345 bytes data]
* Connection #0 to host 123.45.6.789 left intact

If you see something like this, it means everything’s okay and the site was reached without an error 520 response.

On the other hand, if you see a response header similar to the example below, it means the 520 error has occurred when Cloudflare was active:

* Hostname was NOT found in DNS cache
*   Trying 123.45.6.789...
* Connected to 123.45.6.789 (123.45.6.789) port 80 (#0)
> GET /login HTTP/1.1
> User-Agent: Mozilla 5.0
> Accept: */*
> Host: your-site.com
>
* Empty reply from server
* Connection #0 to host 123.45.6.789 left intact

How to Generate a HAR File

A HAR is an HTTP archive file. It contains archives for requests that are going to the server of origin and also through Cloudflare.

It can help you with troubleshooting because it compares response headers coming from the origin server and Cloudflare when it’s used as a proxy.

It’s also used to confirm that the headers are too large if that’s why error 520 has appeared.

You can create a HAR file with your browser with the steps below:

Chrome

Step 1

Open your browser and right-click on the page. Then, select Inspect.

Step 2

Once the panel has opened, click the Network tab and make sure there’s a red circle button toward the top, left-hand side of the panel. If it’s gray, click it.

Step 3

Check the Preserve log option next to the record button and then click the clear button.

Step 4

Load the page that’s bringing up error 520. Then, right-click anywhere in the messages area of the Chrome developer tool.

Select the Save as HAR with Content and save the file to your computer.

Firefox

Step 1

Open Firefox and right-click anywhere on the page. Then, select Inspect Element.

Step 2

Go to the Network tab and visit the page that has the 520 error coming up. Right-click on messages in the panel and select the Save All as HAR option.

Save the file to your computer.

Edge

Step 1

Open the Edge browser and right-click the page. Select Inspect from the list.

Step 2

Go to the Network tab and ensure the circular record button is red. If it’s not, click it. Check the Preserve log option, then the icon to clear the current messages.

Step 3

Go to the page where you’re experiencing error 520. Then, right-click on the messages in the developer tool panel and select the Save all as HAR with content option.

Save the file to your computer.

Safari

Step 1

Open Safari and right-click on the page for Windows or press CMD on your keyboard and click for Mac. Select Inspect Element from the list.

Step 2

Go to the Network tab. Check the Preserve Log option, then go to the page with the error 520 issue.

Step 3

Click the Export button and save the HAR file to your computer.

Resolving the Common Reasons for Error 520

Now that you have your error log, search through it and see if you notice any one of the issues below. Then, follow the steps below to resolve the issue.

Origin Server PHP Application Crashed

One common issue that causes error 520 is that one of the PHP applications have crashed on your server. Restarting PHP will fix the error.

Step 1

Using SSH, you can enter the command below for Apache servers:

apache2ctl restart

For Nginx servers, you can restart PHP using the command below:

service nginx restart

Restart PHP in MyKinsta

If your site is hosted with Kinsta, you can restart PHP in a few clicks.

Step 1

Log into MyKinsta and click on Sites on the left. Then, click on your site from the list.

Step 2

Go to the Tools tab and click the Restart PHP button.

Cloudflare IP Addresses Aren’t Whitelisted

Another reason why the 520 error can occur is if Cloudflare’s IP addresses aren’t whitelisted. You can whitelist them, but the steps vary between hosting providers.

If you’re not sure how to whitelist IPs, contact your host, especially if you don’t find any settings for it.

At Kinsta, Cloudflare’s IP addresses are whitelisted by default so there’s no need to worry about this cause of the error. It also won’t impact the other reasons why the error occurs.

TCP Idle Timeouts Are Shorter Than 300 Seconds

The Transmission Control Protocol (TCP) could also be the cause of error 520.

TCP is a standard protocol that establishes and maintains a network connection. If the TCP is set to timeout in under 300 seconds, it could cause the 520 error to pop up.

You can change the TCP service timeout using a CLI command:

set service Service-HTTP-1 -svrTimeout 500

Headers Exceed 8 KB

This issue is typically due to too many cookies or cookies that are too large. The HAR file that you downloaded during the troubleshooting process will show you if this is the problem.

Cloudflare has a limit of 8 KB that can be used for headers.

If you authored a plugin that requires too many cookies or has too much data in its cookies, try to reduce them. Or, if you’re using a lot of plugins that all need cookies, remove some of them (you should always use quality plugins).

Elementor Users

When you try to edit your WordPress site using Elementor and you get the 520 error – “Web server is returning an unknown error” – you can check the following.

First, you can try a different web browser.

If the problem still exists and your site is behind Cloudflare you may have a problem with Cloudflare’s Rocket Loader feature.

The issue was caused by Rocket Loader automatically changing the scripts to load asynchronously, which breaks the site editor and prevents you making changes.
By creating rules in Cloudflare you can solve this issue.

For Elementor pages: Site URL/*elementor*
For Elementor templates: Site URL/?elementor_library=*

Empty Response from Your Server

This problem occurs when your site lacks an HTTP status code or response body. To resolve it, make sure your DNS settings are set correctly for your site’s domain.

The steps involved to check your settings depends on your DNS host. If your hosting plan has DNS bundled with it, then check with your hosting provider.

It may be important to note that if you updated your DNS settings, it may take up to 72 hours for your site to propagate. This means your site may be unavailable for up to three days.

After changing your DNS settings, you need to clear your site’s cache. If you have a caching plugin installed on your WordPress site, you can check its documentation if you’re unsure of how to clear your site’s cache from the plugin’s settings.

You can also clear your site’s cache through your hosting provider. Be sure to check with them if you need to know how to do this for your site.

If your site is hosted with Kinsta, you can click Sites in the menu, then on your listed site.

Then, click the Tools tab and click the Clear cache button.

If you have updated your DNS settings, your site is available again, you cleared your site’s cache and you still are experiencing error 520, restart your server.

If you don’t find the option in your settings, contact Kinsta’s support team and we’ll help you with this.

Missing Response Headers

According to Mozilla,

“A response header is an HTTP header that can be used in an HTTP response and that doesn’t relate to the content of the message. Response headers, like Age, Location or Server are used to give a more detailed context of the response.”

Missing response headers can be caused by a multitude of reasons.

Your best bet with this issue is to use a debugging tool like Fiddler to debug the issue and see exactly what the problem is so you can fix it.

Server not Returning Proper HTTP Error Responses

When your server sent an invalid error response, it could have caused the 520 error. This means the message didn’t fit in with the standard list of HTTP response codes.

It’s caused by your server or it could also be something on your server such as PHP applications or possibly plugins used on your WordPress site.

If you can’t find the source for the improper error code to fix it, try contacting support for further help.

Enabling Cloudflare Again

Check to see if you receive the error again. If you do, keep Cloudflare disabled and continue troubleshooting.

If the 520 error has been resolved, enable Cloudflare again.

Step 1

To do this, log into Cloudflare and if you disabled Cloudflare by turning the cloud gray in your account, start by selecting your site from the list.

Step 2

Click the DNS tab, then click the gray cloud to re-enable Cloudflare.

Restoring Cloudflare After Pausing It

Step 1

If you paused Cloudflare earlier, restore it by logging into Cloudflare and click on your listed site in the dashboard.

Step 2

Then, go to the Overview tab and scroll down to the bottom of the page until you see the Advanced Actions sections in the sidebar on the right-hand side of the page.

Click the Enable Cloudflare on Site link.

Turning off Development Mode

Step 1

If you have previously turned on Cloudflare’s development mode, you can turn it off by logging in. Then, click your site that’s listed on the page.

Step 2

Next, go to the Caching tab.

Step 3

Scroll down to the Development Mode section and click the toggle button that’s currently set to “On.”

What to Do If All Else Fails

If you’re still seeing issues, contact Cloudflare support.

Provide them with the following details:

• Full URL(s) of the requested resource when the error occurred.
• Cloudflare’s Ray ID from the page where you saw the error 520 message.
• The output from http://your-site.com/cdn-cgi/trace, but be sure to replace “your-site.com” with your actual domain name.
• Two HAR files: One from when Cloudflare was enabled for your site and one more from when you had Cloudflare disabled.

Is #Cloudflare giving you the Error 520? Here’s how to troubleshoot it and get this issue fixed! 🌧️🌈Click to Tweet

Summary

The 520 error can seem confusing, especially since it’s a Cloudflare error. But, it has to do with an error with your server that causes Cloudflare to not connect.

The steps above are the solutions to the most common causes of error 520. If you’re still having issues after trying them, you might want to contact Cloudflare or your hosting support.

Suggested reading: How to Set up Cloudflare APO for WordPress.

Сводка «OpenOffice Error 520

Как правило, специалисты по ПК называют «OpenOffice Error 520» как тип «ошибки времени выполнения». Разработчики, такие как Apache, обычно проходят через несколько контрольных точек перед запуском программного обеспечения, такого как OpenOffice. К сожалению, иногда ошибки, такие как ошибка 520, могут быть пропущены во время этого процесса.

Некоторые пользователи могут столкнуться с сообщением «Auto Calc Error 520.» при использовании OpenOffice. Когда это происходит, конечные пользователи программного обеспечения могут сообщить Apache о существовании ошибки 520 ошибок. Разработчик сможет исправить свой исходный код и выпустить обновление на рынке. Следовательно, разработчик будет использовать пакет обновления OpenOffice для устранения ошибки 520 и любых других сообщений об ошибках.

Что на самом деле вызывает ошибку времени выполнения 520?

Вполне вероятно, что при загрузке OpenOffice вы столкнетесь с «OpenOffice Error 520». Мы можем определить, что ошибки во время выполнения ошибки 520 происходят из:

Ошибка 520 Crash — это типичная ошибка «OpenOffice Error 520», которая приводит к полному завершению работы программы. Эти ошибки обычно возникают, когда входы OpenOffice не могут быть правильно обработаны, или они смущены тем, что должно быть выведено.

Утечка памяти «OpenOffice Error 520» — если есть утечка памяти в OpenOffice, это может привести к тому, что ОС будет выглядеть вялой. Возможные причины из-за отказа Apache девыделения памяти в программе или когда плохой код выполняет «бесконечный цикл».

Error 520 Logic Error — Ошибка программной логики возникает, когда, несмотря на точный ввод от пользователя, производится неверный вывод. Это может произойти, когда исходный код Apache имеет уязвимость в отношении передачи данных.

Как правило, такие Apache ошибки возникают из-за повреждённых или отсутствующих файлов OpenOffice Error 520, а иногда — в результате заражения вредоносным ПО в настоящем или прошлом, что оказало влияние на OpenOffice. Для устранения неполадок, связанных с файлом Apache, большинство профессионалов ПК заменят файл на соответствующую версию. Если ошибка OpenOffice Error 520 возникла в результате его удаления по причине заражения вредоносным ПО, мы рекомендуем запустить сканирование реестра, чтобы очистить все недействительные ссылки на пути к файлам, созданные вредоносной программой.

Распространенные проблемы OpenOffice Error 520

OpenOffice Error 520 Проблемы, связанные с OpenOffice:

• «Ошибка программы OpenOffice Error 520. «
• «Недопустимый файл OpenOffice Error 520. «
• «Возникла ошибка в приложении OpenOffice Error 520. Приложение будет закрыто. Приносим извинения за неудобства.»
• «OpenOffice Error 520 не может быть найден. «
• «OpenOffice Error 520 не найден.»
• «Проблема при запуске приложения: OpenOffice Error 520. «
• «Не удается запустить OpenOffice Error 520. «
• «Ошибка OpenOffice Error 520. «
• «Неверный путь к программе: OpenOffice Error 520. «

Обычно ошибки OpenOffice Error 520 с OpenOffice возникают во время запуска или завершения работы, в то время как программы, связанные с OpenOffice Error 520, выполняются, или редко во время последовательности обновления ОС. Важно отметить, когда возникают проблемы OpenOffice Error 520, так как это помогает устранять проблемы OpenOffice (и сообщать в Apache).

Эпицентры OpenOffice Error 520 Головные боли

Эти проблемы OpenOffice Error 520 создаются отсутствующими или поврежденными файлами OpenOffice Error 520, недопустимыми записями реестра OpenOffice или вредоносным программным обеспечением.

В основном, осложнения OpenOffice Error 520 связаны с:

• Недопустимый OpenOffice Error 520 или поврежденный раздел реестра.
• Вирус или вредоносное ПО, повреждающее OpenOffice Error 520.
• OpenOffice Error 520 ошибочно удален или злонамеренно программным обеспечением, не связанным с приложением OpenOffice.
• Другое программное обеспечение, конфликтующее с OpenOffice, OpenOffice Error 520 или общими ссылками.
• Поврежденная загрузка или неполная установка программного обеспечения OpenOffice.

Продукт Solvusoft

Загрузка
WinThruster 2023 — Проверьте свой компьютер на наличие ошибок.

Совместима с Windows 2000, XP, Vista, 7, 8, 10 и 11

Установить необязательные продукты — WinThruster (Solvusoft) | Лицензия | Политика защиты личных сведений | Условия | Удаление

jordias wrote:I’m trying to opean a xlsx file in OpenOffice 4.

OpenOffice CANNOT create XLSX files, so I know the file wasn’t created in OpenOffice. You should use the same program to open the file that was used to create the file. You should not expect to get good results if you use a different program. If the file was created in Excel, use Excel. If the file was created in LibreOffice, use LibreOffice.

jordias wrote:I’m not familiar with OpenOffice formulas …

Then it is particularly important for you to use the same program to open the file as was used to create it, since you cannot resolve any problems introduced by attempting to use a different one.

jordias wrote:The formula on OpenOffice looks like it’s been cutted (not complete).

Maybe, maybe not. You do not show us the formula in OpenOffice so we cannot know.

jordias wrote:This is the formula in xlsx:

What a mess!! For this situation, the main difference will be the sheet separator. Excel uses the bang (!) while Calc uses the period (.). Thus a translation to Calc would be:

=IF(FPL.BX6<>0;"FF "&FPL.BX6&CHAR(10);"")
&IF(FPL.BX7<>0;FPL.BX7&CHAR(10);"")
&IF(FPL.BX8<>0;FPL.BX8&CHAR(10);"")
&IF(FPL.AG13<>0;"AD ";"")
&IF(FPL.AG13<>0;FPL.AG13&CHAR(10);"")
&IF(FPL.Z14<>0;FPL.Z14&CHAR(10);"")
   &"(FPL-"
   &FPL.CD16
   &"-"&FPL.FQ16
   &FPL.HJ16
   &CHAR(10)
   &"-"&FPL.AJ18
   &FPL.CD18&"/"
   &FPL.EQ18&"-"&FPL.FU18
   &"/"
   &FPL.HI18
   &CHAR(10)
   &"-"
   &FPL.BE20
   &FPL.DQ20
   &CHAR(10)
   &"-"
   &FPL.AI22
   &FPL.CA22
   &" "
&IF(FPL.DU22=0;CHAR(10);FPL.DU22&CHAR(10))
&IF(FPL.Z25<>0;FPL.Z25&CHAR(10);"")
&IF(FPL.Z26<>0;FPL.Z26&CHAR(10);"")
&IF(FPL.Z27<>0;FPL.Z27&CHAR(10);"")
&IF(FPL.Z28<>0;FPL.Z28&CHAR(10);"")
&IF(FPL.Z29<>0;FPL.Z29&CHAR(10);"")
&IF(FPL.Z30<>0;FPL.Z30&CHAR(10);"")
   &"-"
   &FPL.AY34
   &FPL.CT34
   &" "
   &FPL.ES34
   &" "
   &FPL.GS34 
   &CHAR(10)
&IF(FPL.AI37=0;"-";"-"&FPL.AI37&CHAR(10))
&IF(FPL.Z38<>0;FPL.Z38&CHAR(10);"")
&IF(FPL.Z39<>0;FPL.Z39&CHAR(10);"")
&IF(FPL.Z40<>0;FPL.Z40&CHAR(10);"")
&IF(FPL.Z41<>0;FPL.Z41&CHAR(10);"")
&IF(FPL.Z42<>0;FPL.Z42&CHAR(10);"")
&IF(FPL.AV46<>0;"-E/"&FPL.AV46&" ";"")
&IF(FPL.DC46<>0;"P/"&FPL.DC46&" ";"")
&IF(OR(FPL.GC46=0;FPL.GT46=0;FPL.HK46=0);"R/"&C1&D1&E1&" ";"")
&IF(OR(FPL.BO50=0;FPL.CF50=0;FPL.CX50=0;FPL.DP50=0);"S/"&H1&I1&J1&K1&" ";"")
&IF(OR(FPL.FL50=0;FPL.GC50=0;FPL.GT50=0;FPL.HK50=0);"J/"&N1&O1&P1&Q1&" ";"")
&IF(FPL.AV54<>0;"D/"&FPL.AV54&" "&FPL.BS54&" "&"C "&FPL.DL54;"")&CHAR(10)
&IF(FPL.AV57<>0;"A/"&FPL.AV57&" ";"")
&IF(FPL.AV59<>0;"N/"&FPL.AV59;"")
&IF(FPL.AV62<>0;CHAR(10)&"C/"&FPL.AV62;"")&")"

jordias wrote:… it returns a Err:512

That means the monster formula is too complex for Calc and you should use the program which created the file to open it. If you understood Calc formulas you could, with some work, simplify it. For example, instead of 55 lines of contatenation you could put =IF(FPL.BX6<>0;»FF «&FPL.BX6&CHAR(10);»») in cell α, =IF(FPL.BX7<>0;FPL.BX7&CHAR(10);»») in cell β, =IF(FPL.BX8<>0;FPL.BX8&CHAR(10);»») in cell γ, and so on, then concatenate α, β, γ, … instead of the monster formula. But this will be difficult until you learn how to use Calc. If you’re interested in learning that, go to your local library and borrow a book on spreadsheets. Any book from the last 10 years will be fine, even one written for Excel.