Haz tu Pregunta

perfil de default_abuser - actividad

2021-03-27 14:02:20 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-03-22 00:55:52 +0200 recibió una medalla  Taxonomista
2021-01-26 13:09:24 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-12-23 01:25:52 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

oh wow, thanks. I'll read up on it.

2020-12-22 22:31:46 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Thanks. I do understand this is all volunteer creation and that has its limits. I have no coding skills and while I've

2020-12-22 21:56:40 +0200 comentar pregunta Data > Sort: Enable 'Range contains column labels' by default

oh, it's a 5 year old documented bug: https://bugs.documentfoundation.org/show_bug.cgi?id=88402

2020-12-02 19:04:49 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

yep. Now every-time I try to print my receipt file, LO crashes. it corrupted my file and each time I reopen it it is r

2020-12-02 19:02:27 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

I tried this out a little bit and it has locked up LO and maybe corrupted my file, as I tinkered and tinkered trying to

2020-12-02 02:55:26 +0200 recibió una medalla  Pregunta Famosa (fuente)
2020-11-19 20:16:42 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Thanks for your help. I understand your concept, though my head has a hard time wrapping itself around this concept of "

2020-11-19 07:09:55 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-11-19 00:17:15 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-11-18 22:16:16 +0200 comentar respuesta Why is LO making .odb files whenever I data merge in Writer? and can I make it stop?

oh thanks. I'll give it a try, although the German scares me, not gonna lie.

2020-11-18 22:14:17 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Hold up...the .odb file thing is very confusing to me as a long-time MS Office user (where you just use spreadsheets for

2020-11-18 22:13:59 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Hold up...the .odb file thing is very confusing to me as a long-time MS Office user (where you just use spreadsheets for

2020-11-18 22:13:26 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Hold up...the .odb file thing is very confusing to me as a long-time MS Office user--I don't understand how it's making

2020-11-18 22:13:00 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Hold up...the .odb file thing is very confusing to me as a long-time MS Office user--I don't understand how it's making

2020-11-18 22:12:04 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Hold up...the .odb file thing is very confusing to me as a long-time MS Office user--I don't understand how it's making

2020-11-18 22:10:44 +0200 comentar respuesta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Hold up...the .odb file thing is very confusing to me as a long-time MS Office user--I don't understand how it's making

2020-11-18 20:42:13 +0200 editar pregunta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Please tell me there's a quicker way- Spreasheet to Shipping labels So my work database spits out excel spreadsheets tha

2020-11-18 20:37:54 +0200 realizó una pregunta Please tell me there's a quicker way- Spreadsheet to Shipping labels

Please tell me there's a quicker way- Spreasheet to Shipping labels So my work database spits out excel spreadsheets tha

2020-11-09 18:10:59 +0200 la mejor respuesta fue marcada VLOOKUP looking outside of my defined array

I've only deployed VLOOKUP on one file and it's been working fine using this guide until just now. My calculation appears in every cell in Column U and is this: =VLOOKUP(H777,V:W,1,0) where column H contains a unique customer identifier (account#) in each row for hundreds of rows, and anywhere in Column V is where I'd like the calculation to look for that identifier. Column V is where I temporarily paste unique identifiers of customers who made a transaction at our website. If it does not find the value from Column H in Column V, I want it to return an error. So, after pasting the account numbers of customers who made a transaction into Column V, I sort columns A:U by Column U -- which takes waaaaaaay too long -- but if I'm patient it brings to the top all the rows of customers who made a transaction -- where I can code/remove them. Except for the exceptionally bad lag on the Sort, that has worked.

But now even though Column V (and W) are completely empty, four lines of column U where the calculations live are returning a value, and instead of an error the rest of the cells are returning a 0. Now, I can live with the 0--no one's account number is 0 so that won't be a problem. But my calculation says "look in V:W" and yet V:W is completely blank and the calculation -- on only four rows!? -- is finding a value that can be found ONLY in column H. That is to say, when I ctrl+F on the value of the cell in column V that has been returned, the only place it finds that value is in column H. I just double checked my calculations and they indeed indicate the array is V:W.

How did I break it? Does anyone have a completely better and different way of accomplishing this, as I do not love this solution. Please help.C:\fakepath\BROKEN CALCULATIONS - data removed.ods

2020-11-09 18:10:56 +0200 comentar respuesta VLOOKUP looking outside of my defined array

Just CTRL+Shift+F9 solved the problem -- i feel entirely stupid. Some other helper on this board had instructed me to tu

2020-11-09 17:38:48 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-11-09 17:23:08 +0200 comentar pregunta VLOOKUP looking outside of my defined array

@Opaque Your solution requires me to abandon entirely what I've been working on and learn entirely new things. The best

2020-11-09 17:22:08 +0200 comentar pregunta VLOOKUP looking outside of my defined array

@Opaque Your solution requires me to abandon entirely what I've been working on and learn entirely new things. The best

2020-11-09 17:21:36 +0200 comentar pregunta VLOOKUP looking outside of my defined array

@Opaque Your solution requires me to abandon entirely what I've been working on and learn entirely new things. The best

2020-11-09 17:14:24 +0200 comentar pregunta VLOOKUP looking outside of my defined array

Just account IDs and I actually paste them only into V. I have no use for column W, an array simply needs to be at leas

2020-11-09 16:56:33 +0200 comentar pregunta VLOOKUP looking outside of my defined array

I've uploaded it. At this point, I'm just trying to figure out what went wrong so I can avoid it. In this case, I had

2020-11-09 16:55:33 +0200 editar pregunta VLOOKUP looking outside of my defined array

VLOOKUP looking outside of my defined array I've only deployed VLOOKUP on one file and it's been working fine using this

2020-11-07 20:08:45 +0200 recibió una medalla  Pregunta Popular (fuente)
2020-11-05 23:45:56 +0200 comentar pregunta VLOOKUP looking outside of my defined array

I've already been down that road: https://ask.libreoffice.org/en/question/271553/remove-duplicates-filter-is-hard-to-und

2020-11-05 23:32:21 +0200 editar pregunta VLOOKUP looking outside of my defined array

VLOOKUP looking outside of my defined array I've only deployed VLOOKUP on one file and it's been working fine using this

2020-11-05 23:25:26 +0200 editar pregunta VLOOKUP looking outside of my defined array

VLOOKUP looking outside of my defined array I've only deployed VLOOKUP on one file and it's been working fine using this

2020-11-05 23:24:00 +0200 realizó una pregunta VLOOKUP looking outside of my defined array

VLOOKUP looking outside of my defined array I've only deployed VLOOKUP on one file and it's been working fine using this

2020-11-05 22:53:16 +0200 comentar respuesta Why is LO making .odb files whenever I data merge in Writer? and can I make it stop?

I have no idea what to do with this on windows. Forgive my ignorance, but where's the .exe? I don't know how to compile

2020-11-04 12:11:16 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-11-02 18:21:39 +0200 comentar respuesta Frequent super lag when sort by column of calculations

2 does not help, not even a little bit, which I find surprising. Even with auto-calculate off, the big lag still occurs

2020-11-02 18:21:15 +0200 respondió a una pregunta Frequent super lag when sort by column of calculations

2 does not help, not even a little bit, which I find surprising. Even with auto-calculate off, the big lag still occurs

2020-11-01 13:59:57 +0200 recibió una medalla  Pregunta Notable (fuente)
2020-11-01 07:54:16 +0200 recibió una medalla  Pregunta Popular (fuente)