Haz tu Pregunta

perfil de GrahamLees - actividad

2021-04-08 20:29:19 +0200 editar respuesta Calc, File>Export as PDF

AMENDED ANSWER n v7.0.4.2 When selecting to print to PDF you need to select the file type at the bottom right of the th

2021-04-08 20:24:44 +0200 editar respuesta Calc, File>Export as PDF

In v7.0.4.2 you first need to define the print range before you can print anything either to paper or specifically to PD

2021-04-08 19:53:10 +0200 respondió a una pregunta Calc, File>Export as PDF

In v7.0.4.2 you first need to define the print range before you can print anything either to paper or specifically to PD

2021-04-05 13:34:46 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-10-31 16:10:47 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-09-17 16:35:45 +0200 comentar pregunta How to get rid of an unwanted and automatic "cell protection" in Calc

Please edit your question to indicate which OS you are using as this might be relevant.

2020-09-17 10:05:20 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-09-16 17:03:03 +0200 comentar respuesta Inconsistent conditional formatting using formula

@johnSUN Don't beat yourself up about your direct response nor the OPs sensitivity to being slapped over the wrists for

2020-09-16 14:02:22 +0200 comentar pregunta Find value in last cell in column

You're right! Hadn't noticed that.

2020-09-16 13:33:57 +0200 comentar respuesta Find value in last cell in column

Thanks - the first example works perfectly when adjusted to within the range X4 to X17

2020-09-16 13:31:40 +0200 recibió una medalla  Ayudante (fuente)
2020-09-16 13:31:32 +0200 la mejor respuesta fue marcada Find value in last cell in column

In the below table (part of a greater sheet) I have a table of ECB monthly EUR/GBP closing rates. The two blanks are in respect of two additional occasions in a 28 day cycle and contain no data and are thus disregarded. The array in the example comprises cells in the range X4:X17.

image description

What I am seeking to do in another cell, is enter the most recent rate (in the example given 0.89605).

Currently, I just re-enter the data (overwriting what is already there in the reference cell) but I am certain there is a simple formula to achieve this objective.

I have tried VLOOKUP(), COUNTIFS(), INDEX() in various forms but with no success.

I'm certain there is a simple solution to this but just now, it evades me.

Can anyone propose a suitable, simple solution to return the value in the last occupied cell in a column of 14 data elements?

2020-09-16 13:31:32 +0200 recibió una medalla  Escolar (fuente)
2020-09-16 13:24:22 +0200 comentar pregunta Find value in last cell in column

Not sure how that works but it returns a value of 23154.74. How does that relate to 0.89605 (the expected result)?

2020-09-16 13:15:21 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-09-16 12:39:03 +0200 recibió una medalla  Estudiante (fuente)
2020-09-16 11:31:19 +0200 realizó una pregunta Find value in last cell in column

Find value in last cell in column In the below table (part of a greater sheet) I have a table of ECB monthly EUR/GBP clo

2020-08-23 14:39:45 +0200 comentar pregunta "Recent files" page

Please [edit] your question to say which OS you are using

2020-08-22 21:20:28 +0200 respondió a una pregunta Having some difficulty with linking cells between worksheets

To have persistent updating of data between two spreadsheets, insert Dynamic Data Exchange (DDE) links: Select and copy

2020-08-21 18:49:26 +0200 comentar pregunta mkdir: cannot create directory

[how to ask]

2020-08-21 18:49:26 +0200 recibió una medalla  Comentador
2020-08-15 16:11:55 +0200 comentar pregunta Is there a File / Options menu in Calc?

Options is under Tools

2020-08-15 16:10:25 +0200 comentar pregunta Is there a File / Options menu in Calc?

Optios is under Tools...

2020-08-15 11:38:55 +0200 editar respuesta Upgrade to LibreOffice 6.4.6?

(do I select Linux (64-bit) (deb) or Linux (64-bit) (rpm)? What do the deb and rpm abbreviations represent? deb

2020-08-15 11:38:15 +0200 editar respuesta Upgrade to LibreOffice 6.4.6?

(deb) stands for Debian - so Debian based OS. (rpm) is for Redhat Package Manager. LibreOffice 7 is released and this re

2020-08-15 10:07:23 +0200 respondió a una pregunta Upgrade to LibreOffice 6.4.6?

(deb) stands for Debian - so Debian based OS. (rpm) is for Redhat Package Manager. LibreOffice 7 is released and this re

2020-08-09 16:50:55 +0200 comentar pregunta files reset as read only and cannot be saved due to insufficient user rights

https://windowsreport.com/you-dont-have-permission-save-this-location/

2020-08-03 21:56:28 +0200 respondió a una pregunta I accidentally erased the contents of my expense file in the calculator section how can I regain it?

Did you not have a backup of your file? If you didn't delete the file but just some of the content and you haven't save

2020-08-02 13:29:40 +0200 respondió a una pregunta How do I add an email account to libre office

In File > Send > Email Document

2020-08-01 19:35:38 +0200 recibió una medalla  Entusiasta
2020-07-31 19:29:59 +0200 comentar pregunta Avery Label template inaccurate, how to fix?

ave you read this resource? Setting the top margin to 0.00" will not work on sheet labels as there is a top unprintable

2020-07-29 19:48:30 +0200 editar respuesta How do I sum the last 12 values in a column?

You can find the last row used in the column by using =COUNTIF(B2:B1000,">0")

2020-07-29 19:43:02 +0200 editar respuesta How do I sum the last 12 values in a column?

You can find the last row used in the column by using =COUNTIF(B1:B1000,">0")

2020-07-29 19:39:28 +0200 respondió a una pregunta How do I sum the last 12 values in a column?

You can find the last row used in th column by using =COUNTIF(B1:B1000,">0")

2020-07-29 10:04:34 +0200 respondió a una pregunta How to change the default insert date format in Writer?

Right click on the Date field in your template > Edit Fields... and select the format required from there. Save your

2020-07-28 21:45:04 +0200 comentar respuesta copying and pasting text from newspaper brings ads and pictures

Which browser are you using? In my case using Firefox with Ubuntu, I can press Ctrl+Alt+R which takes you into read mode

2020-07-28 21:37:40 +0200 comentar pregunta When I minimize one of two or more LibreCalc files I can't resize them back again. It seems like it is invisible.

Have you seen this resource