Ibid command not working properly in date-format Calc cells

[Moxieman]

Ibid command for date-format cells in Libreoffice Calc stopped working properly

I have LibreOffice 7.1.3.2.

In LibreOffice Calc, if I use the ibid command (Control+") in the cell below another cell, it returns the same value in the same format as the cell above the ibided cell if the format of the above cell is text or currency. If the cell above is date formatted, however, Calc returns in the ibid cell the number of days since the base date of Calc (44000+ days). It does not return the date in the proper format.

If I drag the superior cell down, Calc copies the format correctly, but of course changes the date sequentially, which ibid would not do.

I have tried changing the cell format for the entire column, individual cells, and for groups of cells. No joy. Calc reverts to the number-of-days-since-creation when I try to use ibid.

Ibid worked fine before, but when I copied last year’s spreadsheet to this year, cleared data, and started new entries, I lost ibid command format retention for date cells.

So why would ibid return the proper value if the cell above has text or currency or numbers, but won’t duplicate a date with the proper format?

[Villeroy]

I have absolutely no idea what lbid is (do you mean LGBTQ?). Please upload a document demonstrating the issue.

[Lupp]

Probably derived from, the not so well known English word “ibid”, short for “ibidem” (erudite; in German also “ebenda”, imo obsolescent) used when referring to the most recently quoted text again.

[Villeroy]

I read the upper case I as L. Thank you.

[Lupp]

@Villeroy

I read the upper case I as L

I will never understand why people accept and use fonts making such a mess.

[LeroyG]

The Fill Single Edit (that’s the real name of the, until-now-unknow-for-me, funtion), in my user interface is assigned to Ctrl+'. See in menu Tools - Customize… - Keyboard tab.

But it only duplicates the content (number, text, formula) of the superior cell, not its format.

So you can Fill Single Edit and Clone Formatting (no matter the order), or drag the superior cell holding down Ctrl.

EDIT: For me, if cell formatting is not previously applied, it is easier to copy and paste.

A bit more of info here: https://wiki.documentfoundation.org/Development/DispatchCommands#Calc

Tested with LibreOffice 7.1.8.1 on Windows 10.

[Moxieman]

Thank you. Control and drag superior cell down works, but I am utterly mystified as to why Cntrl and " suddenly stopped copying the format as well as the information in the date.

I cannot find a clone format command in CALC. The link you gave referred to clone format in paintbrush.

Thanks,

[LeroyG]

@Moxieman

I cannot find a clone format

There is button with a paintbrush icon in the Standard toolbar. Also, you can choose from menu Format - Clone Formatting.

@Moxieman

suddenly stopped copying the format

Maybe you have used the Expand formatting option. See Tools - Options… - LibreOffice Calc - General. No need to Ctrl+', just typing. Unfortunately, it doesn’t work with date format.

[LeroyG]

After a bit more test, I found that date format and all other ones are extended if do you remain in the area adjacent to the cell where the format was applied.
Just another bit learned.

[sokol92]

Try Ctrl+D

[Villeroy]

@LeroyG

After a bit more test, I found that date format and all other ones are extended if do you remain in the area adjacent to the cell where the format was applied.

It is not extended if the cell is formatted by cell style only. If the cell has some hard formatting attribute, both, the style and the hard formatting is extended. Makes no sense to me. Since 20 years I keep this option off and work with cell insertion which expands formatting and references.

[LeroyG]

@sokol92

Try Ctrl+D

For me, this is for Selection List.

[LeroyG]

@Villeroy

If the cell has some hard formatting

You can set and unset one cell formatting attribute, and then the cell style is extended.

[Villeroy]

@LeroyG

You can set and unset one cell formatting attribute, and then the cell style is extended.

You think, this is intentional? I never want to expand formatting alone and particularly not in this obscure manner. If I want to extend a cell range, I insert cells and everything expands as expected.

[erAck]

@LeroyG

For me, this is for Selection List.

In English UI Ctrl+D is Fill Down; Selection List is Alt+Down. I think in Spanish it’s the same unless you customized assignments.

[LeroyG]

@erAck

unless you customized

I don’t remember to have customized something that I don’t use.
As example:
In the es-ES UI “Ctrl+A” is for “Open file”, but with me (now en-US) is for “Select All”.
Not sure why. Maybe because in this computer previously only was installed the es-ES UI.
Do not remember when was the last user profile reset. I will take a look at that. Thanks.

Version: 7.1.8.1 (x64) / LibreOffice Community
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: es-MX (es_ES); UI: en-US
Calc: CL

[Moxieman]

I will use the Cntl and drag down method, but I am utterly mystified as to why Calc suddenly changed the way it does things.

[erAck]

@LeroyG

In the es-ES UI “Ctrl+A” is for “Open file”, but with me (now en-US) is for “Select All”.

There are some shortcuts that are used system wide by common agreement, File Open is one of them. Ctrl+O in English (Open, and German Öffnen and probably some other languages as well), Ctrl+A in Spanish I assume is for Abrir.

[LeroyG]

@erAck

Ctrl+A in Spanish I assume is for Abrir.

Yes, that’s how it is.

In this other PC, Ctrl+D (for Fill Down) works as expected.

Version: 7.1.8.1 / LibreOffice Community
CPU threads: 1; OS: Linux 4.12; UI render: default; VCL: x11
Locale: es-MX (es_AR.UTF-8); UI: en-US
Calc: threaded

I use locale es-MX for the dot as decimal separator key. I only turn to the es-ES locale to follow the correct wording when there is a question in the Spanish category.

[LeroyG]

After reseting my user profile (Windows 10) Ctrl+D worked again. Other user in same Windows had no problem with this shortcut. Thanks all.