Sorunuzu Sorun

erAck isimli kullanıcının profili - etkinlik

2021-02-27 23:24:33 +0100 rozet alındı  Güzel Cevap (kaynak)
2021-02-27 20:21:30 +0100 bir soru cevapladı Will LibreOffice have a Planner application?

No. There are a bunch of free planning applications around. https://taiga.io/ https://kanboard.org/ https://wekan.git

2021-02-27 20:12:35 +0100 bir soru cevapladı I have a custom style (in calc) I want to be included in every new document

Create a document (empty) with that style included (or Default style modified if it is supposed to be applied to all cel

2021-02-27 20:01:44 +0100 cevaba yorum yazıldı Konvertieren einer Tabelle aus Libreoffic zu dbase

Die Codepage-Kennung existiert ab dBaseIV und kennt in der Tat kein UTF-8. Calc speichert allerdings im dBaseIII Format

2021-02-27 19:18:53 +0100 cevaba yorum yazıldı Calc: how do I change Boolen annotation?

Copy&paste error, in FAIL() it should be FAIL = 0 instead of PASS = 0.

2021-02-27 19:10:27 +0100 cevaba yorum yazıldı What is this clock emoji that shows up?

That once happened with a quite old version of LibreOffice that had :12: and similar emoji replacements. You should upgr

2021-02-25 22:20:29 +0100 bir soru cevapladı Konvertieren einer Tabelle aus Libreoffic zu dbase

Ich glaube eher, dass die .dbf korrekt mit UTF-8 geschrieben wurde, aber die bereits existierende .odb (wenn ich das ric

2021-02-25 21:45:35 +0100 bir soru cevapladı Calc: how do I change Boolen annotation?

Use a format code [<>0]"PASS";"FAIL"

2021-02-25 21:38:56 +0100 cevaba yorum yazıldı Libre Calc - "Error Reading Data from the Internet"

Please do not use the Answer field for comments that are not an answer to the original question, use add a comment inste

2021-02-25 21:33:24 +0100 cevaba yorum yazıldı Calc TEXT Time Zone Formatting?

The necessary structures are usually available (at least on modern systems) and along with tzdata the offset from UTC fo

2021-02-25 16:07:53 +0100 cevaba yorum yazıldı Calc TEXT Time Zone Formatting?

Write an extension.. I have no idea if this Java Time Zones extension helps, reading its unformatted flow text descript

2021-02-25 16:00:22 +0100 cevaba yorum yazıldı Columns added to AutoFilter table don't sort together with existing columns

While that usually works, it also tends to get in the way in cases one forgot about it.. YMMV.. toggling it on a case by

2021-02-25 15:20:28 +0100 bir soru cevapladı In LO Calc can apply a reference formula to a text box on another sheet?

Sort of. Not with a text box, but if you use a form control list box (without connecting to a database) then in its cont

2021-02-23 17:04:21 +0100 soruya yorum yazıldı Preventing Text Overflow in a Calc Cell?

What doesn't work of adding a blank in the right neighbouring cell or activating wrap? Both work.

2021-02-22 14:31:23 +0100 bir soru cevapladı Calc TEXT Time Zone Formatting?

While you can hard format adding a fixed whatever string, all date+time values are timezone agnostic. Specifically there

2021-02-22 14:09:22 +0100 bir soru cevapladı Columns added to AutoFilter table don't sort together with existing columns

AutoFilter is just a functionality on cell ranges (one anonymous per sheet) or so called named database ranges. Those ta

2021-02-22 13:57:36 +0100 cevaba yorum yazıldı Format as table with changeable size and autoformat (like Excel)

¯_(ツ)_/¯ if it gets implemented..

2021-02-21 19:13:08 +0100 bir soru cevapladı Format as table with changeable size and autoformat (like Excel)

Yes, LibreOffice lacks those automatic table styles that would keep alternating row formatting, for example.

2021-02-21 13:44:23 +0100 rozet alındı  Güzel Cevap (kaynak)
2021-02-21 00:43:12 +0100 bir soru cevapladı sheetcellrange, sheetcellranges, inheritance query

SheetCellRange, SheetCell and SheetCellRanges are services, where each service exports one or more interfaces. In additi

2021-02-21 00:09:00 +0100 bir soru cevapladı [FEATURE REQUEST] Specify a default date format when importing from CSV into Calc

Specific formats can't be assigned in the import filter. After import select date column, apply ISO date format.

2021-02-21 00:06:14 +0100 bir soru cevapladı IFS function not working in OpenOffice 4.1.9

OpenOffice does not support the IFS() function. Use LibreOffice.

2021-02-19 14:19:08 +0100 bir soru cevapladı calc web page table pastes as single column

You can try to use menu Sheet -> Link to External Data... and paste the URL, hit Enter, and then select a table there

2021-02-17 19:00:45 +0100 cevaba yorum yazıldı Does calc have a side by side function

Also, as the questioner didn't specify what s/he wants to achieve, there's View -> Split Window, which splits at the

2021-02-16 19:13:51 +0100 bir soru cevapladı Avoid apostrophes in libreoffice calc

If the ' is not part of the cell content but only displayed in the Input Line (apparently you use the [] notation for th

2021-02-16 18:54:15 +0100 soruya yorum yazıldı [solved: user error] The password is incorrect ...

Same as in tdf#140456 you opened: Obvious check: does the same happen with TDF provided builds instead of the Arch packa

2021-02-13 17:13:55 +0100 soruya yorum yazıldı How can I make repeatable action untill I get a specific number.

I honestly think that no one understands what you are trying to ask.

2021-02-13 17:05:27 +0100 cevaba yorum yazıldı How to have different currencies coexisting?

It doesn't because it doesn't answer the question.

2021-02-13 17:01:45 +0100 cevaba yorum yazıldı How can I append a CSV export with other data

If the data is already in that form then it doesn't even need a macro to export it.. or what did I miss? Also note that

2021-02-13 00:31:48 +0100 soruya yorum yazıldı Using two rows as column headers?

Or in Opaque's example leave a blank row between the Totals row and the Headers row and then use the entire automatic da

2021-02-13 00:24:40 +0100 cevaba yorum yazıldı How to hide the shortcut underlines in menus

Please do not use the Answer field for comments that are not an answer to the original question, use add a comment inste

2021-02-10 19:33:07 +0100 cevaba yorum yazıldı Why are 'Insert Cells', 'Delete Sheet' and other options greyed out?

Glad to help. Then please mark the answer as correct by clicking the check mark icon. Thanks. And please do not use the

2021-02-09 15:51:43 +0100 bir soru cevapladı Why are 'Insert Cells', 'Delete Sheet' and other options greyed out?

You probably have change tracking activated. Deactivate menu Edit -> Track Changes... -> Record, or Shift+Ctrl+C.

2021-02-08 15:59:30 +0100 bir soru cevapladı LibreOffice 7.1.0

Please submit a bug report at https://bugs.documentfoundation.org/ Thanks.

2021-02-08 15:50:28 +0100 soruya yorum yazıldı SUMIF for multiple sheets between 2 sheets

Maybe you're misunderstanding how SUMIF() works. In your example it looks up the value of A36 (here Insurance) in the ra

2021-02-04 18:21:54 +0100 cevaba yorum yazıldı Calc: how to by-pass the protected sheet password

Fwiw, I added a sentence to not create a new zip to each section.

2021-02-04 17:54:11 +0100 bir soru cevapladı Calc: how to by-pass the protected sheet password

You didn't follow the instructions. The FAQ tells to freshen (!) the zip, not create a new zip. It even explains under N

2021-01-27 21:54:31 +0100 soruya yorum yazıldı ODT mit Text, Formel und Graphik braucht sehr lange zum Speichern. Wie kann ich dies vermeiden?

Kommentieren Duplikat von was wäre hilfreich. https://ask.libreoffice.org/de/question/289890/odt-mit-text-formel-und-gra

2021-01-27 00:53:31 +0100 cevap düzeltilmiş calc: |MAX| converted to 0,0000..0000E+00 in save-load cycle

The problem is that the rounded display string 1.79769313486232E+308 is saved to file and thus upon load can't be read a

2021-01-26 20:24:03 +0100 soruya yorum yazıldı How can Calc REGEX be used to filter only select non-alphanumeric characters from a string?

it is unclear if the special characters * ? + [ ( ) { } ^ $ | \ . are "Inside the set" or "Outside the set" for these

2021-01-26 20:15:19 +0100 soruya yorum yazıldı How can Calc REGEX be used to filter only select non-alphanumeric characters from a string?

Fwiw, that =REGEX($L$1,"[$M$1]","","g") was wrong anyway because "[$M$1]" is a literal string as regex argument (with

2021-01-20 16:43:14 +0100 soruya yorum yazıldı how can I get top row in a spreadsheet to repeat on each page when it prints

Duplicate of https://ask.libreoffice.org/en/question/288511/how-can-i-get-top-row-in-a-spreadsheet-to-repeat-on-each-pag

2021-01-20 16:41:08 +0100 soruya yorum yazıldı How can Calc REGEX be used to filter only select non-alphanumeric characters from a string?

What are your "special characters" and what expression do you use? Usually unexpected behaviour results from not being a

2021-01-20 16:03:10 +0100 soruya yorum yazıldı ods datei kann nicht geöffnet werden. Diese Datei enthält ein nicht unterstütztes Datumssystem

Das ist nur ein warning und OK.

2021-01-20 15:59:04 +0100 soruya yorum yazıldı sorting string and numeric data in calc

To convert a time text string to its numeric value use TIMEVALUE() and to display it as time again on the result apply a

2021-01-20 15:45:00 +0100 cevaba yorum yazıldı sorting string and numeric data in calc

Applying a number format does not change the content type from text to numeric or date/time.

2021-01-20 15:41:06 +0100 soruya yorum yazıldı LibreOffice installation and AVG may have damaged my hard drive

Duplicate of https://ask.libreoffice.org/en/question/288488/libreoffice-installation-and-avg-may-have-damaged-my-hard-dr