Fai la tua domanda

m.a.riosv's profile - attività

2019-11-10 05:19:50 +0100 ha commentato una domanda Calc 6.3.x - Err:522 opening workbook

Follow the above @erAck advice, reported bugs like Err:522 on updating data from linked sheet

2019-10-31 23:37:19 +0100 ha risposto a una domanda In Calc, how do you paste formatting using menus?

After Copy, you can do it through [Ctrl+Shift+V] Menu/Edit/Paste special, if you only want to past the format, select on

2019-10-31 23:33:14 +0100 ha commentato una risposta BASIC|HSQLDB: SQL statement vs. wrong data type

Please, if the answer solves the question click ✔.

2019-10-30 22:45:57 +0100 ha commentato una risposta Custom Name or Removing Function Name For Pivot Table/Chart Data Columns

Please attach a file sample to your question.

2019-10-30 22:44:22 +0100 ha commentato una domanda Calc: New update moves my sheets row everytime i chose one.

Try moving all sheets to a new document.

2019-10-29 19:56:52 +0100 ha commentato una risposta Lectura del contenido del campo clave

Esa es la idea, editar la contestación cuando sea el caso, yo lo que suelo hacer es añadir una línea antes de la edición

2019-10-29 19:54:25 +0100 ha commentato una risposta I want to return info from a specific cell in another sheet, but only if the information relates to another cell (completely different cell)

Please, if the answer solves the question click ✔.

2019-10-29 10:18:52 +0100 ha commentato una domanda Configurar formato Microsoft Office para todos los usuarios

Realmente mala idea, la modificación del archivo xcu creo que no ha cambiado.

2019-10-29 02:01:00 +0100 ha commentato una domanda Named Range As Print Range

Please take look to this Not possible to create a dynamic Named Range with a calculated reference (like with OFFSET) and

2019-10-29 00:16:39 +0100 ha commentato una domanda Text import window opens

Looks like the file is broken, do you have a backup copy?

2019-10-28 13:05:01 +0100 ha risposto a una domanda Custom Name or Removing Function Name For Pivot Table/Chart Data Columns

Should be possible, take a look to the last paragraph Editing Pivot Tables

2019-10-28 12:45:11 +0100 ha risposto a una domanda No puedo imprimir copias de continuo con LibreOffice

Supongo que el número de páginas por minuto que genera LibreOffice, depende de la complejidad de lo que se imprime, espe

2019-10-27 15:29:53 +0100 ha commentato una risposta calc does not show existing item in col when you start to type

Please use the comments.

2019-10-27 15:28:59 +0100 ha commentato una domanda Named Range As Print Range

BTW it is a address range or a range defined by a formula?

2019-10-26 20:41:21 +0100 ha commentato una domanda Calc: New update moves my sheets row everytime i chose one.

It's strange, please test resetting the profile Menu/Help/Restart in Safe Mode.

2019-10-26 20:34:45 +0100 ha commentato una risposta How can I create my own intervals to use in pivot tables grouping?

I think the easier it's to add a column in the data source calculating the 4-month periods =INT((MONTH(B15)+3)/4) an ano

2019-10-26 20:24:03 +0100 ha commentato una risposta How can I create my own intervals to use in pivot tables grouping?

To ask for an enhancement File an enhancement request.

2019-10-26 00:03:09 +0100 ha risposto a una domanda I want to return info from a specific cell in another sheet, but only if the information relates to another cell (completely different cell)

Test if the next it's what you are looking for. - Column Res.B search for the rows with the ID introduced in Res.B2 -

2019-10-25 11:03:03 +0100 ha commentato una risposta Lectura del contenido del campo clave

Ahora no salen entrecortadas pero mal coloreadas, en fin.

2019-10-25 11:01:57 +0100 ha modificato una risposta Lectura del contenido del campo clave

Suponiendo que el campo que quieres usar sea un campo de texto: Sub Alfa Conn = ThisDatabaseDocument.CurrentControlle

2019-10-25 11:00:30 +0100 ha commentato una risposta Lectura del contenido del campo clave

Disculpa @Longi, lo he editado porque salian las líneas entrecortadas.

2019-10-25 10:59:32 +0100 ha modificato una risposta Lectura del contenido del campo clave

Suponiendo que el campo que quieres usar sea un campo de texto: Sub Alfa Conn = ThisDatabaseDocument.CurrentController.

2019-10-25 01:05:32 +0100 ha risposto a una domanda missing data in column one of libreoffice firebird query

I think what you want it's What's the difference between LEFT, RIGHT, INNER, OUTER, JOIN?

2019-10-25 00:48:11 +0100 ha commentato una domanda missing data in column one of libreoffice firebird query

Please avoid capitals, on the net it's like shout, and that's no needed.

2019-10-24 22:37:55 +0100 ha commentato una risposta Tabulador para cambiar entre valores de columna

Porfa @paquitov utiliza los comentarios, o edita tu pregunta.

