XIO

xWire

Posts from every feed QUEST has found across the web — blogs, news, podcasts, channels and more.

Ask LibreOffice - Latest posts

Latest posts

LibreOffice açılışta donma hatası

"Format Değişikliği (.xls’den .ods’ye): Sorunu ağırlıklı olarak .xls ve .xlsx uzantılı dosyalarda yaşadığımız için bunları .ods formatına çevirmeyi denedik. Bazen geçici olarak kaydetmemize izin verse de her zaman işe yaramadı. Hatta dönüştürdüğümüz bazı .ods dosyalarını açmaya çalıştığımızda sadece beyaz, boş bir ekranla karşılaştık." Buna tamamen katılıyorum.Aynısını yaşıyoruz. Dün yine temiz bir kurulumda son versiyonu kurdum. Neredeyse boş sayılabilecek bir belgeyi açmayı denedim ve açıldı.…

LibreOffice 26.8 Calcのオートフィル機能の挙動が怪しい

LibreOffice Ver 26.8.1.1 (X86)_64 Ubuntu 26.04 お世話になります。 Calcのオートフィルについてです。 先頭行が表示されていない状態でオートフィルを試みると、上に移動してしまいます。 [再現手順] 先頭行に適当にカラムを作ります。 2行目以降にデータを入れます。 1行目がウィンドウに表示されていない状態まで下にスクロールします。 データの入っているセルの右下の■からマウスをドラッグしてオートフィルします。 [結果] オートフィルが上に移動する [期待する動作] オートフィルが下に移動する [参考画像] 1行目をカラムにして2行目以降データを入れる 先頭行が見えない状態にして、データが入ったセルの右下の■から下にドラッグしてオートフィル 上にフィルされる また再現性はないですが、横にフィルすることもあります。 他の環境で試せていないので、どのように挙動するかは現状分からないです。

Date Parameters in Queries to an Access Database

Hello, everyone. I want to access an Access product order database from LibreOffice Base and extract data for completed orders within a specific time period. The “Completed During This Period” query accepts the start and end dates of the target period as parameters, but when I use the YY/MM/DD format, the results are blank and I can’t extract the data. I can extract the data if the format is MM/DD, but then entries from 2025 and 2026 get mixed together. What should I do? Thank you in advance.

Maintaining row height when sorting data in Calc

I have click Include formats , but still have the problems. Row height adjusted to suit, but this does not move with data when sorted. Version: 26.2.6.3 (X86_64) Build ID: 8221e31b3ac356a1623c672912a3d2b492f7e3d1 CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Thank you

LibreOffice 26.8.1 - "Not Responding" Freeze on Save or Opening Options Menu

Your bug has been marked as a duplicate of another bug. From https://bugs.documentfoundation.org/show_bug.cgi?id=173297#c17 It seems that the workaround appears to be “Reading my bug 157135 comment 65 and trying it out, renaming share\extensions\dict-en\Lightproof.components to Lightproof.components.old, the hang goes away.”

Various Audio-related issues in Impress presentation

These links don’t appear to address the issue I’m having. But I do have a theory that the issue may have something to do with the audio dropdown menu, because there’s so many files listed there from both this presentation and previous ones that it might potentially be causing problems. I have yet to test this, though. Not that I know how to clear that queue.

Comment configurer libreoffice fr en français pour que ça assume que les dates des xlsx français restent au format français?

Bonjour et bienvenue @Benjibasson83, sans le document .xlsx pour tester, c’est un peu pifométrique. Une hypothèse à tester : supprimer la langue par défaut des documents. Voir la copie d’écran Benjibasson83: les dates acceptées sont déja D/M;D.M.Y;D-M-Y;D/M/Y. J’ai toujours considéré ce réglage applicable à la saisie des dates, pas au format par défaut des cellules.

LibreOffice 26.8.1 - "Not Responding" Freeze on Save or Opening Options Menu

I wonder if anti virus heuristics are causing the issue? Can you add soffice.bin to the anti virus Allowed list? It is possible that the previous version was in the Allowed list. . For testing purposes of it isn’t the above, you could install parallel versions of LibreOffice, see Installing in parallel - The Document Foundation Wiki

Resize multiple shapes

Thanks. I changed the extension, so it works equally well in Writer and Calc. Addons.xcu: <prop oor:name="Context" oor:type="xs:string"> <value> com.sun.star.drawing.DrawingDocument,com.sun.star.presentation.PresentationDocument,com.sun.star.sheet.SpreadsheetDocument,com.sun.star.text.TextDocument </value> </prop>

