# Calc

**URL:** https://forum.collaboraonline.com/c/user-support/calc/15.md

[Latest](https://forum.collaboraonline.com/latest.md) · [Categories](https://forum.collaboraonline.com/categories.md) · [Tags](https://forum.collaboraonline.com/tags.md)

---

## [About the Calc category](https://forum.collaboraonline.com/t/about-the-calc-category/198)

<div class="topic-metadata">

**Author:** [@pedro.silva](https://forum.collaboraonline.com/u/pedro.silva)\
**Replies:** 0

</div>

:green\_book: Spreadsheets .ods, .xls, xlsx, .csv

---

## [2 external links in one cell... Buggy](https://forum.collaboraonline.com/t/2-external-links-in-one-cell-buggy/5230)

<div class="topic-metadata">

**Author:** [@hichem9093](https://forum.collaboraonline.com/u/hichem9093)\
**Replies:** 0\
**Last updated:** [November 18, 2026, 1:11pm UTC](https://forum.collaboraonline.com/t/2-external-links-in-one-cell-buggy/5230 "2026-11-18T13:11:16Z")

</div>

Hi there, I am using Collabora on line on my server, and wanted to add 2 urls to one calc cell. which is something both LibreOffice and Excel support. Although this feature is advertised in the latest release, it is s…

---

## [How to filter before summing in a pivot table?](https://forum.collaboraonline.com/t/how-to-filter-before-summing-in-a-pivot-table/5222)

<div class="topic-metadata">

**Author:** [@cds](https://forum.collaboraonline.com/u/cds)\
**Replies:** 0\
**Last updated:** [November 16, 2026, 8:49pm UTC](https://forum.collaboraonline.com/t/how-to-filter-before-summing-in-a-pivot-table/5222 "2026-11-16T20:49:31Z")

</div>

Hi, I have a pivot table that sums the values of Column A from multiple spreadsheet rows to aggregate them across the value of another Column B. This works great. However, I would like to exclude from these sums any rows…

---

## [Every file corrupted](https://forum.collaboraonline.com/t/every-file-corrupted/5190)

<div class="topic-metadata">

**Author:** [@amyci](https://forum.collaboraonline.com/u/amyci)\
**Replies:** 4\
**Last updated:** [November 10, 2026, 8:27am UTC](https://forum.collaboraonline.com/t/every-file-corrupted/5190 "2026-11-10T08:27:44Z")

</div>

I only recently downloaded collabora on my Samsung s23fe, but I can’t use it as every file gets corrupted. I open a file, edit it, click on the little tick at the top left, then exit. When I try to open the file again, …

---

## [Show formulas in Collabora Office Desktop spreadsheet cells?](https://forum.collaboraonline.com/t/show-formulas-in-collabora-office-desktop-spreadsheet-cells/5120)

<div class="topic-metadata">

**Author:** [@tmuukkon](https://forum.collaboraonline.com/u/tmuukkon)\
**Replies:** 3\
**Last updated:** [October 20, 2026, 11:18am UTC](https://forum.collaboraonline.com/t/show-formulas-in-collabora-office-desktop-spreadsheet-cells/5120 "2026-10-20T11:18:45Z")

</div>

How to show formulas written on cells instead of their value? I found documentation that guides as follows: View \> Show Formulas. I don’t see such option in Collabora Office Desktop 26.04, installed from the Microsoft S…

---

## [Bug when panning accross cells](https://forum.collaboraonline.com/t/bug-when-panning-accross-cells/4956)

<div class="topic-metadata">

**Author:** [@luisakakpo](https://forum.collaboraonline.com/u/luisakakpo)\
**Replies:** 4\
**Last updated:** [August 31, 2026, 10:10am UTC](https://forum.collaboraonline.com/t/bug-when-panning-accross-cells/4956 "2026-08-31T10:10:23Z")

</div>

Hello, I’m a new user of Collabora on a self-hosted instance connected to Nextcloud. My team and I often experience a rather annoying bug when trying to select a range of cells, where the selection follows the mouse ev…

---

## [Calc android: selecting all data on sheet](https://forum.collaboraonline.com/t/calc-android-selecting-all-data-on-sheet/4962)

<div class="topic-metadata">

**Author:** [@pdfd](https://forum.collaboraonline.com/u/pdfd)\
**Replies:** 2\
**Last updated:** [August 22, 2026, 4:10pm UTC](https://forum.collaboraonline.com/t/calc-android-selecting-all-data-on-sheet/4962 "2026-08-22T16:10:20Z")

</div>

I think I stumbled on a way to select all data on a sheet by tapping the top left corner, but forget how it works

---

## [Spreadsheet on android](https://forum.collaboraonline.com/t/spreadsheet-on-android/4908)

<div class="topic-metadata">

**Author:** [@pdfd](https://forum.collaboraonline.com/u/pdfd)\
**Replies:** 3\
**Last updated:** [August 22, 2026, 8:58am UTC](https://forum.collaboraonline.com/t/spreadsheet-on-android/4908 "2026-08-22T08:58:06Z")

</div>

upload of csv text file; no function to configure currency data; uploads as text; no function to convert to currency; when currency or number format applied, adds leading apostrophe to retain as text

---

## [Calc android: multi pick](https://forum.collaboraonline.com/t/calc-android-multi-pick/4961)

<div class="topic-metadata">

**Author:** [@pdfd](https://forum.collaboraonline.com/u/pdfd)\
**Replies:** 1\
**Last updated:** [August 22, 2026, 8:57am UTC](https://forum.collaboraonline.com/t/calc-android-multi-pick/4961 "2026-08-22T08:57:47Z")

</div>

no idea how to select multiple rows or columns

---

## [Copy paste cell mistake between .ods und .xlsm](https://forum.collaboraonline.com/t/copy-paste-cell-mistake-between-ods-und-xlsm/4942)

<div class="topic-metadata">

**Author:** [@dvd](https://forum.collaboraonline.com/u/dvd)\
**Replies:** 0\
**Last updated:** [August 12, 2026, 9:49am UTC](https://forum.collaboraonline.com/t/copy-paste-cell-mistake-between-ods-und-xlsm/4942 "2026-08-12T09:49:00Z")

</div>

Hi, in a nextcloud-collabora instance i recently copy-pasted the content of an cell from a .odt file into a .xlsm file. The pasted cell was copied over, however with a wrong formatting (instead of the value “4700”, it …

---

## [Calc on android no search/replace function](https://forum.collaboraonline.com/t/calc-on-android-no-search-replace-function/4909)

<div class="topic-metadata">

**Author:** [@pdfd](https://forum.collaboraonline.com/u/pdfd)\
**Replies:** 9\
**Last updated:** [August 7, 2026, 5:34am UTC](https://forum.collaboraonline.com/t/calc-on-android-no-search-replace-function/4909 "2026-08-07T05:34:01Z")

</div>

There is a search field but no search / replace function

---

## [Android annoyances: pan instead of select, frequent reloading, etc](https://forum.collaboraonline.com/t/android-annoyances-pan-instead-of-select-frequent-reloading-etc/4829)

<div class="topic-metadata">

**Author:** [@xxxxme](https://forum.collaboraonline.com/u/xxxxme)\
**Replies:** 0\
**Last updated:** [July 8, 2026, 2:02pm UTC](https://forum.collaboraonline.com/t/android-annoyances-pan-instead-of-select-frequent-reloading-etc/4829 "2026-07-08T14:02:55Z")

</div>

I’m having a lot of trouble with the Android version of Collabora Calc (25.04.9.1 from Play Store). On my Samsung tablet (SM-T870, OneUI 5.1.1 / A13): (For clarity: “tap” means using the touch screen, “click” means usin…

---

## [Couldn't reset back to original after applying ascending sort in collabora online](https://forum.collaboraonline.com/t/couldnt-reset-back-to-original-after-applying-ascending-sort-in-collabora-online/4091)

<div class="topic-metadata">

**Author:** [@elhananjair](https://forum.collaboraonline.com/u/elhananjair)\
**Replies:** 2\
**Last updated:** [March 11, 2026, 12:03pm UTC](https://forum.collaboraonline.com/t/couldnt-reset-back-to-original-after-applying-ascending-sort-in-collabora-online/4091 "2026-03-11T12:03:43Z")

</div>

Hello friends, I am using Collabora Online with the Pydio Cells Document Management tool. I selected a column and applied a sort on the column. I couldn’t find a reset option to bring it back to the original order. Is th…

---

## [Filtering changes view of all users](https://forum.collaboraonline.com/t/filtering-changes-view-of-all-users/4478)

<div class="topic-metadata">

**Author:** [@hectorczelada](https://forum.collaboraonline.com/u/hectorczelada)\
**Replies:** 1\
**Last updated:** [March 2, 2026, 5:03am UTC](https://forum.collaboraonline.com/t/filtering-changes-view-of-all-users/4478 "2026-03-02T05:03:02Z")

</div>

In Collabora Online 24.04, is the ‘Temporary View’ feature available for Calc? We are working on shared spreadsheets, but filtering is global and disrupts other users’ work. I’ve checked the Data tab but I can’t find the…

---

## [Conditional Formatting Order – "Up/Down" buttons missing in UI?](https://forum.collaboraonline.com/t/conditional-formatting-order-up-down-buttons-missing-in-ui/4451)

<div class="topic-metadata">

**Author:** [@Simon](https://forum.collaboraonline.com/u/Simon)\
**Replies:** 0\
**Last updated:** [February 15, 2026, 8:22am UTC](https://forum.collaboraonline.com/t/conditional-formatting-order-up-down-buttons-missing-in-ui/4451 "2026-02-15T08:22:20Z")

</div>

Hello, I’m trying to change the order of conditional formatting rules in Collabora Online (via Nextcloud), but I can’t find any UI controls to reorder them. Setup COOLWSD version: 25.04.8.3(git hash: 0de01f3f02 (E)) L…

---

## [Collabora Desktop: Pivot Table not working](https://forum.collaboraonline.com/t/collabora-desktop-pivot-table-not-working/4449)

<div class="topic-metadata">

**Author:** [@matthiash](https://forum.collaboraonline.com/u/matthiash)\
**Replies:** 0\
**Last updated:** [February 12, 2026, 7:42pm UTC](https://forum.collaboraonline.com/t/collabora-desktop-pivot-table-not-working/4449 "2026-02-12T19:42:40Z")

</div>

Brand new user here. I downloaded and installed Collabora Desktop on Windows today. I love the concept. I love the design. But nothing happens when I click the Pivot Table button. This is the data I want to pivot:

---

## [Pasting in Collabora Office Calc](https://forum.collaboraonline.com/t/pasting-in-collabora-office-calc/4272)

<div class="topic-metadata">

**Author:** [@Le0](https://forum.collaboraonline.com/u/Le0)\
**Replies:** 2\
**Last updated:** [December 8, 2025, 6:47pm UTC](https://forum.collaboraonline.com/t/pasting-in-collabora-office-calc/4272 "2025-12-08T18:47:20Z")

</div>

Hello. I’m used to paste same value in multiple cells at the same time. It works in LibreCalc by default, but in Collabora Calc I couldn’t find a way to do it. Right now paste works only on first selected cell. Thank you…

---

## [F9 doesn't force calculation](https://forum.collaboraonline.com/t/f9-doesnt-force-calculation/4248)

<div class="topic-metadata">

**Author:** [@SRF](https://forum.collaboraonline.com/u/SRF)\
**Replies:** 1\
**Last updated:** [December 1, 2025, 7:18am UTC](https://forum.collaboraonline.com/t/f9-doesnt-force-calculation/4248 "2025-12-01T07:18:59Z")

</div>

Hi, I’m trying out the new desktop app. How do I force a calculation, as the usual F9 shortcut doesn’t work? I’m using the Linux flatpak under Linux Mint? Cheers.

---

## [Loading an ODS file with a custom macro does results in error (cmd=windowcommand kind=nodocloaded)](https://forum.collaboraonline.com/t/loading-an-ods-file-with-a-custom-macro-does-results-in-error-cmd-windowcommand-kind-nodocloaded/4059)

<div class="topic-metadata">

**Author:** [@srkunze](https://forum.collaboraonline.com/u/srkunze)\
**Replies:** 0\
**Last updated:** [October 7, 2025, 3:52pm UTC](https://forum.collaboraonline.com/t/loading-an-ods-file-with-a-custom-macro-does-results-in-error-cmd-windowcommand-kind-nodocloaded/4059 "2025-10-07T15:52:49Z")

</div>

Opening the document using Nextcloud and allow executing the macros results in the following error: cmd=windowcommand kind=nodocloaded I suspect some error on the side of the COOL server, but there’s little information…

---

## [Bug: Format Axis](https://forum.collaboraonline.com/t/bug-format-axis/3981)

<div class="topic-metadata">

**Author:** [@LLinna](https://forum.collaboraonline.com/u/LLinna)\
**Replies:** 7\
**Last updated:** [September 4, 2025, 6:43am UTC](https://forum.collaboraonline.com/t/bug-format-axis/3981 "2025-09-04T06:43:47Z")

</div>

Hi! Collabora’s spreadsheet has the following bug. After you’ve created a chart from your data and want to format, for example, the x-axis by right-clicking and selecting Format Axis. If you deselect the Automatic option…

---

## [=WEBSERVICE() neither updated automatically nor updated manually](https://forum.collaboraonline.com/t/webservice-neither-updated-automatically-nor-updated-manually/1852)

<div class="topic-metadata">

**Author:** [@dec0de](https://forum.collaboraonline.com/u/dec0de)\
**Replies:** 6\
**Last updated:** [July 19, 2025, 8:57am UTC](https://forum.collaboraonline.com/t/webservice-neither-updated-automatically-nor-updated-manually/1852 "2025-07-19T08:57:13Z")

</div>

In my environment where I am running the latest collabora docker container, the WEBSERVIC() seems to neither be updated when loading the spreadsheet, nor are you able to update it manually. If clicking on a field contain…

---

## [Output of selected cells in the "Find All" function](https://forum.collaboraonline.com/t/output-of-selected-cells-in-the-find-all-function/3856)

<div class="topic-metadata">

**Author:** [@USemyon](https://forum.collaboraonline.com/u/USemyon)\
**Replies:** 0\
**Last updated:** [July 8, 2025, 9:04am UTC](https://forum.collaboraonline.com/t/output-of-selected-cells-in-the-find-all-function/3856 "2025-07-08T09:04:37Z")

</div>

Hi, I wanted to clarify the possibility of implementing a window for displaying selected values for the find all button/function in Calc. Expected behavior: When you click on the find all button, a window with a list …

---

## [Collabora plugins doesn't work on pydio cells](https://forum.collaboraonline.com/t/collabora-plugins-doesnt-work-on-pydio-cells/3790)

<div class="topic-metadata">

**Author:** [@Andtwo](https://forum.collaboraonline.com/u/Andtwo)\
**Replies:** 1\
**Last updated:** [June 22, 2025, 8:46am UTC](https://forum.collaboraonline.com/t/collabora-plugins-doesnt-work-on-pydio-cells/3790 "2025-06-22T08:46:37Z")

</div>

I deployed Collabora using docker run -t -d -p 9980:9980 -e "extra\_params=-o:tls.enable=false" -e "domain=172\\.16\\.26\\.233" collabora/code and i have already config Collabora plugin on pydio cells’s plugin website when…

---

## [Android app: Editing a copy always required for every file](https://forum.collaboraonline.com/t/android-app-editing-a-copy-always-required-for-every-file/2242)

<div class="topic-metadata">

**Author:** [@Aline](https://forum.collaboraonline.com/u/Aline)\
**Replies:** 6\
**Last updated:** [April 1, 2025, 11:04am UTC](https://forum.collaboraonline.com/t/android-app-editing-a-copy-always-required-for-every-file/2242 "2025-04-01T11:04:28Z")

</div>

Hello, I’m using the Collabora Office app on Android to edit ods spreadsheets (version 21.11.6.1 on my phone, and version 23.05.5.2 on my tablet). Every time I open a spreadsheet, it opens in read-only, and I am forced…

---

## [Anchor array function](https://forum.collaboraonline.com/t/anchor-array-function/3406)

<div class="topic-metadata">

**Author:** [@ExtremTechniker](https://forum.collaboraonline.com/u/ExtremTechniker)\
**Replies:** 1\
**Last updated:** [February 17, 2025, 5:09am UTC](https://forum.collaboraonline.com/t/anchor-array-function/3406 "2025-02-17T05:09:40Z")

</div>

Hi, Microsoft Excel has the anchor array function e.g. triggered by =A4# The cell display in the online calc as {=\_xlfn.anchorarray(A4)} Would it be possible to integrate this function aswell into the online calc?

---

## [Is it possible to insert line break within a cell?](https://forum.collaboraonline.com/t/is-it-possible-to-insert-line-break-within-a-cell/3265)

<div class="topic-metadata">

**Author:** [@Lucifer](https://forum.collaboraonline.com/u/Lucifer)\
**Replies:** 5\
**Last updated:** [January 2, 2025, 11:43am UTC](https://forum.collaboraonline.com/t/is-it-possible-to-insert-line-break-within-a-cell/3265 "2025-01-02T11:43:21Z")

</div>

In Libreoffice windows, we can use ctrl + enter to insert line break within a cell in a spreadsheet. What to do to insert line break within a cell in Collabora office Android? Clicking on enter/return key on the on-scr…

---

## [Print selection only](https://forum.collaboraonline.com/t/print-selection-only/3152)

<div class="topic-metadata">

**Author:** [@fadabike](https://forum.collaboraonline.com/u/fadabike)\
**Replies:** 1\
**Last updated:** [November 13, 2024, 1:49pm UTC](https://forum.collaboraonline.com/t/print-selection-only/3152 "2024-11-13T13:49:41Z")

</div>

Hi There maybe this topic already exists (sorry if so) How to print selection only on a .ods ?

---

## [OOXML considered corrupted by MSOffice](https://forum.collaboraonline.com/t/ooxml-considered-corrupted-by-msoffice/3114)

<div class="topic-metadata">

**Author:** [@bakerman](https://forum.collaboraonline.com/u/bakerman)\
**Replies:** 6\
**Last updated:** [November 2, 2024, 6:04pm UTC](https://forum.collaboraonline.com/t/ooxml-considered-corrupted-by-msoffice/3114 "2024-11-02T18:04:57Z")

</div>

Greetings, thanks in advance for any assitance you may be able to provide. I updated yesterday to CODE 24.04.9.1. I noticed shortly after than any OOXML created via CODE cannot be open by any MSOffice program (they comp…

---

## [Sider for tabs in spreadsheet?](https://forum.collaboraonline.com/t/sider-for-tabs-in-spreadsheet/2920)

<div class="topic-metadata">

**Author:** [@smokinjo](https://forum.collaboraonline.com/u/smokinjo)\
**Replies:** 15\
**Last updated:** [August 30, 2024, 3:33pm UTC](https://forum.collaboraonline.com/t/sider-for-tabs-in-spreadsheet/2920 "2024-08-30T15:33:06Z")

</div>

I have multiple tabs in my spreadsheet file. The only way that I see to go left and right my numerous tabs is to use the arrows that are there. This either brings you to the extreme right of left of the row of tabs, or …

---

## [Format a cell with time data to display time a specific way](https://forum.collaboraonline.com/t/format-a-cell-with-time-data-to-display-time-a-specific-way/2845)

<div class="topic-metadata">

**Author:** [@A1391](https://forum.collaboraonline.com/u/A1391)\
**Replies:** 1\
**Last updated:** [August 9, 2024, 6:04am UTC](https://forum.collaboraonline.com/t/format-a-cell-with-time-data-to-display-time-a-specific-way/2845 "2024-08-09T06:04:28Z")

</div>

Main question: Is there any way to change a cell so that it displays “24:00:00” as “24:00:00”? I’m using mobile. Elaboration: I currently have data that is “24:00:00”. There are some cells in my spreadsheet that stubb…

[Next page](https://forum.collaboraonline.com/c/user-support/calc/15.md?page=1)
