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 |