Stel uw vraag

pmfrench's profiel - activiteit

2020-06-19 06:50:38 +0100 reageerde op een vraag I am retired. I have a bunch of .SAM files created in the 90's. Will LibreOffice allow me to access/open ami pro files?

Changing the file extention won't work. The file formats are different.

2020-06-18 07:23:10 +0100 beantwoorde een vraag I am retired. I have a bunch of .SAM files created in the 90's. Will LibreOffice allow me to access/open ami pro files?

Lotus SmartSuite runs on WIndows 10 for me. It will open .sam files. If you want to update the files, Lotus SmartSuite w

2020-04-28 10:19:22 +0100 badge ontvangen  Weten (bron)
2020-04-28 10:19:22 +0100 badge ontvangen  Goed Antwoord (bron)
2020-04-23 03:35:59 +0100 bewerkte een antwoord Is it a Page breaks Line ?

Are you referring to the dashed vertical lines? They show where the page breaks would occur if printed.

2020-04-22 10:15:56 +0100 badge ontvangen  Mooi Antwoord (bron)
2020-02-26 05:58:34 +0100 badge ontvangen  Leraar (bron)
2019-11-20 18:26:47 +0100 badge ontvangen  Beroemde vraag (bron)
2019-10-23 02:55:03 +0100 reageerde op een antwoord get grid lines to show in calc

The "grid lines" that showed in half the sheet were cell borders that were added through the Format/Cell dialog. They wi

2019-10-23 02:54:04 +0100 reageerde op een antwoord get grid lines to show in calc

The grid lines that showed in half the sheet were cell borders that were added through the Format/Cell dialog. They will

2019-10-23 02:51:48 +0100 beantwoorde een vraag get grid lines to show in calc

Tools menu, click Options, click the + in front of LibreOffice Calc in the left panel, from the expanded list

2019-05-12 22:11:09 +0100 beantwoorde een vraag in wp, I now have a 'line' to left of text. What is it? How remove?t

It sounds like you've accidentally activated the track changes feature. You can toggle it on or off with Ctrl+Shift+C

2019-02-24 08:48:54 +0100 badge ontvangen  Opvallende Vraag (bron)
2018-05-07 12:19:22 +0100 badge ontvangen  Populaire Vraag (bron)
2018-05-07 12:19:22 +0100 badge ontvangen  Opvallende Vraag (bron)
2018-05-07 12:19:22 +0100 badge ontvangen  Beroemde vraag (bron)
2018-02-07 21:01:04 +0100 badge ontvangen  Populaire Vraag (bron)
2016-11-27 06:45:11 +0100 badge ontvangen  enthousiast
2016-11-25 21:51:42 +0100 stelde een vraag Calc recalc (AutoCalculate) broken if autofilter was active during formula creation

I'm using Calc to clean up a listing. I have autofilter turned on to select a subset of records, then enter a formula in an adjacent column outside the filtered list to help isolate problems in the list. I've found that the results from the formula don't auto update when I edit items in the filtered list in ways that should cause the results to update. Pressing F9 to force an update has no effect unless the cell cursor is on the cell containing the formula.

A simple example:

In cell A1 enter "Letters" In cell A2 enter "ab" In cell A3 enter "abc" In cell A4 enter "ab" In cell A5 enter "abc"

With the cursor in one of those cells, select DATA/AUTOFILTER from the menus. From the drop-down arrow in cell A1, deselect ALL and tick the box in front of "abc", then click the OK button. The list should now show only the "abc" entries.

In cell C3, enter the formula =LEN(A3) Copy the forumla down to the row below which should be row 5. The results for both formulas should be "3"

Now if you edit the contents of A3 or A5 to change the length of the string, the results of the formulas in column C should auto update, but do not.

Using version 5.2.3.3 on Win 10 64bit installation. I tried it with version 5.2.x.x on a different machine and got similar, but not identical results. I believe that on that version the first edit to entries in column A did result in an updated result in column C, but subsequent edits in the filtered list in column A did not.

Other spreadsheets (Excel, SoftMaker's PlanMaker) do not have this issue.

(Subject edited slightly hoping to get it more clear by @Lupp )

2016-04-17 06:38:11 +0100 stelde een vraag Export to PDF in Calc prints unwanted sheets

If I have a file in Calc with multiple sheets, define a single Print Range on one sheet, and export to pdf, it exports all data on other sheets in addition to the data from the defined print range on its sheet.

If I print to a printer, only the print range prints -- no data from other sheets in the file. I would expect that export to pdf would follow the same convention. The only way I've found to get that result is to print to a virtual pdf printer rather than use the built-in export to pdf function in LO.

Am I missing something?