How to Rename an existing Chart with a Macro?

Thanks for all the replies. Here’s what I’ve learned so far: A chart can be accessed in two different ways: Via the Charts collection. Via the DrawPage. Renaming a chart is only possible through an object accessed via the DrawPage, not through an object accessed via the Charts collection, even though the Object Inspector shows the setName() method. So far, so good. Now, Stephen Hawking once said, “It is very important for young people to keep their sense of wonder and keep asking why.”…

Busca de CEP com preenchimento automático dos campos

Para extrair o CEP de uma coluna com o endereço completo, acho que vale considerar também os casos em que o código aparece com ou sem hífen, já que isso pode afetar o resultado. Se houver vários formatos de endereço na planilha, uma fórmula ou macro que identifique os oito dígitos do CEP pode facilitar bastante a separação sem alterar o restante do texto.

How to Rename an existing Chart with a Macro?

FrankyBoy: myChart = ThisComponent.Sheets(0).Charts(0) In an excellent example provided by my colleague @Lupp, this construct (as shown by MRI) returns an object that supports the TableChart service. This service, in turn, has the XNamed interface, which includes the methods getName and setName. The getName method returns the programmatic name of the object: “Object1” and this name (in this case) cannot be changed by setName.

LO 26 - Não consegue adicionar documentos frequentes ou fixados no menu do atalho na barra de tarefas do windows

Olá, eu estava no Libreoffice 25 e os atalhos e documentos fixados na barra de tarefas do Windows 11 estavam aparecendo normalmente. Decidi atualizar par ao Libreoffice 26 mais recente e essa funcionalidade não está mais presente. Já reiniciei o sistema, mas não mais é possível anexar documentos frequentes na aba acessível pelo botão direito sobre o atalho na barra de tarefas.

Base - Empty forms using switchboard in Win 11

So it is right: The forms are external forms, not forms inside the Base file. Seems there won’t be established any connection to the database when form will be opened this way in Win 11. . Don’t know why you create a switchboard inside the Base file and external forms… . Might be it helps to execute a little macro when opening the document: SUB DatabaseConnect oDatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext") oDatasource = oDatabaseContext.getByName("Name of registered…

Bouton dans Calc n'exécute pas la macro assignée

Bonjour, Dans mon classeur sur une feuille j’ai créé un Bouton auquel j’ai assigné une macro, cependant l’action sur le bouton avec la souris ne lance pas la macro. Pour tester j’ai inséré une forme à laquelle j’ai assigné la même macro et qui fonctionne correctement. Je suis en version libreoffice 26.8.1.1 sous Windows11. Quelle peut être le problème avec le bouton? Merci par avance à ceux qui se pencheront sur mon problème

Formatação em conflito com formula [00":"00 & 00:00]

Sim! No caso de almoço, não tem tolerância! Somente na entrada para o trabalho que a pessoa tem tolerância de 10 minutos. Porem se chegar 11 minutos, será descontado os 11 minutos! Ex. Meu horário de entrada é 07:00, mas cheguei 07:10, tudo bem, pq estou na tolerância! Mas se eu chegar às 07:11, serei descontada. Se puder me ajudar em relação às horas noturnas. A formula não esta considerando. Ex 23:00 para 24:00. Ex o funcionário foi jantar e bateu o cartão às 23:12. Ao voltar para o trabalho,…

How to Rename an existing Chart with a Macro?

FrankyBoy: It seems to me that I’m missing something fundamental here. Just a GUESS Sun collapsed before they could finish the (very complex ) UNO software. So they implemented just an so to speak “Interface” in the Java tradition, without the code. Sometime ago I tried some method in a routine for Base and it didn’t work, raising also an error message. Don’t remember what it was… And yes: I also checked via MRI and the variable points to the Chart, Name displays but Method setName raises the…

Non riesco a inserire il numero di pagina correttamente

Ciao, avrei gentilmente bisogno di un aiuto per risolvere un problema che sto riscontrando con LibreOffice Writer durante la creazione di un documento. Quando provo a inserire il numero di pagina, questo non viene inserito automaticamente nel modo corretto in ciascuna delle pagine del file di progetto: infatti compare solo una scritta sul fondo con uno sfondo grigio con la dicitura «Numero di pagina». Se, ad esempio, inserisco manualmente il numero 1 nello spazio corrispondente, tutte le pagine…