2019-10-24 22:36:22 +0100 ha commentato una risposta En Base, necesito que, al pulsar en cada registro, se abra una carpeta que tiene el mismo nombre que el contenido del campo clave.

Porfa, cada hilo una pregunta, para ayuda a mantener el sitio ordenado. Por favor, si la respuesta soluciona la pregunta

2019-10-23 09:30:15 +0100 ha risposto a una domanda Please. Simplest Pivot Table.

Editing the Pivot Table move the name field to rows, and double click on it to mark to get the sum for the field. And i

2019-10-23 09:25:18 +0100 ha risposto a una domanda Does LibreOffice run in macOS 15 - Catalina

TDF Blog, LibreOffice and macOS Catalina

2019-10-23 08:54:41 +0100 ha risposto a una domanda is the latest version compatible with Mac OS Catalina 10.15

TDF Blog, LibreOffice and macOS Catalina

2019-10-23 08:53:06 +0100 ha risposto a una domanda LibreOffice does not start on MacOS Catalina

TDF blog, LibreOffice and macOS Catalina

2019-10-23 08:50:05 +0100 ha commentato una domanda Please. Simplest Pivot Table.

I think editing your question and clicking on the clip.

2019-10-23 08:33:12 +0100 ha commentato una domanda Please. Simplest Pivot Table.

Please attach a sample of what you have done?

2019-10-22 22:39:14 +0100 ha commentato una risposta Bug in my sumif() regex

I didn't the sample exactly as the questioner, I am also used to copy the formulas from a sample sheet.

2019-10-22 22:36:54 +0100 ha commentato una risposta How do I add totals in a column

Usually it happens when cells contains numbers as text not true numbers, for those only direct references works, not ran

2019-10-22 22:33:39 +0100 ha commentato una risposta Bug in my sumif() regex

Ok I see now, forgive.

2019-10-22 22:27:51 +0100 ha commentato una domanda Libreoffice failed to save database entries

One thing to know,is if the file save the introduced data properly when working in a computer driver, to make sure it is

2019-10-22 22:24:12 +0100 ha commentato una risposta Returning a number when using the =IF(D3="100","25","0")

Better two than none :)

2019-10-22 22:22:55 +0100 ha commentato una risposta Bug in my sumif() regex

But if I'm not wrong the "=*" doesn't find anything, if it is to find any not empty then "=.*" or ¨.*" or "=.+" or ".+",

2019-10-22 22:21:50 +0100 ha commentato una risposta Bug in my sumif() regex

But if I'm not wrong the "=" doesn't find anything, if it is to find any not empty then "=." or ¨.*" or "=.+" or ".+", =

2019-10-22 22:04:03 +0100 ha risposto a una domanda Returning a number when using the =IF(D3="100","25","0")

Is there any spacial reason to put the numbers inside quotes?, don't use the quotes and you can get true numbers, not nu

2019-10-22 21:57:30 +0100 ha risposto a una domanda Extraer valor en una celda hace referencia a otra

Para eso está la función INDIRECTO(B1&B2) Ayuda INDIRECTO

2019-10-22 03:59:51 +0100 ha risposto a una domanda How can I create my own intervals to use in pivot tables grouping?

Go to any cell of the date in the Pivot Table, and [F12] or Menu/Data/Group & Outline/Group, and select the interval

2019-10-22 03:44:17 +0100 ha commentato una risposta How to insert a check box in libre calc

Please don't use answers in this way, add your comment to other answers. And Please, if the answer solves the question c

2019-10-22 03:42:13 +0100 ha risposto a una domanda Getting a row and column number into a cell

Maybe the option Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted, can

2019-10-21 23:01:40 +0100 ha commentato una risposta Macro para pasar tablas de calc a writer con encabezado y descripción. Y generar gráfico pastel.

Si haces doble click en el objeto lo puedes editar dentro de writer, aunque sea un fichero de calc. Quizás prefieras par

2019-10-21 12:01:20 +0100 ha commentato una domanda Saving as CSV - no warning [solved]

And there are options to save the formulas in the sheet instead values, first time saving or 'saving as', editing filter

2019-10-18 21:58:57 +0100 ha risposto a una domanda LibreOffice thinks these documents are corrupted, I think they're not. What's wrong?

Test if the file is conformant with odf in ODF Validator for me doesn't pass the validation. So maybe claim to those w

2019-10-18 16:02:58 +0100 ha commentato una domanda Copy/Paste issues Libreoffice calc

Please detail for every kind of copy the source (I guess 6.3) and destination.

2019-10-15 21:43:17 +0100 ha commentato una domanda I can't introduce new records in a table. Solved

It is a question also in the Spanish Ask?, please don't multipost, be a bit patient.

2019-10-15 21:40:00 +0100 ha commentato una domanda Desactivada la ejecución de macros

Puedes Crear un informe de error, por favor añade al mismo un fichero de ejemplo para pruebas, con el fin de que se pued