very slow loading of both the .ods and .xlsx version of that file.
tested under Win7x64 using LibO 4.2.5.2

Also slow in 4.1.6.2

Slowness is due to the massive amount (>1000) of conditional formats, most on sheets FT-ING-PR-02 and FT-ING-PR-03, many of them even applied to identical ranges. Looks like a result of heavy copy&paste actions, or the macro you mentioned creates them. All these conditionals also extremely slow down scrolling around in the document once it was loaded.

@Markus:
Shouldn't a conditional style when pasted be merged with its neighbors if identical? Can we somehow detect and correct this mess during document load?

@Eduardo:
You could unprotect the sheets and invoke Format->Conditional->Manage and manually remove all the single formats and extend one of them to cover the needed ranges. It's quite a tedious task though.

(In reply to comment #3)
> Slowness is due to the massive amount (>1000) of conditional formats, most
> on sheets FT-ING-PR-02 and FT-ING-PR-03, many of them even applied to
> identical ranges. Looks like a result of heavy copy&paste actions, or the
> macro you mentioned creates them. All these conditionals also extremely slow
> down scrolling around in the document once it was loaded.
> 
> @Markus:
> Shouldn't a conditional style when pasted be merged with its neighbors if
> identical? Can we somehow detect and correct this mess during document load?
> 
> @Eduardo:
> You could unprotect the sheets and invoke Format->Conditional->Manage and
> manually remove all the single formats and extend one of them to cover the
> needed ranges. It's quite a tedious task though.

The password to unprotect is 123456. The macro create a conditional format when add a row. Never know how many rows will be add.

If you say the roblem is conditional format, I try to modify the macro to create only uone range of conditional format.

I report the changes.

(In reply to comment #3)
> Slowness is due to the massive amount (>1000) of conditional formats, most
> on sheets FT-ING-PR-02 and FT-ING-PR-03, many of them even applied to
> identical ranges. Looks like a result of heavy copy&paste actions, or the
> macro you mentioned creates them. All these conditionals also extremely slow
> down scrolling around in the document once it was loaded.
> 
> @Markus:
> Shouldn't a conditional style when pasted be merged with its neighbors if
> identical? Can we somehow detect and correct this mess during document load?
> 

We already do that if a document is imported and does not contain the new conditional format entries. However it is much more complicated during copy&paste as we have now conditional formats that rely on the range.

Take the simple example of a conditional format that just formats one column with a color scale. Now copying that column to the next one has two solutions for what we could do with the conditional formatting: merge and create ahuge one spanning two columns or create a second one that just spans this new column.

There will always be cases where one or the other solution are wrong.

Therefore we have now the manage conditional formatting dialog which helps the user to change the formatting or range if it is not what he expected.

Sadly I don't see a perfect solution here.

Sadly the UNO API does not reflect all the possibilities (I have to support the old one as it is published) and does not allow to modify the range of a conditional formatting currently.